Hi all, I'm working with AS2000 and AS2005, with similar Fact Tables, I
have a calculated cell like this:

([Measures].[Sales],
Tail(NonEmptyCrossJoin([Sales Date].[Day].Members)).Item(0).Item(0))

This Calculated Cell works perfect with AS2000, but in AS2005 when I
look the Data with Excel it's giving me an error, #VALUE!
AS2005 is the Standar Edition.

Any Idea?
Thanks

Are there multiple measure groups in the AS 2005 cube? If so, you could
explicitly select a measure in NonEmpty(). Also, if there are multiple
hierarchies in the [Sales Date] dimension, you might include the
hierarchy, like:

([Measures].[Sales],
Tail(NonEmpty([Sales Date].[Day].[Day].Members,
{[Measures].[Sales]})).Item(0).Item(0))


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***