Hi Martin

Well, this is embarrassing.

One of the older versions now works. I used this as the calculated member:

COUNT(

NONEMPTY(

([Dim Employees].[GlobalID].[SGID],[Dim Phone Logins].[Phone Logins].CurrentMember),

[Measures].[Outliers - ACD Calls]

)

)

and it came back with...

Hi Martin

Thanks for your further reply!

I hope this example makes things clearer.

Here's what I'm running at the moment, which uses a calculated member specifying .CurrentMember on both of the dimensions...

Hi Martin

Thanks for your help with this!

Martin Schoombee (5/22/2015)

---

First, let's correct some dimensionality issues. Instead of doing the following:

[Dim Phone Logins].[Phone Logins].Members - [Dim Phone Logins].[Phone Logins].[All]

Just step one level...

Hi

Thanks for your reply.

You've picked out the problems in the MDX I wrote, and I'm looking forward to trying out your suggestions on Tuesday when I'm back at work.

The...

It sounds like the relation (one-many) between Server and Site doesn't explicitly...