Skip to content

aggregationprefix-element-assl.md

Latest commit

 

History

History
83 lines (63 loc) · 3.35 KB

aggregationprefix-element-assl.md

File metadata and controls

83 lines (63 loc) · 3.35 KB
title AggregationPrefix Element (ASSL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
AggregationPrefix Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
AggregationPrefix
helpviewer_keywords
AggregationPrefix element
ms.assetid 1581e0df-ae8e-41ce-9c92-f0f7cac487f2
caps.latest.revision 36
author Minewiskan
ms.author owend
manager erikre

AggregationPrefix Element (ASSL)

Defines the common prefix to be used for aggregation names throughout the associated parent element.

Syntax

  
<Cube> <!-- or Database, MeasureGroup, Partition -->  
   ...  
   <AggregationPrefix>...</AggregationPrefix>  
   ...  
</Database>

Element Characteristics

Characteristic Description
Data type and length String
Default value None
Cardinality 0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element
Parent elements Cube, Database, MeasureGroup, Partition
Child elements None

Remarks

Aggregation prefixes generate aggregation names in [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion], and also generate table names in the relational database for aggregations stored in a relational OLAP (ROLAP) partition.

A fully expanded aggregation name has the following parts:

<DatabasePrefix><CubePrefix><MeasureGroupPrefix><PartitionPrefix><AggregationID>

The first four parts of the aggregation name make up the aggregation prefix. The user provides the first four parts:

  • DatabasePrefix represents the value of the AggregationPrefix element associated with a Database element.

  • CubePrefix represents the value of the AggregationPrefix element associated with a Cube element.

  • MeasureGroupPrefix represents the value of the AggregationPrefix element associated with a MeasureGroup element.

  • PartitionPrefix represents the value of the AggregationPrefix element associated with a Partition element.

The fifth part of the name, AggregationID, is a system-defined ID, and users have no control over this part of the name.

The elements that correspond to the parents of AggregationPrefix in the Analysis Management Objects (AMO) object model are xref:Microsoft.AnalysisServices.Cube, xref:Microsoft.AnalysisServices.Database, xref:Microsoft.AnalysisServices.MeasureGroup, and xref:Microsoft.AnalysisServices.Partition.

See Also

Properties (ASSL)