How to create measures and Demensions?

Answers were Sorted based on User's Feedback



How to create measures and Demensions?..

Answer / ven

By using the Framework Manager we can create measures and
dimensions according to our business needs.

Is This Answer Correct ?    4 Yes 0 No

How to create measures and Demensions?..

Answer / palzkumar

Question is bit confusing..

First of all, when you design model in FMW, you will derive
new (calculated) measure thru existing KPI/Measure. Like
Qty, Sales Amt, Rate, Discount etc. From this KPI, you can
derive new measure.

Otherwise, when you design DM for a organization, you need
to study the sytem, you define Dimension, where all master,
and heirachies are there. Difine a Fact Table with All KPI,
Measures/Numbers.

And then you join PK in Dimension Tables with FK in Fact
Table.

This is dimensional modeling in dw. this db can used in
FWM, to create package, where you create calculated measure.


rgds,
palz

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Cognos Interview Questions

------------ Diff b/w MemberCaption and MemberDescription?

0 Answers  


what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?

2 Answers   IBM,


Can you explain new content durability?

0 Answers  


how to find the rank in report studio? i need steps for this question.

2 Answers  


if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

0 Answers  






how to improve performance in report studio level

1 Answers   Wipro,


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

0 Answers  


what is logs in cognos

1 Answers   HCL,


How can we migrate from Businees Objects reports to Cognos 8.x??

1 Answers  


What is a Cube?

0 Answers  


what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly

2 Answers   TCS,


What is the difference between macro & Parameter

1 Answers   IBM,


Categories