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

calculate and edit font in relational package

Started by tequila, 28 Aug 2015 07:51:23 AM

Previous topic - Next topic

tequila

Hello,

i have two questions:

A

i have crosstab in relational package -

1. element - scenario (contain  - current value; plan value)
2 element - year  (2014; 2015; 2016....)

how can I separate e.g. scenario/year in two various elments (current value; plan value) to calculate for example current - plan or 2015 - 2014
In dimensional package i work with MUN but how do it here in relational package?

B
how can i edit on specific element of my report result. E.g. City (London; Paris, Berlin, Rome etc..). It is possible bold, framework, Background one specific element... e.g city Paris for example?

and sorry for my bad english

thank


cognostechie

A - You can pit Current and Plan as separate measures in the columns. I presume you will have those two measures already built in the package. If not, you will have to find out what identifies Current and what identifies Plan and then split them into separate measures with a Case statement

B - You can define a conditional variable and use that for conditional formatting.