Hi all,

I try to create a reference dimension based on a named calculation.
By base dim (dim_base) looks like this in the DSV:

timekey
Year
Month
Day
Ref_id <-- named calculation

Ref_id contains N'Current Period'. I create a dimension based on ref_id. It
has one member called Caluclations.

The base dimension is connected to fact by the timekey.
everything process fine. When add the ref_dimension in the dimension usage
tab, I select referenced as relation type, the intermediate dimension is
dim_base, the reference dimension attribute is Caluclations. And now comes
the problem: I should choose for the intermediate dimension attribute ref_id.
But I cannot see it.

However, when I use the time intelligence wizard, it also creates its own
ref_id in the dsv tables, for example calc_id. And when I follow the same
steps above I can see the calc_id attribute.

I try to determine the difference between the two attributes but I can not
find any.

Can anyone shed a light on this?

Thanks.
Q

Try to check the attribute Ref_id on dim_base: it should have
AttributeHierarchyEnabled set to TRUE, otherwise you can't use it.

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbii

Qbee wrote: