Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation 
DAX query
Returns a table with information about each attribute hierarchy storage in the semantic model. This function provides metadata about the storage characteristics of attribute hierarchies.
Syntax
INFO.ATTRIBUTEHIERARCHYSTORAGES ( [<Restriction name>, <Restriction value>], ... )
Parameters
Parameters are optional for this DAX function. When parameters are used, both must be given. More than one pair of parameters is allowed. The restriction name and value are text and entered in double-quotes.
| Term | Definition |
|---|---|
| Restriction name | Name of the restriction used to filter the results. |
| Restriction value | Value used to filter the results of the restriction. |
Restrictions
Typically, all columns of the DAX function results can be used as a restriction. Additional restrictions may also be allowed.
Return value
A table whose columns match the schema rowset for attribute hierarchy storages in the current semantic model:
| Column | Description |
|---|---|
| [ID] | A reference to the object. IDs are usually autogenerated and should not be changed after the model is created. Data type is unsigned long (4 bytes). |
| [AttributeHierarchyID] | An ID-based reference to a AttributeHierarchy object. |
| [SortOrder] | The sort order used for the attribute hierarchy storage. |
| [OptimizationLevel] | The optimization level applied to the attribute hierarchy storage. |
| [MaterializationType] | The type of materialization used for the attribute hierarchy. |
| [ColumnPositionToData] | Mapping information from column position to data values. |
| [ColumnDataToPosition] | Mapping information from data values to column position. |
| [DistinctDataCount] | The number of distinct data values in the attribute hierarchy. |
| [DataVersion] | The version of the data in the attribute hierarchy storage. |
| [StorageFileID] | Reference to the storage file containing the attribute hierarchy data. |
| [SystemTableID] | Reference to the system table associated with the attribute hierarchy. |
| [HasStatistics] | Boolean indicating whether statistics are available for the attribute hierarchy. |
| [MinValue] | The minimum value in the attribute hierarchy. |
| [MaxValue] | The maximum value in the attribute hierarchy. |
| [StringValueMaxLength] | The maximum length of string values in the attribute hierarchy. |
Remarks
- Typically used in DAX queries to inspect and document model metadata.
- Permissions required depend on the host. Querying full metadata may require model admin permissions.
Example 1 - DAX query
The following DAX query can be run in DAX query view:
EVALUATE
INFO.ATTRIBUTEHIERARCHYSTORAGES()