This might sound far fetched, I need to create a calculated measure that
simply multiplies 2 numbers together, one is in a measure (we'll call it
Count), and the other is not in the cube, and for security reasons it cannot
be in the cube. To make matters more fun: the multiplier changes depending
on what details are selected.

For example: say you have a dimension name Products with 2 levels: level 1
is product catagory, level 2 is Products.

The measure you have on the server is Count. What has to calculated on the
client is Price. And every Product has a differnt price. And again this
has to be stored on the client. I dont care how it is stored on the client,
it just has to be stored on the client.

So, doing a simple Count * $###.## calculation on the all level is not going
to work, but can this be done?

Clearly this would have to be implemented via a UDF (user-defined function).
It is the only mechanism that can be used to combine Analysis Services data,
an outside data element -- and then be displayed as if it was something
within the cube. There are a few examples of how to write a UDF in Books
OnLine.
Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Chris Brandsma" <not.my.address (AT) nowhere (DOT) com> wrote

Chris,

Another suggestion would be to include it in the cube,
then set security on that item such that no one can see
it.

Regards,

Steven Garno