 | |
Setting the default member
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Setting the default member -
05-10-2004
, 10:25 AM
#2
| |||
| |||
|
|
Is there a solution to select more than one member in a dimension. The default member for a dimension is usually at the "All level". But I want to set e.g. in the product- dimension of Foodmart2000 the default members to [Product].[Product Family].&[Drink] and [Product]. [Product Family].&[Food]. Many thanks. |
Hi,
you can create a calc member in the cube with sum of Drink and Food and then
use it as the default in the dimension.
HTH,
Matthias
#3
| |||
| |||
|
|
-----Original Message----- "reinfried.englmairqc-bergmann.at" anonymous (AT) discussions (DOT) microsoft.com schrieb im Newsbeitrag news:ad3201c436a3$0ab093d0 $a601280a (AT) phx (DOT) gbl... Is there a solution to select more than one member in a dimension. The default member for a dimension is usually at the "All level". But I want to set e.g. in the product- dimension of Foodmart2000 the default members to [Product].[Product Family].&[Drink] and [Product]. [Product Family].&[Food]. Many thanks. Hi, you can create a calc member in the cube with sum of Drink and Food and then use it as the default in the dimension. HTH, Matthias . |
#4
| |||
| |||
|
|
-----Original Message----- "reinfried.englmairqc-bergmann.at" anonymous (AT) discussions (DOT) microsoft.com schrieb im Newsbeitrag news:ad3201c436a3$0ab093d0 $a601280a (AT) phx (DOT) gbl... Is there a solution to select more than one member in a dimension. The default member for a dimension is usually at the "All level". But I want to set e.g. in the product- dimension of Foodmart2000 the default members to [Product].[Product Family].&[Drink] and [Product]. [Product Family].&[Food]. Many thanks. Hi, you can create a calc member in the cube with sum of Drink and Food and then use it as the default in the dimension. HTH, Matthias . |
#5
| |||
| |||
|
|
-----Original Message----- "reinfried.englmairqc-bergmann.at" anonymous (AT) discussions (DOT) microsoft.com schrieb im Newsbeitrag news:ad3201c436a3$0ab093d0 $a601280a (AT) phx (DOT) gbl... Is there a solution to select more than one member in a dimension. The default member for a dimension is usually at the "All level". But I want to set e.g. in the product- dimension of Foodmart2000 the default members to [Product].[Product Family].&[Drink] and [Product]. [Product Family].&[Food]. Many thanks. Hi, you can create a calc member in the cube with sum of Drink and Food and then use it as the default in the dimension. HTH, Matthias . |
#6
| |||
| |||
|
|
-----Original Message----- You have to create the calc member in the cube: [Product].[my Product] > [Product].[Product Family].& [Drink] + [Product].[Product Family].&[Food] Then go back to the dim editor and type in the name of the calc member ([Product].[my Product]) manually as MDX formula and ignore the message when leaving the editor. This works, as the member will be found when browsing the cube. But you have to be aware that this can lead to problems when using the same (public) dimension in other cubes that don't have this calc member! Regards, Matthias "reinfried.englmair (AT) c-bergmann (DOT) at" anonymous (AT) discussions (DOT) microsoft.com schrieb im Newsbeitrag news:b4b801c43756$febd23e0 $a101280a (AT) phx (DOT) gbl... In the dimension editor I canīt use calc members!!! In the eimension editor only dimension elements are allowed. Also there are no MDX formulars like SUM are allowed. The expression [Product].[Product Family].&[Drink],[Product].[Product Family].&[Food] in the MDX of Default Member in the dimension editor (AdvancedTab) is ignored. The expression [Product].[Product Family].&[Drink] is okay, but I want [Product].[Product Family].&[Drink] AND [Product]. [Product Family].&[Food] -----Original Message----- "reinfried.englmairqc-bergmann.at" anonymous (AT) discussions (DOT) microsoft.com schrieb im Newsbeitrag news:ad3201c436a3$0ab093d0 $a601280a (AT) phx (DOT) gbl... Is there a solution to select more than one member in a dimension. The default member for a dimension is usually at the "All level". But I want to set e.g. in the product- dimension of Foodmart2000 the default members to [Product].[Product Family].&[Drink] and [Product]. [Product Family].&[Food]. Many thanks. Hi, you can create a calc member in the cube with sum of Drink and Food and then use it as the default in the dimension. HTH, Matthias . . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.