MDX help again

#1

Hi,
But some values appear in cells & for some cells I get
the error

Thanks

Steve

Calc members aren't drillthrough-able.

public @ the domain below
www.tomchester.net

<anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,
Can anyone help me with this please

I am trying to build a calculated member. Syntax seems
correct butin the cube I am getting the following error.

Unable to drill through
Cannot execute drillthrough on calculated member MTTT in
dimension Measures

Claculated Member

iif(([Pay Type].[Pay Type].&[Hourly])
--iif(([Pay Type] = Hourly)
or([Measures].[Number of Employees] = 0),
--then
Null,
--else
([Measures].[Org Salary]/[Measures].[Number of
Employees]))

(Using Foodmart example here from HR cube)

I'll be very greatful if you can fix the ssyntax for the
above Claculated Member.

Thanks

Steve

..

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

MDX help again

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

MDX help again - 02-02-2004 , 08:44 PM