Hi,

I have a Test Miles measure and a Test Side dimension, which can be Left,
Right, or Both. There are several other dimension as well. I need to define
an Actual Test Miles calculated member which will do the right thing with
the Test Side dimension - multiply by 2 when member value is Both. What is a
good way to express this?

--------------------
Chris Harrington

Chris,

Have you thought of using Unary operators, cell calculations or a custom
rollup formula on the dimension?

The following post on Mosha's blog should get you going:

http://sqljunkies.com/WebLog/mosha/a...3/27/9723.aspx

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <e14TTNrXGHA.4920 (AT) TK2MSFTNGP02 (DOT) phx.gbl>, "ChrisHarrington"
<charrington-at-activeinterface.com> says...

Thanks Darren,
The first pass on this in on AS2000 and not enterprise edition. Do you
think that a custom rollup could accomplish this? How exactly would it be
expressed?

Much thanks,
Chris


"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote

Actually I think in AS 2000, the easiest solution would be to set up a
customer member formula (I think the standard edition supports these)

Somthing like:

([Test Side].[Both]) * 2

This would multiple every measure for the "Both" side by 2.


If you just want to double one of the measures, you might need to create
two calculated measures. The first one (which would be set to
visible=false) would test if the side member is [Both], the second
measure would just sum up the first one below the currently selected
"Test Side" member.

eg.

[Actual Miles Pre]
==================
IIF([Test Side].CurrentMember is [Test Side].[Both], Measures.[Miles] *
2, [Measures].[Miles])

[Actual Miles]
==============
SUM( Descendants([Test Side].CurrentMember,,LEAVES), Measures.[Actual
Miles Pre])

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <uFI5GBzXGHA.3936 (AT) TK2MSFTNGP05 (DOT) phx.gbl>, "ChrisHarrington"
<charrington-at-activeinterface.com> says...

Thanks Darren - that was the pattern (two calcs - one hidden) I was looking
for.

"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote