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

Make a calculation dependant on name of report page

Started by Fame, 04 Feb 2014 07:23:52 AM

Previous topic - Next topic

Fame

Hi experts,

Here's the situation: For one of our customers, we've designed a "consolidated" report and a "per site+consolidated" report.

Up until now those 2 reports were set up exactly the same in calculation, layout and content, except ofcourse for the filter on site level for the "per site" page. The "per site" report shows a "per site" page for all available sites and adds the consolidated page at the end of the report. The consolidated report only shows "consolidated" page.

A few hours ago, a change request came in to add site-related percentages to the page. This way, the managers can set the expectations per site. For the consolidated report however, they are opting (for now, cause it ain't the best solution) to take the average of all the percentages per site. This is were my problem starts. I can ofcourse duplicate the percentage field data-item: one for the consolidated page, one for the per site page. But that would ofcourse also mean that I'll have to duplicate all the rows that are using this value... And thus kill the report maintainability. Unless ofcourse there is an easy way to address the name of the report page in the expression definition page to keep the name generic independant of the page the calculation is used upon..

Is there an easy way to do this ?
Thank you for you expertise!