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 dimnsion

I need to create a report in the follwing format
Customer
CustomerGroup1 CustomerGrp 2Custome Total
C3C5TotalC8C10C11
Amount
I am very new to MDX.
The customer dimension has the members c1,c2,c3, c4,c5,c6,c7,c9,10…………
Measures.Amount.
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.
Thanks.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |