How to GROUP on (null)/Nothing for datasets from Analysis Services

Discussion in 'microsoft.public.sqlserver.olap' started by Rose, Jan 31, 2006.

  1. Rose

    Rose Guest

    I have a matrix with Row Groups based on a Ragged Hierarchy, i.e. there
    are 'holes' in the hierarchy.

    The scenario is easily reproduced on Adventure Works by
    1. adding 2 new Product Categories (Category A, Category B)
    2. adding 1 new Product Subcategory (Subcategory X), associated to
    Category A
    3. build a matrix report with

    SELECT { [Measures].[Internet Sales Amount] } ON COLUMNS,
    { GENERATE(DESCENDANTS([Product].[Product Categories].DefaultMember, 1,
    SELF_AND_AFTER),
    {[Product].[Category].CURRENTMEMBER} *
    [Product].[Subcategory].CURRENTMEMBER *
    [Product].[Product].CURRENTMEMBER) } ON ROWS
    FROM [Adventure Works]
    WHERE {[Product].[Product Categories].[Category].&[2],
    [Product].[Product Categories].[Category].&[5],
    [Product].[Product Categories].[Category].&[6]}

    You will notice that all the [All Products] cells returned in MDX show
    up as (null) in Reporting Services and Groupings on these fields will
    behave strangely.

    Is there a solution or workaround to this problem?
     
    Rose, Jan 31, 2006
    #1
    1. Advertisements

  2. Rose

    Rose Guest

    This should be posted to ReportingServices group instead. My apology.
     
    Rose, Jan 31, 2006
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.