Hello

probably a very simple problem on AS2000 but it drives me crazy. I have
got members from two independant dimensions, [Contract Number] and
[date_loaded].
What I'd need is the last [date_loaded] by [Contract Number]. Here is a
sample query.

Select NonEmptyCrossjoin({[Contract Number].[Contract
Number].members},{([Date Loaded].[date_loaded].Members)}) ON COLUMNS
FROM
SourceData

NonEmptyCrossJoin calculates a set of tuples consisting of all non
empty permutations of [Contract Number] with [Date Loaded]. Both are on
different dimensions.

How can I get out the last [Date Loaded] for each [Contract Number].

Cheers
Bernhard

Here is a solution. Maybe not optimal.
SELECT
GENERATE(
[Contract Number].[Contract Number].members,
NonEmptyCrossJoin(
{[Contract Number].CurrentMember},
{BottomCount(
Extract(
NonEmptyCrossjoin(
{[Contract Number].CurrentMember},
{[Date Loaded].[date_loaded].members}
),
[Date Loaded]
),
1
)}
)
) ON COLUMNS
FROM SourceData

Cheers
Bernhard