Parent child Hierarchy - name column

Question

Can anyone suggest the following.

I have Parent-child hierarchy(SSAS 2008 R2) with the attribute names as NodeId,Node Description and ParentId. The whole hierarchy works well at the moment. The suggestion i need as I would like to display the unique value as [Organisation Hierarchy].[Organisation Hierarchy].&[UK Life Staff Pension Scheme LE- SPS1_SPS1] instead of [Organisation Hierarchy].[Organisation Hierarchy].&[510].

I tried to change Name value for ParentID attribute but didn't get the expected result.

Also tried memberUniqueNameStyle property in cube dimension to NamePath. In this case, i got the full hierarchy path as [Organisation Hierarchy].[Organisation Hierarchy].[Group].[Region].[UK Life Staff Pension Scheme LE- SPS1_SPS1]. I dont want to get full path of the hierarchy.

 

Thanks in advance!!

Answer 1

You will not get this as the Unique Key for the Parent-Child hierarchy is the filed upon which the hierarchy is built. Therefore  you receive the unique value in the form of [Organisation Hierarchy].[Organisation Hierarchy].&[510]

If change the MemberUniqueNameStyle then you receive [Organisation Hierarchy].[Organisation Hierarchy].[Group].[Region].[UK Life Staff Pension Scheme LE- SPS1_SPS1]. But notice, thre is no "&" prior the [UK Life Staff Pension Scheme LE- SPS1_SPS1] as the [UK Life Staff Pension Scheme LE- SPS1_SPS1] is name and not the Key. The "&" sign denominates a Key so thefore it is as it is.

Answer 2

Hello Pavel,

Thanks for the response.

My real scenario is follows. I have a report with couple of parameters along with Organisation hierarchy(parent-child hierarchy with dunamic security). I am using excel to save the report in a path using URL by passing parameters. As of now, i am able to pass other parameters through URL(HTML viewew) except Organisation hierarchy. Now, users are requested to add Organisation Hierarchy parameter to the URL. User can give input in excel as 'UK Life Staff Pension Scheme LE- SPS1_SPS1'. I am transforming this value as [Organisation Hierarchy].[Organisation Hierarchy].[Group].[Region].[UK Life Staff Pension Scheme LE- SPS1_SPS1]. Then, Its not wroking. Unless I pass the parameter value as [Organisation Hierarchy].[Organisation Hierarchy].&[510], i cannot run/save the report through URL.

Its difficult for users to find the Key value(in this case 510) for the Node 'UK Life Staff Pension Scheme LE- SPS1_SPS1' as this Key is maintained in warehouse database only.

I need help to pass the Organisation Hierarchy parameter value through URL. I can change the parameter dataset or actual dataset which returns the data if requied.

Thanks in Advance!!

Krishna