Hi,

i have some problems with an element list from a dimension in Visual Studio .NET.
We work with OLAP (Microsoft Analysis Server an Microsoft Reporting Services SP1). We would like generate an list of members from an dimension for an filter in our report. When i run the following MDX in der Microsoft MDX Sample Application we receive the result that we want. But when i run this MDX in the Visual Studion .NET Report Designer we recive all Members of the Dimension but for the
Member "All Products" we receive an empty field.

MDX Command:

WITH MEMBER Measures.NullColumn AS 'Null'
SELECT
{ Measures.NullColumn } ON COLUMNS,
{ [Products].AllMembers } on rows
FROM "Sales Cube"

Result in MDX Sample Application: (Thats correct)

"ALL Products"
"Product A"
"Product B"
"Product C"
"Product D"
a.s.o.

Result in Visual Studio .NET 2003:

" "
"Product A"
"Product B"
"Product C"
"Product D"
a.s.o.

Maybee have anyone an solution.

Thanks in advance...
Stephan

Thanks Brian,

which Document you meen with BOL ???

Greetings ....



Subject: RE: MDX Result ... (02-Aug-2004 14:49)
From: Brian Altmann
To: microsoft.public.sqlserver.olap


The MDX Sample works with multidimensional cellsets.
Reporting Services returns OLE DB for OLAP flattened rowsets, which is a rather different representation of the same data.
The behaviour you observe is by design.
You might want to check out the following topic in BOL:
"Flattening Algorithm", rule 8.
HTH,
--
Brian
www.geocities.com/brianaltmann/olap.html


"Stephan Frei" wrote: