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.

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 )

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.