If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Summary - Detail Report on OLAP based reports

Started by gicy, 26 Jan 2009 09:32:08 AM

Previous topic - Next topic

gicy

Hi,
Here's the detail:

Cognos Environment: 8.3
Studio: Report Studio
Source: OLAP (Transformer Cube based Package)
Requirement:  Detail Report in New Window when user clicks on Detail Report link from Summary Report. The detail report should filter  based on the current hierarchy level of Dimension.(Both Product and Time Dimension). For, simplicy, I have taken example of only Product Dimenion.
Use of Java Script: If not possible with Cognos inbuilt drill through functionality, then its okay to use Java Script
Cognos 8.3 Sample: ‘Sales and Marketing’ Package published using Cognos Cube.
The First Report screen isâ€" Product Summary Report. The summary is at the Product Line level (The highest in the hierarchy) and Year level for Time dimension.
In this screen, if user clicks on ‘Detail Report’ link, then a Detail report for all the product lines would open in a new window.
Next, let’s say, if user drills down on Personal Accessories product line, then in the summary report, you get data of only that Product line.
If user clicks on Detail Report link, he should get detail report of only Personal Accessories.
And so on…..This way, user can drill up and drill down at any level and a detail report should give you data based on the current level of hierarchy in the summary Report.
Note: I have explained and took the screen print and example for Product Dimension only.
Actually, User will also drill up and drill down on the Time dimension as well. So, the detail report should filter based on the current level of Product and Time dimension in the summary Report.

I hope to get some help on this.

Thanks