I am using a shared dimension across 2 cubes with different grains. But
when I disable the lower levels for the cube with the higher grain, the
measures don't come up correct.

Do I need to do anything othr than disabling the lower levels?

thank you

--
Message posted via http://www.sqlmonster.com

How is it joined to the fact when it has higher grain ? You perhaps need to
change this join....

Another way to go is to use parent child dimension which supports this
without any justification - this dimension has some performance trouble in
some situatons however....

"Angie via SQLMonster.com" <forum (AT) nospam (DOT) SQLMonster.com> wrote

Additionally to disabling the levels, I had to snow flake the higher
granularity level... For example:
I had a measure n the Month level and another one in the Year level. I
created a dimension table with Year level and the remaining levels in another
table.
For the cube with Yearly data I linked the Year dimension table to the fact
table.
For the cube with Monthly data I linked the month dimension table to the
fact table.

Then I created a virtual cube to see both measures in the same cube. In the
virtual cube I had to use the function VALIDMEASURE in the yearly measure to
push down the data to the month level (if you want to).

Hope this helps.


"Michael Vardinghus" wrote: