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

 

How to derive calculation in cognos WSA using relational packages

Started by gurralakrishna, 22 Nov 2016 10:32:34 PM

Previous topic - Next topic

gurralakrishna

Hello All,

We have a requirement from business i.e We need to add the calculation based on existing data items in Cognos work space advanced(WSA) using relational package
But we have tried it seems to be not possible using relational packages. However same we can  able to add the calculation in WSA  if it's a Cube package as source (OLAP) .

Can you please let us know  how  to add the calculation based on existing  data items in WSA using relational package?

Please let us know this feature in feasible in WSA using Relational package ? Thanks in Advance.

Regards,
Krishna.

MFGF

Quote from: gurralakrishna on 22 Nov 2016 10:32:34 PM
Hello All,

We have a requirement from business i.e We need to add the calculation based on existing data items in Cognos work space advanced(WSA) using relational package
But we have tried it seems to be not possible using relational packages. However same we can  able to add the calculation in WSA  if it's a Cube package as source (OLAP) .

Can you please let us know  how  to add the calculation based on existing  data items in WSA using relational package?

Please let us know this feature in feasible in WSA using Relational package ? Thanks in Advance.

Regards,
Krishna.

Hi,

I'm guessing the columns in your relational report are values from a single query item in your package? If so, you're going to have to "bucket" the measure values with individual calculations before you can perform the calculation you desire

eg, create a calculated value for FC Current Month
if ([your columns query item] = 'FC Current Month') then ([your measure value]) else (0)

create a second calculated item for Actual previous year
if ([your columns query item] = 'Actual previous year') then ([your measure value]) else (0)

Now you can use these two items in your calculation

[your first calculated item above] + [your second calculated item above]

These are the kinds of situations where a dimensional package makes reporting so much easier :)

MF.
Meep!