SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Tabular model measures empty
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SoftFox
Starting Member

42 Posts

Posted - 07/02/2013 :  12:17:40  Show Profile  Click to see SoftFox's MSN Messenger address  Reply with Quote
After creating measure in my SQL Server 2012 SSAS tabular model, the values intermittently disappear. I.e. in the measure grid, the values for all my measures just disappear. Occasionally reopening the project has brought them back, but currently this is not working. Very frustrating..

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 07/03/2013 :  01:10:02  Show Profile  Reply with Quote
hmm...not something I've seen so far. Whats the version you're using? when does the disappearing occur?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

SoftFox
Starting Member

42 Posts

Posted - 07/03/2013 :  05:40:42  Show Profile  Click to see SoftFox's MSN Messenger address  Reply with Quote
The server data tools runs under visual studio 2010 10.0.40219.1 SP1

It seems to happen randomly, I'm not aware of anything in particular that triggers it. Ive tried recreating the measures and re-process the model.

Also I recreated one model from scratch and saved this (with the measure values still working), then opened this on another computer, connected and processed the model, and the measure values have again disappeared.

However I have had the issue occur on both computers I use.
Go to Top of Page

SoftFox
Starting Member

42 Posts

Posted - 07/24/2013 :  03:37:02  Show Profile  Click to see SoftFox's MSN Messenger address  Reply with Quote
Update on this: I have found this can occur if a measure is entered with an error such as M:=DATEVALUE("13/13/2012") - instead of showing an error all the values for ALL the measures just dissapear but no error shown. I have managed to get them back by deleting the measure - (just fixing the error does not work) save , close and re open the model file. This has at least worked today cant say if always will work. Surprised no other reports of this it has been happening for me since day 1 of using tabular models.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 07/24/2013 :  03:40:35  Show Profile  Reply with Quote
quote:
Originally posted by SoftFox

Update on this: I have found this can occur if a measure is entered with an error such as M:=DATEVALUE("13/13/2012") - instead of showing an error all the values for ALL the measures just dissapear but no error shown. I have managed to get them back by deleting the measure - (just fixing the error does not work) save , close and re open the model file. This has at least worked today cant say if always will work. Surprised no other reports of this it has been happening for me since day 1 of using tabular models.


hmm...but you will get a warning ( ! icon) if i remember correctly in case of an error in the measure calculation

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000