calc measure problem

#1

I have created a calc measure in the cube that ignores a dimension
(measure, dimensionPoduct.all). This works fine in the cube. But in reports,
it still responds to the dimensionProduct which is a paramter in the report.

will I need to create a virtual cube for this?
Or is there any way out in RS itself?

thanks

--
Message posted via http://www.sqlmonster.com

#2

get the MDX formula and put it in the MDX sample application to see the
result.
but if the formula is in the cube himself, RS can't change it.

"Angie via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Quote:

I have created a calc measure in the cube that ignores a dimension
(measure, dimensionPoduct.all). This works fine in the cube. But in
reports,
it still responds to the dimensionProduct which is a paramter in the
report.

will I need to create a virtual cube for this?
Or is there any way out in RS itself?

thanks

--
Message posted via http://www.sqlmonster.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

calc measure problem

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

calc measure problem - 08-21-2005 , 01:41 AM

Re: calc measure problem - 08-21-2005 , 07:14 AM