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.