MDX Newbie -Create 2 columns from same member of the dimnsion | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
MDX Newbie -Create 2 columns from same member of the dimnsionI need to create a report in the follwing format
CustomerCustomerGroup1 CustomerGrp 2Custome Total
I am very new to MDX.
The customer dimension has the members c1,c2,c3, c4,c5,c6,c7,c9,10…………
I need to create 2 columns from the customer dimension and have totals for both group .(Trying to create a grouping for customer)
I know I can have the reporting format with matrix, but how can I create 2 columns from the same dimension in MDX . I am looking for a solution at a query level just like we do in SQL.
With my limited knowledge whatever I try, it will pull all the members to the same column. Does a union work . If so ,can some one guide me through.
I would appreciate an immediate response. If nothing works at a query level, I have to request for adding another dimension/grouping.