"__Count of Models"-measure in fieldlist for pivottable (Denali CTP 3) RRS feed

  • Question

  • How do I hide (or remove) the "default" Measure named "__Count of Models" that shows up when I have an excel sheet against a tabular model? It shows up as a measure in the fieldlist for the pivottable. I would like to remove it in Visual Studio / Juneau somehow so when I deploy it no user will see it when they access my tabular dimension model.
    Friday, November 18, 2011 3:25 PM

All replies

  • Very easy. Glad you asked.

    Step 1: Right Click the .BIM file and select View Code
    Step 2: Ctrl+F to find __Count of Model
    Step 3: Comment the entire Command block that defines this measure
    Step 4: Save the change made
    Step 5: Now open the .BIM file again --> Build -->Deploy

    Note: This is a default measure auto created having value as 1

    Hope this helps. Feel free to ask anything you wish.
    Thursday, December 8, 2011 12:56 PM