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.
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 .
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.
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,
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.
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.