IBM Business Analytics

Hi ,
We have defined Named level in Tm1 Cubes hierarchy in }HierarchyProperties cube but the issue is attributes defined for the dimension are present in each level but they are not accessible at dimension or element level. I mean , you can not use directly rolevalue('attributename',Element) function. If you use this function it gives error like ..
Attribute use is not defined in the system. 

To make it use in report , we need to drag the attribute in the query and then use it. Then the problem here is , we have different attribute defined for each alternate heirarchy for same element. Ex One Element is present in 4 different alternate heirarchy at different level then each is having its own display value.
         T Year -Month is dimension , YTD,YTD,Month are alternate heirarchies, then named levels are defined as Total, year,Half,Quarter,Month. we can see no attribute is available here, all the attributes are within each levels. as shown below. But the if you refer element of Month level and use Member description attribute from Total level then report throwing error. Normally , attributes should be linked to element not the level from which element is appearing.

Is it possible somehow , to make the attributes available at the dimension level instead of inside the level defined.

I am not sure i have explained it properly. 

Report developing is complex, need to select different alternate heirarchy from the prompt page and then based on the selected drill path and drill level , report need to show that drill path and till the selected drill level with its respective attribute.


Thanks in advance for your help.

------------------------------
sumeet yadav
------------------------------

Anyone have any idea over this..

------------------------------
sumeet yadav
------------------------------

Original Message:
Sent: Mon December 05, 2022 09:29 AM
From: sumeet yadav
Subject: Attributes not available outside the named based Level if defined.

Hi ,
We have defined Named level in Tm1 Cubes hierarchy in }HierarchyProperties cube but the issue is attributes defined for the dimension are present in each level but they are not accessible at dimension or element level. I mean , you can not use directly rolevalue('attributename',Element) function. If you use this function it gives error like ..
Attribute use is not defined in the system. 

To make it use in report , we need to drag the attribute in the query and then use it. Then the problem here is , we have different attribute defined for each alternate heirarchy for same element. Ex One Element is present in 4 different alternate heirarchy at different level then each is having its own display value.
         T Year -Month is dimension , YTD,YTD,Month are alternate heirarchies, then named levels are defined as Total, year,Half,Quarter,Month. we can see no attribute is available here, all the attributes are within each levels. as shown below. But the if you refer element of Month level and use Member description attribute from Total level then report throwing error. Normally , attributes should be linked to element not the level from which element is appearing.

Is it possible somehow , to make the attributes available at the dimension level instead of inside the level defined.

I am not sure i have explained it properly. 

Report developing is complex, need to select different alternate heirarchy from the prompt page and then based on the selected drill path and drill level , report need to show that drill path and till the selected drill level with its respective attribute.


Thanks in advance for your help.

------------------------------
sumeet yadav
------------------------------

Can anyone help me over this . Is this the right platform to ask

------------------------------
sumeet yadav
------------------------------

Original Message:
Sent: Tue December 06, 2022 09:36 PM
From: sumeet yadav
Subject: Attributes not available outside the named based Level if defined.

Anyone have any idea over this..

------------------------------
sumeet yadav

Original Message:
Sent: Mon December 05, 2022 09:29 AM
From: sumeet yadav
Subject: Attributes not available outside the named based Level if defined.

Hi ,
We have defined Named level in Tm1 Cubes hierarchy in }HierarchyProperties cube but the issue is attributes defined for the dimension are present in each level but they are not accessible at dimension or element level. I mean , you can not use directly rolevalue('attributename',Element) function. If you use this function it gives error like ..
Attribute use is not defined in the system. 

To make it use in report , we need to drag the attribute in the query and then use it. Then the problem here is , we have different attribute defined for each alternate heirarchy for same element. Ex One Element is present in 4 different alternate heirarchy at different level then each is having its own display value.
         T Year -Month is dimension , YTD,YTD,Month are alternate heirarchies, then named levels are defined as Total, year,Half,Quarter,Month. we can see no attribute is available here, all the attributes are within each levels. as shown below. But the if you refer element of Month level and use Member description attribute from Total level then report throwing error. Normally , attributes should be linked to element not the level from which element is appearing.

Is it possible somehow , to make the attributes available at the dimension level instead of inside the level defined.

I am not sure i have explained it properly. 

Report developing is complex, need to select different alternate heirarchy from the prompt page and then based on the selected drill path and drill level , report need to show that drill path and till the selected drill level with its respective attribute.


Thanks in advance for your help.

------------------------------
sumeet yadav
------------------------------