Cube has 7 dimensions:
Version
Source
Lender
Borrower
Note
Time
Measure
The Note dimension has individual notes where the numbering scheme is a leaf element from the Lender and Borrower dimensions, separated by a dash and then a suffix. Example, 002-004-U1, where 002 represents an element from Lender and 004 represent an element from Borrower. The Note also has a Lender and Borrower attribute. In this case the Lender attribute would be 002 and the Borrower attribute would be 004.
I have a cube view that has Version, Source, Lender, Borrower, Note as Titles, Time as rows and Measure as columns. I would like to have the selections for Lender and Borrower be dynamic, based on the Note#. For example, when I select 002-004-U1 I would like the Lender element resolve to 002 and Borrower to 004.
I know how to get this to work in an Active Form but I can’t seem to get it right in a cube view.
I tried this MDX statement for the dynamic subset on Lender:
Code: Select all
{FILTER({TM1SUBSETALL([Lender])},[Lender].CurrentMember.Name = [}ElementAttributes_Note].( [Note].[002-192-U1], [}ElementAttributes_Note].[Lender]))}
Code: Select all
{FILTER({TM1SUBSETALL([Lender])},[Lender].CurrentMember.Name = [}ElementAttributes_Note].( [}ElementAttributes_Note].[Lender]))}