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 |
How can we convert imr report into Impromptu web report?
What is Online View?
5. Which type of report you build more, list, crosstab or chart and why?
What are the steps involved in migrating CRN enviroment to Cognos 8?
3 Answers BMW, Goyal Group, Mersan,
----------How to cretae a Template?
What is zero-foot print?
what is a join? what are the types of joins?
how to convert crosstab into list?
Can you define dimension?
What is called Cognos powerplay?
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 ?
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.