Interested to Buy Any Domain ? << Click Here >> for more details...
How to create measures and Demensions?
- 2 Answers
- 7208 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 |
Can you define folder?
what is materialised view? why we use it in data warehousing?
What is a dimension?
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........
Write types of folders present in cognos?
If anyone has COG-185 IBM Cognos 8 Migration Professional Certification Dump, please mail me at: sushma_biswas@yahoo.com
What is the complex report you faced in real time?
-----------Diff b/w OLAP and RDBMS?
Can you define set to be cardinality?
what is the difference between count and running-count functions?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
Teradata 
