MDX for multiselect

#1

I have goals and actuals measures.
The goals are set for a year and actuals are at a month grain.

The problem is that if I allow a multiselect of the time dimension (months)
in the OWC client's filter pane, then the actuals come up right, but the
goals get multiplied by the number of months selected.

I realise this is caused by the goals getting aggregated when a multiselect
is performed on the filter pane.

How can I avoid this?

Thans very much!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

#2

I Presume you have 2 cubes + 1 virtual cube(?)

Have you try to use the "ValidMeasure" function?
ValidMeasure(measures.goal)

have you any formula?

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

Quote:

I have goals and actuals measures.
The goals are set for a year and actuals are at a month grain.

The problem is that if I allow a multiselect of the time dimension
(months)
in the OWC client's filter pane, then the actuals come up right, but the
goals get multiplied by the number of months selected.

I realise this is caused by the goals getting aggregated when a
multiselect
is performed on the filter pane.

How can I avoid this?

Thans very much!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

#3

This is actually in Yukon - so no virtual cubes - but 2 different measure
groups at 2 grains, so almost the same as virtual cubes.

I don't have a formula. Just have a measure (sum) for the goals and the
actuals.

And when i multiselect on the time filter, the actuals get added, but so do
the goals! I want to avoid aggregating the goals measure

thank you!

Jéjé wrote:

Quote:

I Presume you have 2 cubes + 1 virtual cube(?)

Have you try to use the "ValidMeasure" function?
ValidMeasure(measures.goal)

have you any formula?

I have goals and actuals measures.
The goals are set for a year and actuals are at a month grain.
[quoted text clipped - 11 lines]

Thans very much!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

#4

log this in the yukon beta newsgroup.

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

Quote:

This is actually in Yukon - so no virtual cubes - but 2 different measure
groups at 2 grains, so almost the same as virtual cubes.

I don't have a formula. Just have a measure (sum) for the goals and the
actuals.

And when i multiselect on the time filter, the actuals get added, but so
do
the goals! I want to avoid aggregating the goals measure

thank you!

Jéjé wrote:
I Presume you have 2 cubes + 1 virtual cube(?)

Have you try to use the "ValidMeasure" function?
ValidMeasure(measures.goal)

have you any formula?

I have goals and actuals measures.
The goals are set for a year and actuals are at a month grain.
[quoted text clipped - 11 lines]

Thans very much!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

#5

Let me look into it. I think that in Yukon, in this scenario the measure
which is not related to months should not get multipled by number of
months...

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Jéjé" <willgart (AT) AAAhotmailBBB (DOT) com> wrote

Quote:

log this in the yukon beta newsgroup.

"Rama via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote in message
news:523E0E452C8CD (AT) SQLMonster (DOT) com...
This is actually in Yukon - so no virtual cubes - but 2 different measure
groups at 2 grains, so almost the same as virtual cubes.

I don't have a formula. Just have a measure (sum) for the goals and the
actuals.

And when i multiselect on the time filter, the actuals get added, but so
do
the goals! I want to avoid aggregating the goals measure

thank you!

Jéjé wrote:
I Presume you have 2 cubes + 1 virtual cube(?)

Have you try to use the "ValidMeasure" function?
ValidMeasure(measures.goal)

have you any formula?

I have goals and actuals measures.
The goals are set for a year and actuals are at a month grain.
[quoted text clipped - 11 lines]

Thans very much!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

#6

thank you for checking

I am trying this with the time dimension in the "drop filter fields here" -
the time dimension holds Year and Month and goals are set at the year level
and granularity for the goals measure group is set at year.

Please let me know if you know how i can avoid this

Mosha Pasumansky [MS] wrote:

Quote:

Let me look into it. I think that in Yukon, in this scenario the measure
which is not related to months should not get multipled by number of
months...

log this in the yukon beta newsgroup.

[quoted text clipped - 22 lines]

Thans very much!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

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

MDX for multiselect

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

MDX for multiselect - 08-01-2005 , 10:52 PM

Re: MDX for multiselect - 08-02-2005 , 05:47 AM

Re: MDX for multiselect - 08-02-2005 , 08:32 AM

Re: MDX for multiselect - 08-02-2005 , 07:02 PM

Re: MDX for multiselect - 08-02-2005 , 09:41 PM

Re: MDX for multiselect - 08-03-2005 , 01:48 AM