Newbie cannot make simple aggregation work correctly on crosstab

[EarthDog]

I have a simple nested crosstab that has 2 measures. I need to see the average on them. I do not need any totals.

What i get is repeating results. Its like he is ignoring the levels in my crosstab. I have 2 levels.

-Both measures are defined as 'fact' in FM model
-Both measures have average as rollup function and Automatic as Rollup Aggregate function
-Query auto Group & Summarize option is Yes

Generated SQL does NOT contain GROUP by clause...

The attachment shows the situation.

It seems that the numbers are repeated..

[EarthDog]

It seems that i am getting correct results if i disable the  auto Group & Summarize option in query..

Something must be fundamentally wrong  but i dont know what...

[EarthDog]

anyone?

[EarthDog]

So embarrassed  ;D

I was missing FM model joins...

[bdbits]

Happens to everyone, sooner or later.  8)