Interested to Buy Any Domain ? << Click Here >> for more details...
How to create measures and Demensions?
- 2 Answers
- 7334 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?
1 Answers IBM, Thomson Reuters,
What is slowely changing dimensions?why we are used SCD?
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
Explain difference between powerplay transformer and power play reports?
What are the differences between cognos 8.2 and cognos 8.4? Please help me..
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
i have a table with 3 columns country,empname,salary and i want the query for get the name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance
advantages of cascade prompt ???
How to select all in value prompt instead of cascade prompt?
Can you define drill across?
What is meant by alternate drill down with ex?
Teradata 
