Hi,

I have a cube with a calculated measure. In the cube the value shows
correctly, but when i create a MDX query to display this calculated measure i
get an error:

1.#INF or -1.#IND

Anyone have an explanation for this?

The calculated measure is:

[Measures].[Available]/Count({descendants([Unit].Currentmember,[Unit].[Unit
Name])})

Thnx,

Stanley

Okay,
so i have found the problem. When i use a normal select statement it works:

select {..} on columns,
{..} on rows
from ...

But when using a With member statement, that's where it goed wrong
With member [....].ThisValue as ''
select {..} on columns,
{..} on rows
from ...

So, anybody knows why this happens?

Thnx

Stanley

"Stanley" wrote:

Solved. I have a where clause also in the query. I've switched the with
member dimension with the where claus dimension.

"Stanley" wrote: