what is the meaning of drill down and drill up in COGNOS 8BI
Answer Posted / vij
Drill down and Drill up is possible only if you have
Dimensional data .
In dimensional data there are 1 or more than one levels in
one dimension.
in that when u drill down for a perticular dimension then
it will show u the level below that main level.like from
summarised data to detaild data.
and for drill up viceversa.
Thanks
VIJ
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How can we create a dynamic column name in cognos?
Why are meta service important then other services?
What is main advantage datawarehousing over oracle?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
-----------Diff b/w OLAP and RDBMS?
What is defined as Query studio?
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?
What is model filter?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
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 are the steps to import the two data sources in framework manager?
What is Additive function?
how to perform back drill through in cognos 8 what is the use of it
4. How many dimensions did you use in your reports?