ms.date: 05/08/2018

ms.prod: sql

ms.technology: analysis-services

ms.date: 05/08/2018

ms.prod: sql

ms.technology: analysis-services

|Property|Description|

|--------------|-----------------|

|**Encrypt Password**|Specifies whether a local password is to be used to encrypt local cubes. Valid values are True or False. The default is False.|

|**Encryption Password**|The password used to decrypt an encrypted local cube. Default value is empty. This value must be explicitly set by the user.|

|**Impersonation Level**|Indicates the level of impersonation that the server is allowed to use when impersonating the client. Valid values include:<br /><br /> - Anonymous. The client is anonymous to the server. The server process cannot obtain information about the client, nor can the client be impersonated.<br />- Identify. The server process can get the client identity. The server can impersonate the client identity for authorization purposes but cannot access system objects as the client.<br />- Impersonate. This is the default value. The client identity can be impersonated, but only when the connection is established, and not on every call.<br />- Delegate. The server process can impersonate the client security context while acting on behalf of the client. The server process can also make outgoing calls to other servers while acting on behalf of the client.|

|[DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS](https://msdn.microsoft.com/library/ee320710)|Returns information about the column segments used for storing data for in-memory tables.|

|[DISCOVER_STORAGE_TABLE_COLUMNS](https://msdn.microsoft.com/library/ee302101)|Contains information about the columns used for representing the columns of an in-memory table.|

|[DISCOVER_STORAGE_TABLES](https://msdn.microsoft.com/library/ee302014)|Returns statistics about in-memory tables available to the server.|

|[DISCOVER_TRACE_DEFINITION_PROVIDERINFO](https://msdn.microsoft.com/library/ee301342)|Contains the DISCOVER_TRACE_COLUMNS schema rowset.|

|[DISCOVER_TRACE_EVENT_CATEGORIES](https://msdn.microsoft.com/library/ee320442)|Contains the DISCOVER_TRACE_EVENT_CATEGORIES schema rowset.|

|[DISCOVER_TRACES](https://msdn.microsoft.com/library/ee301643)|Contains the DISCOVER_TRACES schema rowset.|

[!INCLUDE[ssas-appliesto-sqlas](../../includes/ssas-appliesto-sqlas.md)]

A calculated member is a member whose value is calculated at run time using a Multidimensional Expressions (MDX) expression that you specify when you define the calculated member. A calculated member is available to business intelligence applications just like any other member. Calculated members do not increase the size of the cube because only the definitions are stored in the cube; values are calculated in memory as required to answer a query.

- Results in the selection of more effective aggregates by the aggregation design algorithms, provided that user-defined hierarchies have been defined along the relationship paths.

When the underlying data supports it, you should also define unique attribute relationships between attributes. To define unique attribute relationships, use the **Attribute Relationships** tab of Dimension Designer.

For a full backup that includes source data, you have to back up the database which contains detail data. Specifically, if you are using ROLAP or DirectQuery database storage, detail data is stored in an external SQL Server relational database that is distinct from the Analysis Services database. Otherwise, if all objects are tabular or multidimensional, the Analysis Services backup will include both the metadata and source data.

This topic includes the following sections:

- The Calculation Expressions pane supports a form view and a script view.

To create a new calculation, on the **Calculations** tab of Cube Designer, on the **Cube** menu, click either **New Calculated Member**, **New Named Set**, or **New Script Command**, depending on the type of calculation you want to create. You can also click any of the corresponding buttons on the toolbar, or right-click anywhere in the **Script Organizer** pane and then click one of the commands on the shortcut menu. This action adds a new calculation to the **Script Organizer** pane and displays fields for it in the calculations form in the Calculations Expressions pane. If you create a new script, this action opens the Script view in the Calculation Expressions pane. For more information about building the three types of calculations, see [Create Calculated Members](../../analysis-services/multidimensional-models/create-calculated-members.md), [Create Named Sets](../../analysis-services/multidimensional-models/create-named-sets.md), and [Define Assignments and Other Script Commands](../../analysis-services/multidimensional-models/define-assignments-and-other-script-commands.md).

[!INCLUDE[ssas-appliesto-sqlas](../../includes/ssas-appliesto-sqlas.md)]