Re: how to set a dimension attribute as a simple "note" field?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you for you suggestion, but is not clear to me how to make a
relationship between name and address.
Is enought to set address.keycolumn= customers.name and
addess.namecolumn=address?
Or what I have to do to make the realtionship?
The key of the dimension is a field named "code". Do I also have to set
name.keycolumn=customers.code?

After this when I browse the cube and I right click the name cell->Show
properties in report->Show All
properties in report the option is grayed.
Thank's
Alessandro



"Peter Yang [MSFT]" <petery@xxxxxxxxxxxxxxxxxxxx> ha scritto nel messaggio
news:gdsQ4cR4GHA.2336@xxxxxxxxxxxxxxxxxxxxxxxx
Hello Alessandro,

I understand that you'd like to specify an dimension attribute as a
property not to be aggregated. If I'm off-base, please let me know.

You may want to consider define attribute relationship bewteen attribute
name and address, thus you could display address as member property of
name
and do not necessary to drag name attribute to the browser which cause
more
calculations and overhead even if they are 1:1 relationship. When you drag
a dimension attribute into the browser it is used as normal attribute
anyway though at running time, it will gain performance improvement when
engine may find it has 1:1 relationship with another attribute.

By default, dimension attribute are related to key dimension attribute by
a
attribute relationship. In VS 2005, you could open the dimension in VS
project, and check the attribute relationships defined on the key
attribute
( I assume it is "id" in the dimension).

You may want to create a attribute relationship directly on name attribute
and define the relationship bweteen name and address. You will be able to
see address as the member property of the name attribute in browser. You
could right click the a name cell->Show properties in report->Show All
properties in report.

The other option that you could display name/address at the same time ( I
assume it is 1:1 relationship) is that you create a new column on
dimension
source table, and merge (name, address) column to a new column such as
name-address. You could use this new column as a attribute directly in the
dimension attribute.

If you have further questions or concerns on the issue, please feel free
to
let's know. Than you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.




.

Relevant Pages

  • RE: Hierarchies and levels
    ... If you define an attribute relationship and you define a hierarchy ... key attribute and each non-key attribute of the dimension. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: DateTime Field Filter
    ... dimension table: ... Timekey fulldate year month day ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.olap)
  • RE: how to set a dimension attribute as a simple "note" field?
    ... a dimension attribute into the browser it is used as normal attribute ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Combining Two Cubes with Different Time Periods
    ... Order cube is in the past. ... and Inner join (which would exclude the forecast). ... My original thought was to create Parent-Child dimension for every ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.olap)
  • Re: AS2005: Nice implementation of Current Day/Month/Qtr/Yr - any suggestions
    ... currently I am looking into idea of having calculated dimension ... This is Justin from Microsoft. ... > Microsoft Online Partner Support ... > | every time they came back to same report, ...
    (microsoft.public.sqlserver.olap)