Processing is an operation to keep an Analysis Services database (ASDB) up-to-date with the current data from an OLTP system or a data warehouse based on how an ASDB is designed. It is the responsibility of an administrator to manage the processing tasks on a regular basis. It may be a single step or […]
A dimension consists of various attribute members. Attributes are exposed to end users through attribute hierarchies. A hierarchy defines the relative position of attribute members in a dimension. By default, in UDM, every attribute can form its own attribute hierarchy and dimensions are the containers for these hierarchies. Dimension may also contain user hierarchies […]
This is a second part in the series “SQL Server Analysis Services Time Dimension Consideration”. In the Part 1, we have briefly discussed on the two types of the Time Dimension Structures i.e. Regular time dimension and Server time dimension. We have also started with the first out of the three creation methods […]
In SQL Server Analysis Services Time Dimension has its own importance in the overall data analysis. As we can see that the majority of the BI solution aggregate data over the time periods and hence it is an implicit part and parcel of majority of BI projects.
A SQL Server Analysis Services Time Dimension typically contains attributes […]
In the Part 1 we have checked the attribute properties that control the display and visibility of an attribute, properties related to the attribute column bindings and few other ones. In this post we shall see the properties controlling the sorting and grouping of attributes.
Properties that control sorting
OrderBy – Defines the ordering of the […]
While working with the dimension designer, it is important to understand some of the useful attribute properties that determine how dimensions and dimension attributes function. To view the properties, just select the required attribute in the dimension designer and press F4 to open the properties window. There are many properties and explaining each one […]
The inspiration behind this blog entry is the comment received by Andrew on my blog post “Top to Bottom in MDX”. In that blog, I have explainded the use of Topcount and Bottomcount functions in MDX. The example therin shows the top five Resellers based on the Reseller Sales Amount. (I suggest to first […]