Answer / mow

Depending on the project it varies...
in general 3 - 4 facts and 15 - 20 dimensions can be there
in a medium scale project

Answer / palzkumar

NOT more than 16 Dimension.
cuz a Fact table can have maximum 16 foreign key only.

-palz-

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  

---

what is an sid (surrogate key)?

2 Answers   IBM, Oracle,

---

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

---

how data modeling is usefull to cognos?

1 Answers  

---

What are all types of prompt?

1 Answers  

---

what are the types of facts ? explain them?

2 Answers   Business Objects, Informatica, Syntel, Teradata,

---

i was asked what are the caluclations done by you in your report? plz give reply

0 Answers   IBM,

---

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

---

What is Outerjoin?

2 Answers  

---

what is the meaning of drill down and drill up in COGNOS 8BI

3 Answers  

---

how to get the all values from a prompt using 'ALL' use and display value in prompt

3 Answers  

---

What is value prompt limitations while creating report? What is select and search prompt?

1 Answers  

---