Perhaps my understanding of the UDM is incorrect, but I was under the
impression that, when a member of a dimension is selected, the corresponding
member of another dimension should be automatically associated.
To illustrate: I have a table of users, and each user has an account
creation date; there is an Account Creation Date time dimension based on
that, as well as a Users dimension.
When I filter my query (see below) based on an individual user, I expected
the current member of the Account Creation Date dimension to be the date of
that user's account creation; instead, the All member is returned:
WITH MEMBER [Measures].[Creation Date] AS
[User Account Creation Date].[Calendar Year - Month - Day].CurrentMember.Name
SELECT {[Measures].[Creation Date]} ON COLUMNS
FROM [Sales Cube]
WHERE ([Users].[User ID].[2355320])
Is my understanding of UDM functionality incorrect, or is there a flaw in my
MDX or in the implementation of the cube
This is driving me crazy because it is fundamental to some significant
metrics required of this cube, so any assistance will be greatly appreciated.
Thanks in advance,
-- Brian Cowhig