dbTalk Databases Forums  

Grouping Calculated Members

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Grouping Calculated Members in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hans
 
Posts: n/a

Default Grouping Calculated Members - 05-10-2006 , 10:38 AM






Hi,

Is it possible to group calculated members (perhaps in Folders) ? I have
over 70 calculated members and this is a long list, for which I have to
scroll for seeing the dimensions after them.

Thanks
Hans



Reply With Quote
  #2  
Old   
Designing-Systems.com
 
Posts: n/a

Default RE: Grouping Calculated Members - 05-10-2006 , 02:31 PM






hi,

Yes in MS SQL Server 2005 you can group measures in folders. Select the
measures and simply type the name of the folder in the properties window so
that all related measures have the same folder.

Kind regards,

----------------------------------------
http://www.Designing-Systems.com
Email. Support (AT) Designing-Systems (DOT) com
------------------------------------------------

"Hans" wrote:

Quote:
Hi,

Is it possible to group calculated members (perhaps in Folders) ? I have
over 70 calculated members and this is a long list, for which I have to
scroll for seeing the dimensions after them.

Thanks
Hans




Reply With Quote
  #3  
Old   
Hans
 
Posts: n/a

Default Re: Grouping Calculated Members - 05-14-2006 , 06:47 AM



Thanks for your answer, but I didn't find any "folder"-property with
"Calculated Items". Calculated Items don't have properties. Only Measures I
can group with "Display folders", but there are no properties at culculated
items. Or did I something wrong?

Thanks for any help.
Hans


"Designing-Systems.com" <Support (AT) Designing-Systems (DOT) com> schrieb im
Newsbeitrag news:87A6463E-A490-4D16-93E0-D467D4A6057F (AT) microsoft (DOT) com...
Quote:
hi,

Yes in MS SQL Server 2005 you can group measures in folders. Select the
measures and simply type the name of the folder in the properties window
so
that all related measures have the same folder.

Kind regards,

----------------------------------------
http://www.Designing-Systems.com
Email. Support (AT) Designing-Systems (DOT) com
------------------------------------------------

"Hans" wrote:

Hi,

Is it possible to group calculated members (perhaps in Folders) ? I have
over 70 calculated members and this is a long list, for which I have to
scroll for seeing the dimensions after them.

Thanks
Hans






Reply With Quote
  #4  
Old   
Deepak Puri
 
Posts: n/a

Default Re: Grouping Calculated Members - 05-15-2006 , 11:27 AM



Hi Hans,

The location of "Calculation Properites" icon is not too intuitive, but
it is on the toolbar of Calculations tab:

http://msdn2.microsoft.com/en-us/library/ms189712.aspx
Quote:
Calculation Properties Dialog Box (Analysis Services)

Use the Calculation Properties dialog box in Business Intelligence
Development Studio to view or edit the display folder and associated
measure group properties of calculations defined on the Calculations tab
in Cube Designer for the selected cube. You can display the Calculation
Properties dialog box by clicking Calculation Properties on the Toolbar
pane on the Calculations tab in Cube Designer.
...
Quote:

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***


Reply With Quote
  #5  
Old   
Hans
 
Posts: n/a

Default Re: Grouping Calculated Members - 05-18-2006 , 06:40 AM



Hi Deepak,

Thanks for the hint. This is what i need, but I hadn't found them!!

Thanks again.
Hans

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> schrieb im Newsbeitrag
news:usvelxDeGHA.1264 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
Quote:
Hi Hans,

The location of "Calculation Properites" icon is not too intuitive, but
it is on the toolbar of Calculations tab:

http://msdn2.microsoft.com/en-us/library/ms189712.aspx

Calculation Properties Dialog Box (Analysis Services)

Use the Calculation Properties dialog box in Business Intelligence
Development Studio to view or edit the display folder and associated
measure group properties of calculations defined on the Calculations tab
in Cube Designer for the selected cube. You can display the Calculation
Properties dialog box by clicking Calculation Properties on the Toolbar
pane on the Calculations tab in Cube Designer.
..



- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.