Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the types of folder present in cognos?
What are the two types of framework manager?
What is the complex report you faced in real time?
hi friends pls forward impropmtu interview question
How we check the errors before running the report?
Can you explain model durability?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What are all the components of Report Studio?
Can you define slice?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
Can you define metrics designer?
Why need staging area database for dwh?
What is defined as Cognos Impromptu?
what is the procedure for scheduling conditional rendering?
How can you link a query to a data container manually in Report Studio?
