What is Star schema group?



What is Star schema group?..

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

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Cognos Interview Questions

How can we convert imr report into Impromptu web report?

3 Answers  


What is Online View?

0 Answers   IBM,


5. Which type of report you build more, list, crosstab or chart and why?

0 Answers   IBM,


What are the steps involved in migrating CRN enviroment to Cognos 8?

3 Answers   BMW, Goyal Group, Mersan,


----------How to cretae a Template?

4 Answers  






What is zero-foot print?

0 Answers  


what is a join? what are the types of joins?

5 Answers   HCL, Satyam,


how to convert crosstab into list?

4 Answers   TCS,


Can you define dimension?

0 Answers  


What is called Cognos powerplay?

0 Answers  


Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

0 Answers  


Categories