I have 2 instances of the same cube, one on my DEV box and the other on UAT.
issuing the following query on both boxes prduces 2 different results
SELECT a.* FROM OPENROWSET('MSOLAP','DATASOURCE=rm1; Initial Catalog=RadaCube_Indexed2;','SELECT * FROM $system.mdschema_dimensions WHERE Dimension_Name <> ''measures''') as a
Why does the CUBE_NAME not appear in the UAT version of the same cube?
So it turns out that if you restore a cube from a backup to a new server the $system.mdschema_dimensions DMV does not get updated with the CUBE DIMENSION
but if you DEPLOY from BIDs the DMV is updated correctly
think this is a bug?