|
Home > Archive > MS SQL Server OLAP > January 2006 > Measures group problem with different granularity
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Measures group problem with different granularity
|
|
| Michael Roedeske 2006-01-26, 4:58 pm |
| 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
| |
| Deepak Puri 2006-01-26, 4:58 pm |
| 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
IgnoreUnrelatedDimen
sions property to false:
http://msdn2.microsoft.com/en-us/library/ms175623.aspx[color=darkred]
Measure Group Properties
...
IgnoreUnrelatedDimen
sions
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.
...[color=darkred]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.droptable.com ***
| |
| Michael Roedeske 2006-01-26, 4:58 pm |
| Dear Deepak,
> 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
> IgnoreUnrelatedDimen
sions property to false:
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 IgnoreUnrelatedDimen
sions, I saw no values, only the
grandtotal.
Thanks for your support,
Michael
| |
| Deepak Puri 2006-01-26, 8:23 pm |
| 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[color=darkred]
...
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.
...[color=darkred]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.droptable.com ***
|
|
|
|
|