Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by Drill down and Drill Up?
tell me two or three issues from client side and how to solve those issues?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
what are the errors faced while bursting the reports and how to solve those errors?
Can you explain new content durability?
please please give me some banking calculations in framework manager.
What is the use of cognos decision stream?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
how can I test reports in cagnos?
Can you define query studio?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What you mean by drill across and what is the difference between drill through, drill across?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?