dbTalk Databases Forums  

SSAS2005: what are the parameters of an "order" attribute?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss SSAS2005: what are the parameters of an "order" attribute? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jeje
 
Posts: n/a

Default SSAS2005: what are the parameters of an "order" attribute? - 12-03-2006 , 05:27 PM






Hi,

I'm using a lot of attribute to order a displayed attribute
currently I setup this attribute to not optimized and
attributehierarchyenable is set to false.
and finally the relationship is set to rigid between the attribute and the
"order attribute"

does it the correct setup?
or I have to set the option to fully optimized for this attribute too?

thanks.

Jerome.





Reply With Quote
  #2  
Old   
Ohjoo Kwon
 
Posts: n/a

Default Re: SSAS2005: what are the parameters of an "order" attribute? - 12-03-2006 , 07:48 PM






The related properties are AttributeHierarchyOrdered, OrderBy and
OrderByAttribute.

Below is from BOL.

--
The AttributeHierarchyOrdered property determines whether the members of the
attribute are ordered. The OrderBy property on the attribute determines how
the attribute is ordered. Specify Key to order by the key column specified
by the KeyColumn property, or specify Name to order by the name column
specified by the NameColumn property. To order by the key column or name
column on a related attribute, specify AttributeKey or AttributeName, and
then use the OrderByAttribute to specify the attribute. The OrderByAttribute
list includes attributes that are member properties of the attribute.
--

FYI, if AttributeHierarchyEnable is set to false, the releated attribute
does not appear as a hierarchy.
The attribute can do role of only member property.

Ohjoo



"Jeje" <willgart (AT) hotmail (DOT) com> wrote

Quote:
Hi,

I'm using a lot of attribute to order a displayed attribute
currently I setup this attribute to not optimized and
attributehierarchyenable is set to false.
and finally the relationship is set to rigid between the attribute and the
"order attribute"

does it the correct setup?
or I have to set the option to fully optimized for this attribute too?

thanks.

Jerome.







Reply With Quote
  #3  
Old   
Jeje
 
Posts: n/a

Default Re: SSAS2005: what are the parameters of an "order" attribute? - 12-03-2006 , 09:04 PM



sorry maybe my question is not clear.
my attributes are correctly setup and correctly ordered.

my question is about the configuration of the "order" attribute.
if this attribute is not fullyoptimized, does this impact the performance?
how these attribute should be setup?

"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote

Quote:
The related properties are AttributeHierarchyOrdered, OrderBy and
OrderByAttribute.

Below is from BOL.

--
The AttributeHierarchyOrdered property determines whether the members of
the attribute are ordered. The OrderBy property on the attribute
determines how the attribute is ordered. Specify Key to order by the key
column specified by the KeyColumn property, or specify Name to order by
the name column specified by the NameColumn property. To order by the key
column or name column on a related attribute, specify AttributeKey or
AttributeName, and then use the OrderByAttribute to specify the attribute.
The OrderByAttribute list includes attributes that are member properties
of the attribute.
--

FYI, if AttributeHierarchyEnable is set to false, the releated attribute
does not appear as a hierarchy.
The attribute can do role of only member property.

Ohjoo



"Jeje" <willgart (AT) hotmail (DOT) com> wrote in message
news:839C45AE-2ACE-443A-9844-3387E9453ABC (AT) microsoft (DOT) com...
Hi,

I'm using a lot of attribute to order a displayed attribute
currently I setup this attribute to not optimized and
attributehierarchyenable is set to false.
and finally the relationship is set to rigid between the attribute and
the "order attribute"

does it the correct setup?
or I have to set the option to fully optimized for this attribute too?

thanks.

Jerome.







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.