How to create measures and Demensions?
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 |
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
-------------What is a Conformed Dimension?
what is the use of lock and unlock
Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance
What is use of Field Set present in toolbox?
What are the batches and it’s details?
When we save a report in report studio with what extn it save?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
How applying "Level Span" in Cognos 8.3?
What are all the types of gateway used in Cognos?
How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?