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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.