-
Crossjoin and DrilldownLevelTop
hi
I m having this query which works fine:
SELECT NON EMPTY Crossjoin( Hierarchize({DrilldownLevel({[Underlyings].[All].[AllMember]})}), Hierarchize({DrilldownLevelTop({[BucketRelative].[All].[AllMember]}, 2.0, , [Measures].[contributors.COUNT])})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS, {[HistoricalDates].[AsOfDate].Members} ON COLUMNS FROM [EquityDerivativesCube] WHERE [Measures].[contributors.COUNT]
the problem is that the Crossjoin is done after the DrilldownLevelTop so my results concerning the dimension [BucketRelative] are always the same and do not care about the [Underlyings] dimension against which the join is done
I m wondering if MDX is able to handle a query in which the DrilldownLevelTop is done after the Crossjoin ?
hope this is clear ...
thnx in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|