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


Please Help Members By Posting Answers For Below Questions

How can we create a dynamic column name in cognos?

539


Why are meta service important then other services?

588


What is main advantage datawarehousing over oracle?

562


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10751


-----------Diff b/w OLAP and RDBMS?

1622






What is defined as Query studio?

619


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?

1682


What is model filter?

632


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?

1534


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

720


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 ?

1687


What are the steps to import the two data sources in framework manager?

618


What is Additive function?

1561


how to perform back drill through in cognos 8 what is the use of it

2036


4. How many dimensions did you use in your reports?

1494