Creating measure groups/folders

Question

Creating measure groups/folders

Shaira

SSCrazy

Points: 2432
More actions
February 8, 2011 at 1:03 pm

#143246

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

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

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

ssills Old Hand Points: 375 More actions · Answer 1

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.

miriyalasrihari Ten Centuries Points: 1225 More actions · Answer 2

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]

Shaira SSCrazy Points: 2432 More actions · Answer 3

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

Shaira SSCrazy Points: 2432 More actions · Answer 4

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.

miriyalasrihari Ten Centuries Points: 1225 More actions · Answer 5

miriyalasrihari

Ten Centuries

Points: 1225

February 9, 2011 at 9:04 pm

#1284934

thanks,

i got it...

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

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 6

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.

blom0344 SSCrazy Points: 2235 More actions · Answer 7

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?

ssills Old Hand Points: 375 More actions · Answer 8

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.

blom0344 SSCrazy Points: 2235 More actions · Answer 9

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?