| Create (Member) | (standard MDX) |
Creates a calculated member/measure.
Description
The following statement allows for adding calculated member to schema dimensions. It is very similar to the WITH MEMBER statement:
CREATE [ CALCULATED ] MEMBER unique-name AS MDX-expression
Note that for defining a CALCULATED measure you'll have to specify the cube the calculated measure declaration applies to (then the [Measures] dimension is optional):
CREATE CALCULATED MEMBER [Sales].[Measures].[Diff with United States] AS '[Measures].[Amount] - ([Geography].[United States],[Measures].[Amount])'
Please, check working examples for further explanation.
See Also
Calculated Members Drop (Member) Create (Function) Create (Set)
Examples
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.