BookmarkSubscribeRSS Feed
Shilpikumari12
Calcite | Level 5

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

ProductClothwomanlargewesternJaket

 

ProductClothwomanlargewesternKurti
ProductClothwomanSmallindianT-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

 

 

2 REPLIES 2
LinusH
Tourmaline | Level 20
So is there a SAS angle here?
(Or did you simply mistaken this as ssascommunities 😯)
Data never sleeps
Shilpikumari12
Calcite | Level 5

Ah i hope so... thanks

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 727 views
  • 0 likes
  • 2 in conversation