Administering and Monitoring Analysis Services - SQL Server Analysis Services 2012 Cube Development - page 282

DATABASE_NAME DIMENSION_NAME ATTRIBUTE_NAME ATTRIBUTE_COUNT

AdventureWorks_Sample Promotion End Date 11

AdventureWorks_Sample Promotion Start Date 9

AdventureWorks_Sample Promotion Promotion Type 7

AdventureWorks_Sample Promotion Min Quantity 7

AdventureWorks_Sample Promotion Max Quantity 6

AdventureWorks_Sample Promotion Promotion Cat-

egory

4

You can query $system.DISCOVER_PARTITION_STAT much the same way as
DISCOVER_DIMENTION_STAT , except you must provide the cube name as well as
measure group name and partition name, as shown in the following code snippet.
The result will be the aggregation name and aggregation size.

SELECT * FROM SYSTEMRESTRICTSCHEMA (
$SYSTEM.DISCOVER_PARTITION_STAT,
PARTITION_NAME = 'Internet_Sales_2005',
CUBE_NAME = 'Adventure Works',
MEASURE_GROUP_NAME = 'Internet Sales',
DATABASE_NAME='AdventureWorks_Sample')