Hello together,

SSAS 2005 RTM Developer Edition. I have 2 fact tables:
a) actual sales with granularity "itemid" in dimension item
b) sales plan with granularity "productgroupid" in dimension item
The dimension item has the follwing attributes:
- itemid = key
attribute relationship = productgroupid
- productgroupid
attribute relationship = none

The dimension usage ist set to:
Plan
Item Regular - Granularity attribute: productgrouid
relationship: productgroupd - productgroupid

When I browse the cube, I see on every productid level the same ammount.

What I'am doing wrong?

Thanks,
Michael

Hi Michael,

From your brief description, it's not clear what "every productid level"
means, because you didn't mention productid elsewhere. But, assuming
that you don't wish to see data in the Plan Measure Group below the
productgroupid granularity, you can try toggling its
IgnoreUnrelatedDimensions property to false:

http://msdn2.microsoft.com/en-us/library/ms175623.aspx
...
IgnoreUnrelatedDimensions

Determines whether unrelated dimensions are forced to their top level
when members of dimensions that are unrelated to the measure group are
included in a query. Default setting is True.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Dear Deepak,

I try to be more detailed:

Dimension "item":
ProductgroupID
ProductgroupName
ItemID
ItemName

The Granularity relation in the measure group is set on ProductgroupID.

When I open the browser I only see values when using the Attribute
"Productid", I saw the sum when selected "Productname". After chaging the
mentioned switch IgnoreUnrelatedDimensions, I saw no values, only the
grandtotal.

Thanks for your support,
Michael

Hi Michael,

It's not clear what the relationship of "Productid" to the granularity
attribute (ProductgroupID) is. SQL Server 2005 BOL calls for some
(direct or indirect) relationship:

http://msdn2.microsoft.com/en-us/library/ms175669.aspx
However, sometimes you may want to set the granularity of a particular
cube dimension in a particular measure group to a different grain. For
example, you may want to set the granularity attribute for the Time
dimension to the Month attribute instead of to the Day attribute, if you
are using a Sales Quotas or a Budget measure group. When you specify the
granularity attribute to be an attribute other than the key attribute,
you must guarantee that all other attributes in the dimension are
directly or indirectly linked to this other attribute through attribute
relationships. If not, Analysis Services will be unable to aggregate
data correctly.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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