Hierarchy structure of ssas cube

Shilpikumari12 — Wed, 03 Apr 2019 19:09:38 GMT

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

Re: Hierarchy structure of ssas cube

LinusH — Wed, 03 Apr 2019 20:28:16 GMT

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

Re: Hierarchy structure of ssas cube

Shilpikumari12 — Thu, 04 Apr 2019 08:52:32 GMT

Ah i hope so... thanks

topic Hierarchy structure of ssas cube in SAS Data Management

Hierarchy structure of ssas cube

Re: Hierarchy structure of ssas cube

Re: Hierarchy structure of ssas cube