Skip to content

Latest commit

 

History

History
37 lines (29 loc) · 1.85 KB

File metadata and controls

37 lines (29 loc) · 1.85 KB
title Creating and Using Property Values (MDX) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology analysis-services
ms.topic conceptual
helpviewer_keywords
property values [MDX]
queries [MDX], property values
MDX [Analysis Services], property values
Multidimensional Expressions [Analysis Services], property values
ms.assetid 0cafb269-03c8-4183-b6e9-220f071e4ef2
author minewiskan
ms.author owend
manager craigg

Creating and Using Property Values (MDX)

Multidimensional Expressions (MDX) supports intrinsic and user-defined properties for dimensions, levels, members, and cells. The intrinsic properties provide unique names, captions, and even formatting and font sizes for individual cells. User-defined properties, on the other hand, can provide almost any kind of additional attribute to members.

Intrinsic and user-defined properties are available at the following levels:

Member properties
Member properties cover the basic information about each member in each tuple. This basic information includes the member name, parent level, the number of children, and so on.

For information about member properties and how to use them, see Using Member Properties (MDX).

Cell properties
Cell properties contain information about the content and format of cells in a multidimensional data source, such as a cube.

For more information about cell properties and how to use them, see Using Cell Properties (MDX).

See Also

MDX Query Fundamentals (Analysis Services)