DAX formula change place in grid view RRS feed

  • Question

  • Juneau/CTP3: Tabular model. Grid view. You put your DAX formulas in a certain column, say one in column 4 and one in column 6, because of easier management, one part or all of the formula relates to that specific column. Then you save the project. Another team member picks it up. Then both the formulas is in col 1 to the far left of the grid. In no obvious ordering.

    Why is that? Is it something I can fix myself or is it a feature/bug?

    Friday, November 25, 2011 2:39 PM


All replies

  • I believe that the actual grid positioning is stored in a separate file that is not included with the project by default (as it's only cosmetic and has no impact on the functioning of the database). If you are sharing the project using a source control system you can "fix" this issue by adding this file to source control manually. (sorry I don't have a CTP3 environment with me at the moment so I can't check the name of the file, but you should be able to find it in the same folder as your project files).

    Keeping this file separate means that cosmetic changes to layout do not need to trigger a re-deployment to the server.

    http://darren.gosbell.com - please mark correct answers
    Sunday, November 27, 2011 11:22 PM
  • Could you please elaborate on which files it could be: When I start a new solution, "add to TFS source control", I get these files:

    in the solution folder:

    1. Microsoft Visual Studio Solution file
    2. Visual Studio Source Control Solution Metadata File

    in the project myproject folder:

    1.  Analysis Services BIM File
    2. AnalysisServices BISMProject File
    3. Visual Studio Source Control Project Metadata File
    4. and I also get a new "bin" folder

    I run table import wizard and saves project. No new files, and just the model.bim file gets new date/time. When I build the new model I get: new files in bin folder:

    1. Analysis Services Database Deployment Contents
    2. Analysis Services Database Deployment Options
    3. Analysis Services Database Deployment Targets
    4. a new folder obj with a new folder Development with same three files as in bin folder
    5. plus this one: myproj.smproj.FileListAbsolute
    6. also the model.bim file gets updated

    I create one measure on the third column in my fact table - SEK:=SUM([Kr]), click save all, only file with new save date is model.bim.

     I close the project. I open it again. It's still there in third column. I refresh tables to see if data is working. Yes. Closing project (asks for saving. I don't know why it asks me, but I save) just model.bim has new save date.

    I check in the files. Open project. Deploy. Test with analyze in excel. Works fine. close project.

    Then my colleague opens solution on his computer and the Measure SEK is showing itself in the first column, not the third! I open on my computer and it is in the third column.

    Monday, November 28, 2011 10:58 AM
  • In the myproject folder there will be a hidden .settings file that contains the layout of the measures in the measure grid (and I think it may also have some of the layouts from the diagram view). On my test VM it was myproject.BIM_Administrator.settings - so it may create a different file for each login - but this is CTP3 - I have not checked against the RC0 build.
    http://darren.gosbell.com - please mark correct answers
    Monday, November 28, 2011 11:09 PM
  • Note that this is changing for the release version of SQL 2012 and this data is moving to a .layout file - see this blog post for details http://blogs.msdn.com/b/cathyk/archive/2011/12/03/new-for-rc0-the-layout-file.aspx
    http://darren.gosbell.com - please mark correct answers
    • Proposed as answer by Darren GosbellMVP Monday, December 5, 2011 1:27 AM
    • Marked as answer by Challen Fu Wednesday, December 7, 2011 3:28 AM
    Monday, December 5, 2011 1:27 AM