Log in | Register

Amit Karkhanis, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Amit Karkhanis, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education



About Amit Karkhanis

This author has not yet filled in any details.
So far Amit Karkhanis has created 22 entries.

SQL Server Analysis Services – Understanding and configuring Processing Settings

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 […]

SQL Server Analysis Services – Different types of Hierarchies

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 […]

SQL Server: SSRS – Moving Reports from Old to a New Environment

Question – 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 discarding the old servers and the Reporting Services machine is one of them. This usually happens may be to change or upgrade the underlying […]

SQL Server Analysis Services Time Dimension Considerations – Part 2

Hi 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 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 […]

SQL Server Analysis Services Time Dimension Consideration – Part1

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 […]

SQL Server: SSAS – Important Attribute Properties Part 2

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 […]

SQL Server: SSAS – Important Attribute Properties Part1

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 […]

SQL Server: Topsum and Bottomsum in MDX

This 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 (Toppercent and Bottompercent in MDX). In this part lets check out Topsum and Bottomsum.


Like Toppercent, Topsum returns the topmost tuples in the set […]

SQL Server MDX – Resellers by laps time

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 […]

SQL Server: Toppercent and Bottompercent in MDX

In 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 about the current topic.) The Topcount function returns the top N tuples of a set and the Bottomcount function returns the bottom N […]