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

10+ years of experience in BI and DWH technologies. Fields of expertise are BI Reporting (MSBI, Microstrategy, Excel, Power BI) , 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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.