Hi.
I tried to set a default member, something that I assumed was
straightforward but I do not get the expected results.
I am working with a DW on Oracle.
I have a time dimension called [V Completion Date], with among others
[Month] as an attribute. I want to set Month default member as the
last member with useful data in the cube.
My MDX expression is:
Tail(Filter([V COMPLETION DATE].[Month].Members,
NOT IsEmpty([V COMPLETION DATE].[Month].[CurrentMember])),1).Item(0)

(I have also tried using [V COMPLETION DATE].[CurrentMember] in the
second part of the expression with same outcome described below).

When I query using Proclarity MDX Editor with:

SELECT {[V COMPLETION DATE].[Month].DefaultMember} ON AXIS(0), NON
EMPTY {[Measures].[LOAN AMOUNT]} ON AXIS(1) FROM [Dev F2]

I get as result only September 2007 with no data. September 2007 is the
last Month configured in [V Completion Date].

According to all the examples that I have seen I should get February
2006 and Loan amount £340,000, the last non null data in the cube.

There is something wrong with my MDX?
Is it an issue of data / null conversion between Oracle and SSAS05?

Please advise.
Cheers
Enzo

You have not specified which measure you are using when you are testing
for empty cells. Is it possible that the default measure is non-empty in
September 2007?

You could test this by running the following query:

F2]
If this is your issue, you could try something like the following to
explicitly evaluate the empty status against the Loan Amount measure:

Tail(Filter([V COMPLETION DATE].[Month].Members,
NOT IsEmpty(([V COMPLETION DATE].[Month].[CurrentMember],[Measures].
[LOAN AMOUNT]))),1).Item(0)

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1144859472.125492.131720 (AT) e56g2000cwe (DOT) googlegroups.com>,
emartoglio (AT) gmail (DOT) com says...