Skip to content
English
  • There are no suggestions because the search field is empty.

Why doesn't the new dimension that I added to my data model show up in Excel?

Situation:  A user has an existing data model with associated Excel workbook that is open, adds a new dimension to the data model in AtScale, deploys it, refreshes the Excel workbook and doesn't see the newly added dimension in Excel.

Question:  When I click 'Refresh All' in my Excel Data tab...why can't I see the new dimension? 

Answer:  This is expected behavior based on how Excel works.  Upon a Refresh All in Excel, certain metadata is updated (like MDSCHEMA_CUBES, MDSCHEMA_HIERARCHIES, MDSCHEMA_MEASURES) but not MDSCHEMA_DIMENSIONS.  Dimension metadata is only refreshed on reconnection.

Note: when you reconnect AtScale to Excel, the new dimension does show up.