Answer / ven

By using the Framework Manager we can create measures and
dimensions according to our business needs.

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

1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?

0 Answers   Wipro,

---

how to create measures and dimensions?

0 Answers   IBM,

---

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

0 Answers  

---

where we use page break  and page set. with example?

1 Answers   CNSI, IBM,

---

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

7 Answers   Genpact, iFlex, TCS,

---

---

what is the difference between querystudio in reportnet and cognos8

0 Answers   CTS,

---

How do you improve the performance of the Cognos Analytics report

0 Answers  

---

-------------------What is StarShema?

1 Answers   Cap Gemini,

---

What is the size of the cube?

0 Answers  

---

How to upgrade drivers in Cognos 8?

1 Answers  

---

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.

0 Answers   DELL,

---

what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running

2 Answers   IBM,

---