Interested to Buy Any Domain ? << Click Here >> for more details...
How to create measures and Demensions?
- 2 Answers
- 7340 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 is Direct and Conventional loading?
in u r data u having duplicates how to fetch the latest data in our report?
is there any difference between operational database and data base?if yes what r they?
im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?
what is exact catalog size?
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
Hi i want know mean and difference b/w render variable,conditional block and style variable please reply about them please be kind towards me
---------------Can we use more than 1 Fact table ?
what is boxtype
What is Crossproduct?
What is RenderVariable?
How can we find out cardinality between two tables?
Teradata 
