Pie ChartsHi All

I have included new Measure called "Product Count"(Aggregation as Distinct Count) in the Warehouse Cube

If i try to run the below query it is giving error. Is there any problem with the MDX query or with the Analysis Server. I have seen net that the "Distinct Count"
won't work properly. Is there any way to come out of this problem.

with member [Product].[Test] as 'Aggregate ({[Product].[All Products].[Drink]})'
Select non empty ({[Store].[(All)].Members }) on rows, non empty {[Measures].[Product Count]} on columns From [Warehouse] where( [Product].[Test] )

Thanks,
Vasu


"vasu" <vasu (AT) stcroixsystems (DOT) com> wrote

Hi All

Iam facing problem with distinct count. If the i place the distinct count in the cubes iam getting the correct result. But when I try to get the result through the MDX query I am getting the error. Is there any way to solve this problem.

Thanks,
Vasu

Pie ChartsDistinct count is not supported with the aggregate function. If you only want one product member in the AGGREGATE function, you can simply remove the AGGREGATE function and just refer to the member. My guess is that you want to include multiple products though. If you need such functionality you'll need to consider adopting the approach outlined in

http://msdn.microsoft.com/library/de.../distinct2.asp



Sean Boon
Microsoft Office BI

**This posting is provided AS IS, with no warranties, and confers no
rights.**
"vasu" <vasu (AT) stcroixsystems (DOT) com> wrote

Hi All

I have included new Measure called "Product Count"(Aggregation as Distinct Count) in the Warehouse Cube

If i try to run the below query it is giving error. Is there any problem with the MDX query or with the Analysis Server. I have seen net that the "Distinct Count"
won't work properly. Is there any way to come out of this problem.

with member [Product].[Test] as 'Aggregate ({[Product].[All Products].[Drink]})'
Select non empty ({[Store].[(All)].Members }) on rows, non empty {[Measures].[Product Count]} on columns From [Warehouse] where( [Product].[Test] )

Thanks,
Vasu


"vasu" <vasu (AT) stcroixsystems (DOT) com> wrote

Hi All

Iam facing problem with distinct count. If the i place the distinct count in the cubes iam getting the correct result. But when I try to get the result through the MDX query I am getting the error. Is there any way to solve this problem.

Thanks,
Vasu