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
... View more