Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating measure groups/folders Expand / Collapse
Author
Message
Posted Tuesday, February 8, 2011 1:03 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:47 AM
Points: 65, Visits: 259
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
Post #1060587
Posted Tuesday, February 8, 2011 3:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 8, 2014 12:39 PM
Points: 11, Visits: 116
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.
Post #1060709
Posted Tuesday, February 8, 2011 9:03 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 14, 2012 11:52 PM
Points: 63, Visits: 257
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


SRIHARI(:~
Post #1060795
Posted Wednesday, February 9, 2011 7:35 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:47 AM
Points: 65, Visits: 259
Also, how do you separate your measures into the different folders that you create?
Post #1061130
Posted Wednesday, February 9, 2011 10:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:47 AM
Points: 65, Visits: 259
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.
Post #1061330
Posted Wednesday, February 9, 2011 9:04 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 14, 2012 11:52 PM
Points: 63, Visits: 257
thanks,

i got it...


SRIHARI(:~
Post #1061679
Posted Wednesday, February 9, 2011 9:27 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, August 6, 2014 8:12 AM
Points: 1,815, Visits: 3,456
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.
Post #1061681
Posted Tuesday, November 20, 2012 11:02 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 24, 2013 12:12 PM
Points: 72, Visits: 326
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?
Post #1387066
Posted Tuesday, November 20, 2012 2:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 8, 2014 12:39 PM
Points: 11, Visits: 116
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=http://bidshelper.codeplex.com/][/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.
Post #1387169
Posted Tuesday, November 20, 2012 11:54 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 24, 2013 12:12 PM
Points: 72, Visits: 326
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?
Post #1387248
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse