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

how to use attribute value in calculation - urgent

Started by cognos05, 11 Feb 2021 02:15:43 PM

Previous topic - Next topic

cognos05

Hi ,

I have a time dimension with month and year levels in transformer. I supply feb 2021 as load file and then transformer creates the time hierarchy. Now I had a another file which loaded 2 attribute values like FYTD days and FYTDCUrrentDay to the months level on the current period value.

i wanted to able to retrieve these number from the attribure value to be used for soem calcuations,

I see the attribute values in analysis studio under description and shortname, but i am not sure how to use it in report studio to get the value stored in that attribute.
Value is stored under feb2021 month member under short name and member description.

Any help is appreciated.

cognos05

#1
I tried rolevalue('memberdescription,[2021 feb]) and this gave me 155 . Is this the right approach to get the attribute value of  a member . I have this and works  fine on a singleton element '

cast(roleValue ('_memberDescription',[2021/Feb]) as int)
/
cast(roleValue ('_shortName',[2021/Feb]) as int)


but the moment i try to bring it in the cross tab to use across my sales value it doesnot like that .

MFGF

Quote from: cognos05 on 11 Feb 2021 03:57:56 PM
I tried rolevalue('memberdescription,[2021 feb]) and this gave me 155 . Is this the right approach to get the attribute value of  a member . I have this and works  fine on a singleton element '

cast(roleValue ('_memberDescription',[2021/Feb]) as int)
/
cast(roleValue ('_shortName',[2021/Feb]) as int)


but the moment i try to bring it in the cross tab to use across my sales value it doesnot like that .

Hi,

Are you trying to use these attributes as measure values? I don't think that's going to work. Is there a reason you haven't added them to the cube as measures?

Cheers!

MF.
Meep!

cognos05

They are not like actual measures right , my use case is
                  Quota  Sales   (154/254)*Sales-Quota
Customer

so is this total fytd days and total fytd days completed not an attribute of any time .

I can use it as a seperate measure ,but do i load the measure to which dimension?

Thanks,

cognos05

All I need is to capture the completed business days and total numbe rof business days for current year.

And be able to use that ina  report calculation to see what pace the custoemr has reached.

So the question is does this values have to be stored as a measure or an attribute of a time member .

Any suggestions is appreciated.

MFGF

Quote from: cognos05 on 17 Feb 2021 01:46:42 PM
All I need is to capture the completed business days and total numbe rof business days for current year.

And be able to use that ina  report calculation to see what pace the custoemr has reached.

So the question is does this values have to be stored as a measure or an attribute of a time member .

Any suggestions is appreciated.

Hi,

You're measuring customer pace using these values? They need to be measures to use them in the way you're describing.

Cheers!

MF.
Meep!