Creating measure groups/folders

  • I have an existing cube, which I will be adding a lot more measures to as we will now be reporting in various currencies. I would like to provide my end users folders of US dollar, Japanese Yen, etc. Is there a way to do this? All my measures are in one table, so when I created my cube I ended up with one long list of measures. I'm a newbie at this, so any help would be great!

    TIA!

    ~~ using SQL 2008

  • Yes. Measures have a "DisplayFolder" property to which you can assign a text value. If the client application recognizes this property, this setting should give you want you want. Excel 2007 and 2010, for example, do use this value for organizing measures and attributes.

  • i am right clicking on measures and go to properties,

    i am not find any Diaplay folder poperty in measures(BIDS)

    i am using SQL server 2008 Enterprise edition

    [font="Verdana"]SRIHARI(:~[/font]

  • Also, how do you separate your measures into the different folders that you create?

  • Hi Srihari ~ I think I found it. If you right click on a single measure and choose properties you will see the DisplayFolder. If you put the measures in Grid View, you can select multiple measures by using your ctrl button.

  • thanks,

    i got it...

    [font="Verdana"]SRIHARI(:~[/font]

  • Just FYI, this also supports depth of > 1 too, so you can enter

    \Othermeasures\Japanese\J1

    \Othermeasures\Japanese\J2

    \Othermeasures\Mine

    for three different measures, assuming your end user tool supports it, this will give you a tree of folders, where Japanese will have two child folders, and Othermeasures will have two children (one of which is Japanese).

    Steve.

  • Sorry for reopening quite an old topics, but the Display Folder mechanism seems to be a bit of an afterthought. With translations added to the model and some 50 measures linked to a Display Folder it looks like I need to add a caption 50 times (instead of once) for the object type 'Display Folder'. There seems to be no GUI to work on display folders?

  • blom0344 (11/20/2012)


    Sorry for reopening quite an old topics, but the Display Folder mechanism seems to be a bit of an afterthought. With translations added to the model and some 50 measures linked to a Display Folder it looks like I need to add a caption 50 times (instead of once) for the object type 'Display Folder'. There seems to be no GUI to work on display folders?

    I believe the BIDS Helper tool on Codeplex has a feature that can manage calculation properties if you enter the information there. You can download it here: [/url].

    I personally don't use the helper for this function. If I need to make a bulk change in the folder location, I switch to script mode and use the FIND functionality of the editor. At least for the calculated measures.

  • I was really after a solution for not having to enter a display folder name for an additional language multiple times (the same number of measures with properties set to a specific folder. Would that be covered by the BIDS helper or is it easier to 'hack' the code somewhere?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply