Design FAQ How in Analysis Services do you order dimension attribute during design
| How in Analysis Services do you order dimension attribute during design |
| Written by Vidas Matelis | |||
| Saturday, 21 April 2007 19:21 | |||
|
Q: How do you order dimension attribute? A: Each attribute has following properties that defines how attribute is ordered:
Order by attribute is drop down list that contains following options:
Option "Key" means that attribute will be ordered based on key value. Do not forget that ordering depends on key type: example if key is integer, then ordering will be 1, 2, 3..., 11, 12. If Key is string, then ordering will be 1, 11, 12, 2, 3 ... Option "Name" means that attribute will be ordered based on name value. Option "Attribute Key" means that ordering will be based on attribute that is specified in property "Order by Attribute" key value. Option "Attribute Name" means that ordering will be based on attribute that is specified in property "Order by Attribute" name value. Property "Order By Attribute" lets you choose attribute for "Attribute Key" and "Attribute Name" options in "Order By" property.
|
Tags: design, faq
Most read
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- MDX-How do you format or round KPI expression value?
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
- MDX-How do you calculate monthly average of one year, optionally including empty months?
Top Rated
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- Analysis Services 2005 XMLA script to add/drop existing partition aggregate
- Why In Reporting Services MDX query disappears after leaving "Data" tab.
- When accessing calculation tab in BIDS I am getting error Unexpected error occurred
- MDX-How can I setup default dimension member in cube calculation script?
- How to calculate YTD monthly average and compare it over several years for the same selected month
- In an MDX query how can I get the top 3 sales years based on the order quantity?
- How in SSAS 2005 do you create what is used to be "Member Properties" in Analysis Services 2000
Otherwise, option I would use:
In Analysis Services Data Source View introduce calculated field with formula something like:
CONVERT(smallint, SUBSTRING(WWFieldName, 3, 2)) * (-1) AS WWeekOrderID
and then create attribute based on that field and then order WorkWeeks based on this attribute.
thank you.