In Cognos 8.0, First create a Calculated Data Item, select the list, associate it with the Query in Which Calculated Data Item is created, then click on Structure and then List Header and Footers.
For the dynamic column, from the Insert menu, click Data and select the calculated column you created and insert it into the report. Reinsert the rest of the column headers insert text will work. This will remove the headers from your columns. Select Properties, and then click the Headers/Footers tab.
Highlight the report, and then right-click. Create a calculated column which contains the information that the header is to contain, such as "Report for year 1999" (concatenated text and date to string sub string extraction). So,we can view all levels through drill down develop same reports to another package.Ħ.How can I change reports to another package?Ī:Open that report and save as that report Select public folder and then select package in which package u want to save then save it.ħ.How to create a dynamic column name in Cognos? It occurs in cognos connection.ĥ.What is difference between drill through and drill down?Ī:Drill Through Allows u to Navigate From Summary TO Detailed Information.įor Example will do drill down on YEAR IF We Drill Down on this he next level Will Come means year contains Quarters, it contains A:By using the Framework Manager we can create measures and dimensions according to our business needs.Ģ.What is the difference between List and Crosstab?Ī:List report show data in rows and columns versus a cross tab report show data in grids with dimension in rows and columns and measures in cells or in the intersection points.ģ.What is the security module used in cognos?Ī:The security module used in cognos is cognos access manager.Ĥ.What is report burn and where it occurs?Ī:Report can be divided into different parts and sending these different parts of report to different users.
0 kommentar(er)
