Hello,

How can I define my measures group to show total data when no dimension is
dropped on the column or row fields?
I guess it is something about all level, or something related to total. I
defined in my dimension IsAggregatable as true, but it doesn't work as
expected:
only when I drill down to lowest level of my hierarchy data appears, when I
remove the lowest level - it shows empty cells.

Please help.
Thank in advance
Inna

Go into the dimension usage tab for the cube, click on the measure
group. One of the properties for the measure group is
"IgnoreUnrelatedDimensions".

From BOL:

in a query, this property determines whether unrelated dimensions are
forced to their top level or not.
So, if this is set to false, the cube displays nulls when the measures
in this group are sliced by an unrelated dimension, when this value is
true the measure will display the value from the "all" level.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#7wIfkGdGHA.536 (AT) TK2MSFTNGP02 (DOT) phx.gbl>, tzinna (AT) gmail (DOT) com
says...

Hello Darren,

Thank you very much for your answer.

I checked this option and it is set to true at my cube.

May be you have any other ideas?

I already removed all dimensions from the cube to localize the problem.
There is only one time dimension with two hierarchy - months and weeks -
stood in the cube and it doesn't show any data until I drill down to the day
level (lowest). Only then data appear. And no total!!!

What else do you think it could be?

Please, help

Thanks

Inna

"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote

If you only have one dimension in the cube then the
"IgnoreUnrelatedDimensions" setting will not make any difference.

It sounds like there may be something wrong with your attribute
relationships. Have a look at how the relationships are setup in the
Adventure Works sample database. Each attribute should have a
relationship with any "parent" attributes. At a guess yours should look
something like the following:

Year
-
Quarter
Year
Month
Quarter
Week
Year
Day
Month
Week

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <OjvyyrpdGHA.2188 (AT) TK2MSFTNGP05 (DOT) phx.gbl>, tzinna (AT) gmail (DOT) com
says...

Might be worth checking whether the "CALCULATE" statement is missing
from the cube MDX Script:

http://msdn2.microsoft.com/en-us/library/ms144939.aspx
...
Ordinarily, the nonleaf members of a cube have null values until you
call a CALCULATE statement.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Dear Deepak,
I did what you advised and it works!!!!
Thank you very much!!!!!!
Inna


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote