Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / September 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alessandro - 25 Sep 2006 14:49 GMT
I have a simple cube,
dimensions are time and customers (id, name, address, contry, etc), fact are
quantity
On Y axes I have to show the customer name AND the address.
if I drag and drop only the id and name, the query is fast, and it works
fine, If after the name I also add the  address, the query becames very slow
I belive this is because of aggregation on the address attribute, that I
really don't need, the address is specific to every customer and it does not
make any sense to do calculation on this.
I only need to show che address near the name, without any aggregation
How can I do it?
Is there any property I have to set?
Thank you
Alessandro Belli
Peter Yang [MSFT] - 26 Sep 2006 03:55 GMT
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>.
==================================================
Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

amish - 26 Sep 2006 11:40 GMT
> Hello Alessandro,
>
[quoted text clipped - 52 lines]
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.

You can add address as property for name attribute and can create
calculated measure on this property.

Regards
Amish Shah
http://shahamishm.tripod.com
amish - 26 Sep 2006 11:41 GMT
> Hello Alessandro,
>
[quoted text clipped - 52 lines]
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.

You can add address as property for name attribute and can create
calculated measure on this property.

Regards
Amish Shah
http://shahamishm.tripod.com
Alessandro - 27 Sep 2006 09:14 GMT
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

> Hello Alessandro,
>
[quoted text clipped - 59 lines]
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
Peter Yang [MSFT] - 28 Sep 2006 04:18 GMT
Hello Alessandro,

You could try the following steps to add attribute relationship between
name and address attribute.

1. Open customer dimension by double click the dimension on the right panel

2. Drag Address column from the source table in Data Source View to the
Name Attribute on the left panel, and you shall see a new Attribute
relationship under attribute Name.

3. Process the dimension and cube and you shall see member property Address
under Name Attribute

Please see if this could meet your requirement. If you have any concerns or
questions, please let me know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.