Cross join in Named set

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » Cross join in Named set

Cross join in Named set

Topic RSS Feed

Posts under the topic: Cross join in Named set

Posted: 10/12/2011

Jedi Youngling 6  points  Jedi Youngling
  • Joined on: 4/28/2011
  • Posts: 3

How to use cross join in Named Set of a Cube.

I have wriiten a expression for TopCount with CrossJoin like:

1) TOPCOUNT(CROSSJOIN( [DimScale].[Source].Children, [DimScale].[ID].Children ), 5, [Measures].[Tickets])

2) And also written in script command like :

  CREATE DYNAMIC SET CURRENTCUBE.[Top5Source]
AS TopCount
( NONEMPTYCROSSJOIN(
[DimScale].[Source].[Source].Members,
[DimScale].[ID].[ID].Members ), 25,
[Measures].[Tickets] )

If I use the above expresion in SSMS(MDX), it works fine and I see the results. But when placing this expreesions in NamedSet of Cube, none of the namedset itslef are visible after processing the Cube.

Can anyone let me know how to use Cross joins in Named Set, or is there any mistake in my exprssion.

Thanks,


Page 1 of 1 (1 items)