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
Ah i hope so... thanks
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.
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.