Here is the query to fetch the possible measures available in the Knowledge Cubes
SELECT [CATALOG_NAME] as [DATABASE],
CUBE_NAME AS [CUBE],[MEASUREGROUP_NAME] AS [FOLDER],[MEASURE_CAPTION] AS [MEASURE],
[MEASURE_IS_VISIBLE]
FROM $SYSTEM.MDSCHEMA_MEASURES
WHERE CUBE_NAME ='MDXProjectCube'
ORDER BY [MEASUREGROUP_NAME]
No comments:
Post a Comment