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

Is there a way to reference query calculation in another report?

Started by Suraj, 03 Jun 2015 03:26:26 PM

Previous topic - Next topic

Suraj

Here is the situation.
We have a package that's maintained by external contractor and the package serves more than one companies so package can't be updated for us.
We have several reports with huge case statements (same/similar calculation) and they frequently change depending upon various conditions like business cycle, time of year etc... that we need to manually update as there is no way to make them dynamic.

Now the question is, is there a way to calculate that in one report and somehow reference it in all reports so we can only change at one place?
I checked layout component reference but it needs to copy the data items to bring the list in that doesn't serve anything.
If there is a way to get reference link directly to a data item in another report, that'll make it a lot easier.
Thanks for any idea.

MFGF

Quote from: Suraj Neupane on 03 Jun 2015 03:26:26 PM
Here is the situation.
We have a package that's maintained by external contractor and the package serves more than one companies so package can't be updated for us.
We have several reports with huge case statements (same/similar calculation) and they frequently change depending upon various conditions like business cycle, time of year etc... that we need to manually update as there is no way to make them dynamic.

Now the question is, is there a way to calculate that in one report and somehow reference it in all reports so we can only change at one place?
I checked layout component reference but it needs to copy the data items to bring the list in that doesn't serve anything.
If there is a way to get reference link directly to a data item in another report, that'll make it a lot easier.
Thanks for any idea.

Sadly not. The idea is to have centrally-managed calculations like this defined in the metadata model. If you can't do this, you're going to have to define the calcs in each report.

MF.
Meep!