Re: Unable to select NULL with IIF in Member clause
- From: "Chandu" <schandu@xxxxxxxxxxxxxx>
- Date: 29 Jul 2005 09:46:41 -0700
I have modified the query to run in MDX Sample Application.
WITH
MEMBER [Measures].[PatnerUN] as '[Partner].currentmember.UniqueName'
MEMBER [Measures].[PartnerUniqueName] AS 'IIF(ISEMPTY([Measures].[Act
Amt]), NULL, [Measures].[PatnerUN])'
SELECT
NON EMPTY {[Measures].[ACT AMT], [Measures].[PartnerUniqueName]} ON
COLUMNS,
NON EMPTY {[Ledger].Children*[Partner].Members} ON ROWS
FROM Activity
WHERE ([Fund].[Fund2], [Transaction].[Investment])
In the above query,
[Partner].currentmember.UniqueName will return only
1. "All Partner" when Partner dimension has "All Levels" property set
to true.
or
2. First Member of the Partner dimension when "All Levels" property set
to false.
To get the correct Partner Unique Name, you need to include Partner
([Partner].Members) in Axis Specification.
.
- Prev by Date: virtual cube to combine two cubes of two data sources
- Previous by thread: Unable to select NULL with IIF in Member clause
- Next by thread: virtual cube to combine two cubes of two data sources
- Index(es):
Relevant Pages
|
