Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Defines or filters a member in an attribute on which a parent Insert, Update, or Drop command performs.
<Attributes>
...
<Attribute>
<AttributeName>...</AttributeName>
<Keys>...</Keys>
<!-- The following elements are included only for attributes contained in the Attributes element of a parent Insert or Update command -->
<Name>...</Name>
<Translations>...</Translations>
<CustomRollup>...</CustomRollup>
<CustomRollupProperties>...</CustomRollupProperties>
<UnaryOperator>...</UnaryOperator>
<SkippedLevels>...</SkippedLevels>
</Attribute>
...
</Attributes>
Characteristic | Description |
---|---|
Data type and length | None |
Default value | None |
Cardinality | 1-1: Required element that occurs once and only once. |
Relationship | Element |
---|---|
Parent elements | Attributes |
Child elements | See the table below. |
Ancestor or Parent | Child Element |
---|---|
Drop, Where | AttributeName, Keys |
Insert, Update | AttributeName, CustomRollup, CustomRollupProperties, Keys, Name, SkippedLevels, Translations, UnaryOperator |
The Attribute element defines the attribute member that is inserted, updated, or deleted, respectively, by the Insert, Update, or Drop command. As these commands can operate only on one attribute member at a time, the Attributes collection of the Insert, Update, and Drop commands can contain only one Attribute element. However, the Attributes collection of the Where element for the Drop and Update commands can contain more than one Attribute element, so that you can filter the attributes to be dropped or updated in a write-enabled dimension.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today