What is Star schema group?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of cognos decision stream?

650


I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

1669


what are the features in cognos8ui

1548


What is the difference between a cascading report and drill through the report?

717


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.

4067






What do you understand by the term 'aggregate advisor?'

527


Why cognos scenario is used?

568


Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1466


What is meant by Reportstudio shortcut?

1712


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1647


2. What functional area you worked on.

1901


When we save a report in report studio with what extn it save?

642


7. What is performance tuning?

1563


what is the difference between querystudio in reportnet and cognos8

1724


What is the function of model design accelerator?

524