Author Topic: how to use attribute value in calculation - urgent  (Read 284 times)

Offline cognos05

  • Statesman
  • ******
  • Join Date: Apr 2014
  • Posts: 728
  • Forum Citizenship: +1/-1
how to use attribute value in calculation - urgent
« on: 11 Feb 2021 02:15:43 pm »
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.
« Last Edit: 11 Feb 2021 02:29:12 pm by cognos05 »

Offline cognos05

  • Statesman
  • ******
  • Join Date: Apr 2014
  • Posts: 728
  • Forum Citizenship: +1/-1
Re: how to use attribute value in calculation - urgent
« Reply #1 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 .
« Last Edit: 11 Feb 2021 04:27:51 pm by cognos05 »

Online MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,202
  • Forum Citizenship: +662/-10
  • Cognos Software Muppet
Re: how to use attribute value in calculation - urgent
« Reply #2 on: 12 Feb 2021 08:26:33 am »
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!

Offline cognos05

  • Statesman
  • ******
  • Join Date: Apr 2014
  • Posts: 728
  • Forum Citizenship: +1/-1
Re: how to use attribute value in calculation - urgent
« Reply #3 on: 12 Feb 2021 08:49:31 am »
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,

Offline cognos05

  • Statesman
  • ******
  • Join Date: Apr 2014
  • Posts: 728
  • Forum Citizenship: +1/-1
Re: how to use attribute value in calculation - urgent
« Reply #4 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.

Online MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,202
  • Forum Citizenship: +662/-10
  • Cognos Software Muppet
Re: how to use attribute value in calculation - urgent
« Reply #5 on: 17 Feb 2021 03:22:08 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!