Hi,
I am experiencing a strange behaviour with both NONEMPTYCROSSJOIN() and NON(CROSSJOIN()) Mdx statements when working with linked measure groups.
Bascially, I have created a very simple "regular" MOLAP cube on SSAS2005 with one fact table and 3 dimensions. I have one single Measure Group for this cube.
Now, if I create an empty cube (no data source view) and add the measure group of my first cube as a Linked Measure Group, it seems like the Mdx function NonEmptyCrossJoin() never returns anything whereas it does on the underlying cube.
Same problem occurs when using NonEmpty(CrossJoin()).
Is there anything I need to parameter to have the NonEmpty baheviour work correclty on the linked measure group ? I've read there's a "NonEmpty behaviour" parameter for calculated members, but I'm not even using calculated measures.
Is such a behaviour a known issue ?
Do you need a more detailed example? if so, on which database ?
To give some backgroung, I have first noticed this problem after migrating a virtual cube from SSAS 2000.
Many thanks in advance
Rgds,
Francois
I eventually found an answer to this.
There was obviously some type of confusion in the migration of the virtual cube (which is based in SSAS2000 on 3 physical cubes) because not all of the sub cubes' dimensions where used.
I have recreated by linked measure groups manually, removed the unused dimension and the nonemptycrossjoin works fine now.
Hope that helps anyone having the same type of problem.
- F.
