In Analysis Services 2005, I haven't been able to define a "calculated
member" as the default measure of a cube. In Analysis Services 2000, it was
possible.

Is it a known limitation of Analysis Services 2005, or am I missing something?

Sincerely.
Elyo Ravuna

Hello Elyo,

I am not quite sure about what you mean by "default measure". Will you
explain this or your requirements in more details?

I assume that you want create calculated member in the cube so that you
could use it as a measure in cube browser. If it is the issue, I suggest
that you refer to "How to: Create a calculated member" topic in SQL 2005
Book Online for help.

You could create a calculated member in cube desinger of a Analysis Service
project in Visual Studio. After you deploy the project to AS, and you open
cube browser, you could see it is listed under Measures node.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Dear Peter, I appreciate your effort to help. However my question is
unanswered. MDX requires every dimension to have a default member and the
measures dimension is no exception. Since the first version of Microsoft OLAP
Services, cubes have default measures.

My question is: How can I define a calculated member as the default measure
of a cube? I was able to define it in Analysis Services 2000, but I haven't
found a way to do it in Analysis Services 2005.

Sincerely.
Elyo Ravuna


"Peter Yang [MSFT]" wrote:

Elyo - in the engine this is done exactly the same way as in AS2000 -
through ALTER CUBE statement, however I agree that we had better UI support
in AS2000 for that.
Below is example from MDX Script which sets default measure to the
calculated measure:

CREATE MyCM = 5;

ALTER CUBE Sales UPDATE DIMENSION Measures, Default_Member =
'Measures.MyCM';


--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =

Hello Elyo,

I am sorry but I wonder if you tried the following steps I mentioned? I
think caculated member is still "default member" of measure (dimension) as
that in AS 2000 but

Create a calculated member in cube desinger of a Analysis Service project
in Visual Studio 2005. After you deploy the project to AS, and you open
cube browser, you could see the calucated member is listed under Measures
node of the cube. Most edit/design work used to work in AS Manager is not
transfered to Cube designer in AS project in VS 2005 or Development Studio.
I have included the following steps from BOL for your reference:

=========================================

You create a calculated member by using the Calculations view in Cube
Designer, which can be accessed from either SQL Server Management Studio or
Business Intelligence Development Studio. After you create the calculated
member, it becomes available to users after you re-deploy the cube.

To create a calculated member
Open the cube for which you want to create a calculated member, and click
the Calculations tab.

On the toolbar, click the New Calculated Member button, and then in the
expression pane, do the following:

Under Name, type a name for the calculated member.

From the Parent hierarchy drop-down list, choose the parent hierarchy.

From the Parent member drop-down list, choose the parent member, if
applicable.

Under Expression, create a Multidimensional Expressions (MDX) expression to
define the calculated member. You can either type the expression manually,
or you can drag and drop items from the Metadata and Functions tabs.

Optionally, expand Additional Properties, and then do the following:

Set the Format string and Visible properties: choose settings from the
drop-down lists next to each property name.

Set the Fore color, Back color, Font name, Font size, and Font flags
properties: click the button to the right of each text box, click the
setting you want, and then click OK. Alternatively, you can type the values
manually.
======================================

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------