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

Expression code refer to Name of Data Item

Started by ag, 13 Oct 2013 09:13:12 PM

Previous topic - Next topic

ag

All,
Is there a way to have code in an expression that refers to the name of the data item icon?
for example:
IF ([Business Layer].[Earnings Check History].[Earnings Code]=DataIconName  ) THEN
    ( [Business Layer].[Earnings Check History].[Current Amount])
ELSE
    (0 )

thanks in advance,
Andy

blom0344

IF ([Business Layer].[Earnings Check History].[Earnings Code]='some_value'  ) THEN    ( [Business Layer].[Earnings Check History].[Current Amount]) ELSE     (0 )

You have to refer to a specific value of Earnings Code to get a parsing If Then Else  expression

ag

yup, normally I would hardcode in the name of the earning code I want the $ amount for. But, some clients have 100+ earning codes which means 100+ columns and each one have to edit to put in the code. So, if there was a way to just update the name of the icon and refer to the icon in the expression, then I could shorten my dev time in 1/2...

blom0344

No idea what you mean with  'icon' . Why do you not use a prompt to feed the right value to the query  ?

Lynn

I am confused by the reference to "icon" in your question also. Are you trying to transpose rows of data into columns? If so, would a crosstab layout work as an alternative? If you create 100 query calculations and then come across a situation where there are 101 you'd have a problem.

ag

sorry, obviously doing a poor job describing what i need. i will try again.
1. In Query Explorer, I have a Query.
2. Inside this Query, I have Data Items.
3. I dragged a new Data Item from the Toolbox into the Query.
4. I named this new Data Item 'Overtime'
5. Inside the expression for the data item, I have code that basically says if earning code in the dbase = overtime then show me the $ amount.
6. I am looking for a way to change the code to refer to the name of the Data item the code is in. So, if earning code in dbase = nameOfThisDataItem then show me the $ amount.

hope that makes more sense!