Hierarchy structure of ssas cube

[Shilpikumari12]

Hello Team,

Currently i am working on ssas cube. I have one concern that i want to use four different columns data which is as hiearchy structure. Now i want to put in same dimenstion and when i will access to target source like excel then i will use only one column and it will shows me child levels data as well.

Like i am showing some example:

there are 6 columns

Parent               child1          Child2          Child3          Child4          Child5

Product

Cloth

woman

large

western

Jaket

Product

Cloth

woman

large

western

Kurti

Product

Cloth

woman

Small

indian

T-shirt

So Now i am going to use this hiearchy in cube and target system is excel.

'=cubemember("ODBC database";"[Parent].[T-Shirt]or[Kurti]OR[Product]") (This is what i want with target system).

Any assistance is appreciated. 

Thanks in advance,

Regards,

Shilpi

Data analyst

[LinusH]

So is there a SAS angle here?
(Or did you simply mistaken this as ssascommunities 😯)

[Shilpikumari12]

Ah i hope so... thanks