SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Creating measure groups/folders


Creating measure groups/folders

Author
Message
Shaira
Shaira
SSC-Enthusiastic
SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)

Group: General Forum Members
Points: 142 Visits: 276
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
ssills
ssills
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 117
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
miriyalasrihari
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 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(:~
Shaira
Shaira
SSC-Enthusiastic
SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)

Group: General Forum Members
Points: 142 Visits: 276
Also, how do you separate your measures into the different folders that you create?
Shaira
Shaira
SSC-Enthusiastic
SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)

Group: General Forum Members
Points: 142 Visits: 276
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
miriyalasrihari
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 257
thanks,

i got it...

SRIHARI(:~
stevefromOZ
stevefromOZ
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: Moderators
Points: 3516 Visits: 3757
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
blom0344
SSC-Enthusiastic
SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)

Group: General Forum Members
Points: 152 Visits: 330
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
ssills
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 117
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.
blom0344
blom0344
SSC-Enthusiastic
SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)

Group: General Forum Members
Points: 152 Visits: 330
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search