SQL Server Performance

MDX Newbie -Create 2 columns from same member of the dimnsion

Discussion in 'SQL Server 2005 Reporting Services' started by Buddha, Dec 8, 2008.

  1. Buddha New Member

    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.

Share This Page