Interested to Buy Any Domain ? << Click Here >> for more details...
How to create measures and Demensions?
- 2 Answers
- 7212 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 |
What are variable report studio?
how u create security to reports ????
1. Explain your project.
What is model filter?
What is difference between informatica power mart and power center?
What are the roles defined by cognos platform?
How to apply securities for reports in cognos connection?
Write some methods to apply securities in framework manager model?
-------------------What is StarShema?
1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?
what are determinants?
Mention the difference between ‘macros’ and ‘prompt’?
Teradata 
