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 Here ive question on Reportnet when we save a report in reportstudio with what ext it save
What are the advantages and disadvantages of using Transformer cube?
Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer
wt is tupple , Embed function ? wt is regular dimension ?
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..
What snowflake and Starschema?
is cognos 7 is better than cognos 8
what are versions of cognos from starting release to latest in the market?
What you mean by drill across and what is the difference between drill through, drill across?
Write various indexes used in cognos?
What is meant by junk dimension?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?