|
Home > Archive > MS SQL Server OLAP > January 2006 > How to GROUP on (null)/Nothing for datasets from Analysis Services
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to GROUP on (null)/Nothing for datasets from Analysis Services
|
|
|
| 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?
| |
|
| This should be posted to ReportingServices group instead. My apology.
|
|
|
|
|