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.