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 |
How to publish a package by running Java Script?
What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.
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.
What errors and types of errors you faced in Cognos ReportNet?
What do you mean by drill through report?
How to deploy from one server to another server?
Difference betwween cognos report net architecture and cognos8 architecture
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
how you provide security to reports? How you provide security to packages ?
Define cognos report net?
what is exact catalog size?
What is called a slice?