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

Can you refer to singletons in a data expression?

Started by mp3909, 20 Apr 2021 01:31:18 PM

Previous topic - Next topic

mp3909

Hi,

I wanted to know how to go about referencing singletons?

For example, I have a query called q1.
Inside q1, I have a data items called d1, d2, d3.
And in my report I have singleton s1 and s2

I want to write an expression for d1 so I click on data expression and inside there, I want to write a case when statement like the following:

CASE
WHEN [q1].[d2] = 'X' then s1
WHEN [q1].[d3] = 'Y' then s2
END


Is this possible?

Thanks in advance.