Hi,
Could someone help me to write a MDX script to calculate a measure for all level of a hierachy?
I explain you:
I have a hierarchy "Product" with these levels
1- Category
2- Subcategory
3- Product
I want to have in the same request to have the [measures].[Value] for all level for my hierarchy.
I have this:
SELECT {[MEASURES]. [VALUE]} ON COLUMNS
, {[PRODUCT].[PRODUCT].[ID_PRODUCT]} ON ROWS
FROM MYCUBE
WHERE [DIM_TIME]&.[201406]
Could someone help me ?