locked
SQL 2012 "Denali" & VS 2010: Error when creating measures in BISM (.bim) Model RRS feed

  • Question

  • Tabular Model Creation: I am following the tutorial found below.

    http://msdn.microsoft.com/en-us/library/hh231691(v=SQL.110).aspx

    The step when you use the summation button to create a measure in the tabular model fails with an error.  All summation options are failing on all columns.   Any advice would be greatly appreciated. Error Screenshot attached

    OS: Windows Server 2008 R2 (64bit)

    SQL Server Version: Denali CTP3

    Database Version: AdventureWorksDWDenali

    Visual Studio 2010 Version: 10.0.40219.1 SP1Rel

     

     



    • Edited by ajar543 Friday, November 11, 2011 5:51 PM
    Friday, November 11, 2011 4:39 PM

All replies

  • The above issue was solved by removing the Fact Table from the model and re-creating it.  After this I was able to create measures using the summation button....

    I really do not have an explanation, except that maybe something was corrupted during the generation/deployment of this entity. 

    If anyone has anything that would be great.

    Thanks,

    Raja

    Monday, November 14, 2011 3:19 PM