Measures Disappear in Local/Offline Cube

When u make a local cube from a server cube by executing the “Create Global Cube” statement, u often face a problem when a calculated measure does not show up in the local/offline cube. Whenever it happens, check out if you are suffering from the following reasons:

  • The calculated measure is using another measure inside the calculation and that measure is not defined earlier. In the MDX script, the measure which is being used in the calculation must be placed before you start writing the new measure that uses it. 
  • Sometimes, we write a default value for the calculated measure. For example, “N/A”, “Undefined” etc. In this case, the measure, although will appear in the server cube but will not show up in the local/offline cube.
  • Measures using DistinctCount function will not work in the local/offline cube. May not appear, too.

About Zahid

Team Lead at IQVIA ( Fields of expertise are C#,BI Reporting (MSBI, Microstrategy, Excel, ASP.NET Dashboards etc.) , ETL, Data Warehouse, OLAP Cube, MDX etc.
This entry was posted in MDX, SSAS (Analysis Service), Cube. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s