locked
Tabular Measure group RRS feed

  • Question

  • Hi expert,

      Can I group tabular measure like multidimensional cube measure groups ?

    Thanks 


    James Liang

    Thursday, February 18, 2016 8:02 PM

Answers

  • Hi James,

    As Simon wrote, you have two options:

    1) If you want to manage it on a GUI, you need to install BIDS Helper first, then you'll have a new context menu when right-clicking on the bim file, called "Tabular Display folder".

    2) You modify the code directly. Select View/Code menu, then search for the <DisplayFolder> element, and then add the name of the new display folder. It's available since Analysis Services 2005 (see https://msdn.microsoft.com/en-us/library/ms126990(v=sql.90).aspx), it's just that currently there is no option for setting up the display folder in Visual Studio (SSDT) for tabular model measures, regardless of the version of your SSDT.

    Regards,

    Zoli

    • Marked as answer by JamesLiang Wednesday, February 24, 2016 5:49 PM
    Tuesday, February 23, 2016 8:33 AM

All replies

  • Hi James,

    In Analysis Services Tabular, we can only define display folder property for measure via XMLA code by default. But you can use BIDS Helper to organize measure into folder on GUI. Please refer to article below:

    https://www.sqlbi.com/articles/organizing-measures-and-attributes-in-folders-with-tabular/

    Regards, 


    Simon Hou
    TechNet Community Support


    Monday, February 22, 2016 2:59 AM
  • Hi Simon,

      I used VS 2012 & SQL 2012 Tabular. in VS2012, for Dimension, I can create the attribute.

    but for measure, I didn't find "Display Folder". is it SQL 2016 new function ?

    Thanks


    James Liang

    Monday, February 22, 2016 10:12 PM
  • Hi James,

    As Simon wrote, you have two options:

    1) If you want to manage it on a GUI, you need to install BIDS Helper first, then you'll have a new context menu when right-clicking on the bim file, called "Tabular Display folder".

    2) You modify the code directly. Select View/Code menu, then search for the <DisplayFolder> element, and then add the name of the new display folder. It's available since Analysis Services 2005 (see https://msdn.microsoft.com/en-us/library/ms126990(v=sql.90).aspx), it's just that currently there is no option for setting up the display folder in Visual Studio (SSDT) for tabular model measures, regardless of the version of your SSDT.

    Regards,

    Zoli

    • Marked as answer by JamesLiang Wednesday, February 24, 2016 5:49 PM
    Tuesday, February 23, 2016 8:33 AM