Answer / lakshmi

Using Star schema grouping we can resolve the ambiguous joins
if there is more than one path exists between query
subjects then we may get wrong data to overcome that one we
have to identify where the loop is occured then select the
query subjects right click create star schema grouping then
it will ask name space if u give any name for that then
click k then one Alias Shortcut is created for the entire
query subjects whatever you selected which is nothing but
phisically exists and which is used to resolve the loops

when can i use the STAR Schema and SNOWFLAKE Scgena

4 Answers   IBM,

---

How to Improve the Performance of the Report? i need this urgently .

4 Answers   HSBC,

---

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

0 Answers   Infosys,

---

How can we find out cardinality between two tables?

3 Answers   Dominion,

---

What are the components of the report studio?

0 Answers  

---

difference between join and union in reportstudio?

2 Answers   IBM,

---

advantages of cascade prompt ???

7 Answers   iFlex, Oracle,

---

---------------How to identify First Record and Last Record?

2 Answers  

---

what are ERP systems?

1 Answers  

---

Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith

2 Answers  

---

Define the slice and dice?

0 Answers  

---

what is the difference b/w mdx and sql?

4 Answers   Cap Gemini, IBM,

---