Dinesh's Blog :::: Being Compiled ::::

SQL Server Analysis Services allows us to install the instance in three different modes; Multidimensional Tabular PowerPivot for Shar...

Here is this week Brain Basher. This is based on Analysis Services Multidimensional model which allows you to create models based on dimen...

When creating a Tabular Data Model project, it creates a workspace database in Analysis Services Tabular Instance for maintaining all the ...

When creating calculated columns or measures in Analysis Services Tabular Mode, we use DAX expression language for adding them. DAX offers...

SQL Server 2014 introduced In-Memory OLTP tables and many of you know the benefits you get with it. This feature allows you to create tabl...

It is very common to see an Analysis Services database (or a cube) that holds multiple measure groups. If your cube holds multiple measure...

Have you noticed that a new measure group is automatically created if you have created a new measure with Distinct Count   usage? Microsof...

Security is the most important area that needs to be addressed with many solution and same goes to your Business Intelligence solutions im...

Although Power BI Pro allows us to connect with On-Prem Analysis Services Tabular instances for consuming live data into dashboards and re...

Color expression section of Calculations  tab of Cube Designer  allows us to set Fore Color  and Back Color  for the Calculated Measures/M...

User-Defined Member Properties are attribute relationships added to specific named level in a dimension. Once defined, they can be access u...

Calculating running totals against a numeric is not an easy task with both relational databases using T-SQL and multidimensional databases u...

There could be many reasons for this but in most cases, this misleads us, specifically if the MDX is running with Management Studio. You see...

If you experience this error when an SQL Server Analysis Services backup is restored, most probably the reason is Analysis Services – Servic...

As each attribute in a dimension can have a key column and optionally name column, attribute can be sorted by either key or name column. Sor...

While configuring Analysis Services security on Dimension Data, I did not pay much attention on two options available with the screen; Selec...

Is the famous rule of thumb broken? I am sure that you all are aware the rule and you know that DENY always wins over GRANT. If you want to ...

If you have read my previous post , you know why I went for “ OLE DB - Microsoft OLE DB Provider for Analysis Services 10.0 ” instead of “ M...

If you try to set some other dimension elements as the first axis other than measure dimension, you will receive an error like below: ...

First of all, let me tell you that why I need to connect to Analysis Services with the Port number; because the Analysis Services 2008 is ru...