I have a CubeValue Formula that is giving me a very perplexing result. I am trying to pull data for a group of sales items (only 2). When I run the cubevalue formula for each item individually, I get a result, but when I point the CubeValue formula to a named cubeset, I get a #Value ! result.
example
[Item].[Item Long Descr].&[120169] yields a result of 0.1
[Item].[Item Long Descr].&[120168] yields a result of 0.2
however, when i point the formula to named cubeset
Promo
which only has
[Item].[Item Long Descr].&[120168]
[Item].[Item Long Descr].&[120169]
I get the error.
My expectation is that it should return 0.3.
I will be using the cubeset to pull a number of different calculations, so I would really prefer to pull the data as group rather than adding the individual items.
example
[Item].[Item Long Descr].&[120169] yields a result of 0.1
[Item].[Item Long Descr].&[120168] yields a result of 0.2
however, when i point the formula to named cubeset
Promo
which only has
[Item].[Item Long Descr].&[120168]
[Item].[Item Long Descr].&[120169]
I get the error.
My expectation is that it should return 0.3.
I will be using the cubeset to pull a number of different calculations, so I would really prefer to pull the data as group rather than adding the individual items.