#VALUE when selected multiple items in filter axis

[inarin]

Hi all,

I create sales report to compare Sales figure and Sales target.

My sales target is calculated member. When I create mdx command by

using Date as filter axis for newest day, it will normally shown. And
when

I select multiple day in filter axis, Sales figure is normally shown but

Sales target is shown #VALUE. Why?, and How can be solved?



Thank you

Narin Inyod

 

[Costa Ciprian]

Hi

I had the same problem and I figured it was because Excel actualy sends an
MDX expression containg agreates to the server, and my cube containd
measures with Aggregate Function set to 'Distinct Count'. The error message
returned by the server said :

Formula error - aggregations are not supported for the DISTINCT COUNT
measure "..." - in the Aggregate function

An error occurred during attempt to get a cell value.

Excel MDX expression was:

WITH MEMBER [...Dimension...].[XL_QZX] AS 'Aggregate ( { Selection1 ,

Selection2, ... } )'

SELECT NON EMPTY ...

FROM Cube

WHERE (Dim1, ... , [XL_QZX], Dimn)

Hope this helps

Cipri