SQL Server Education (by the geeks, for the geeks)
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. …
SQL Server Analysis Services – Understanding and configuring Processing Settings Read MoreA 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 …
SQL Server Analysis Services – Different types of Hierarchies Read MoreQuestion – How to migrate all the reports and data sources deployed on the old server to the new server? Scenario – Our Company is going for the new server setup by …
SQL Server: SSRS – Moving Reports from Old to a New Environment Read MoreHi Friends, 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 …
SQL Server Analysis Services Time Dimension Considerations – Part 2 Read MoreIn 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 …
SQL Server Analysis Services Time Dimension Consideration – Part1 Read MoreIn 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 …
SQL Server: SSAS – Important Attribute Properties Part 2 Read MoreWhile 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 …
SQL Server: SSAS – Important Attribute Properties Part1 Read MoreThis is the last one in the series“Top to Bottom in MDX”. In the first part we have seen Topcount and Bottomcount functions and in the second part, Toppercent and Bottompercent …
SQL Server: Topsum and Bottomsum in MDX Read MoreThe 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 …
SQL Server MDX – Resellers by laps time Read MoreIn my previous blog post “Top to Bottom in MDX” we have shown Topcount and Bottomcount functions. (I suggest you to first go throgh this post to get more clear idea …
SQL Server: Toppercent and Bottompercent in MDX Read More