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)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

0 Answers   Mphasis, TCS,

---

What is meant by report studio short cut?

2 Answers  

---

how u create security to reports ????

10 Answers   iFlex, iGate,

---

If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.

4 Answers   IBM,

---

What is a Complex report and explain?

4 Answers   IBM, Satyam,

---

-----------Diff b/w OLAP and RDBMS?

0 Answers   Bank Of America,

---

What are the different ways of adding data in Transformer?

3 Answers   Cognos, IBM,

---

Define report item?

0 Answers  

---

what is the difference between group and association?

5 Answers   IBM,

---

8. Can you use calculations in report headers and footers? How?

1 Answers  

---

diff b/w layout calculation and query calculation

2 Answers   Cap Gemini,

---

----------------What is meant by DSS?

1 Answers   Bank Of America,

---