Cube name missing in $system.mdschema_dimensions

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » Cube name missing in $system.mdschema_dimensions

Cube name missing in $system.mdschema_dimensions

Topic RSS Feed

Posts under the topic: Cube name missing in $system.mdschema_dimensions

Posted: 7/11/2012

Maxui
Maxui
Jedi Youngling 86  points  Jedi Youngling
  • Joined on: 8/15/2011
  • Posts: 6

HI

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

http://www.bidn.com/Assets/Uploaded-CMS-Files/UAT-5bfe0e68-9c32-4f3e-a1a6-0fce6bc63107.jpg

http://www.bidn.com/Assets/Uploaded-CMS-Files/DEV-f24b99a9-69b9-472f-a720-51e32dbd93d7.png

Why does the CUBE_NAME not appear in the UAT version of the same cube?

thanks

 

 Matt

 

 

Posted: 7/11/2012

Maxui
Maxui
Jedi Youngling 86  points  Jedi Youngling
  • Joined on: 8/15/2011
  • Posts: 6

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?
Page 1 of 1 (2 items)