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,
    {[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. Advertisements

  2. Rose

    Rose Guest

    This should be posted to ReportingServices group instead. My apology.
    Rose, Jan 31, 2006
    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.