MDX Error handling tricks


Error List:

Duplication of column value(column is not primary key):

This issue occur due to NULL records. You have to handle NULL records for particular column.
Below are the some properties which you need to set for the attribute:

  • On dim property set: UnknownMember = Visible
  • On attribute property:Key column Expand -> Null Processing-> handle in your way.

Comments

Post a Comment

Popular posts from this blog

Connecting Remote server with Local Server

Image
Introduction: Linked server is powerful functionality provided by SQL Server. We can create object of remote server on local server and use that object to perform operations on remote server. To explain this topic let's consider a scenario Scenario:   Local server having number of databases. We need to take backup of local databases and restored this database into the remote server. For this scenario we will follow certain steps: Step 1 : Create object of Remote Server Add remote server object in local server Syntax:     sp_addlinkedserver @server = N'LinkServer' ,     @srvproduct = N' ' ,     @provider = N'SQLNCLI' ,     @datasrc = N'Server Name ,     @catalog = N'Database Name' Here we have created object of remote server i.e. LinkServer . By using this object you can perform Select, Update functionality on the same. Step 2 : Grant Permission Next Step...
Read more

JSON_Automated_stored_procedure

Image
What is JSON: JSON stands for  J ava S cript  O bject  N otation, and is a way to store information in an organized, easy-to-access manner, "self-describing" and easy to understand. It gives us a human-readable collection of data that we can access in a really logical manner. Why we need JSON: JSON is a lightweight data-interchange format and it is language independent. Many sites are sharing data using JSON in addition to RSS feeds nowadays, and with good reason: JSON feeds can be loaded asynchronously much more easily than XML/RSS. Format of JSON string: JSON Example { "employees" :[     { "firstName" : "John" ,   "lastName" : "Doe" },     { "firstName" : "Anna" ,   "lastName" : "Smith" },     { "firstName" : "Peter" ,   "lastName" : "Jones" }             ] } You can compa...
Read more