How many number of cubes can we create on a single model?
How can we navigate between those cubes?
Answers were Sorted based on User's Feedback
Answer / mcmohan
Using a single Model , we can create as many number of
cubes u want.By using the dimension views...etc.
regarding the navigation, wen we save cubes , these act as
separater multidimensional databases. ther wont be any
relations. navigating means opening the cubes separately.
Thanks
Mc
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
what is Galaxy schema??
i would like enter some empty space after every 3 rows how is it possible....?
These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com
HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?
What is the basic relationship between measures and dimensions in transformer modelling
Explain is there any comparison available for cognos reportnet vs crystal reports?
Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!
What is meant by drill down?
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
What is the use of Tree Prompt? Where it is used?Pls give me a real time example?