Hi guys,

We currently define our dimensions using a view with a static filter like below:

<View alias="MON_VIEW_DIM_ADVERTISER_ORDER">
<SQL dialect="generic">
SELECT *
FROM ORDER
WHERE STATUS IN (1,2,3)
</SQL>
</View>

I would like to change this to something which can take a dynamic filter to subset the dimension returned like


<View alias="MON_VIEW_DIM_ADVERTISER_ORDER">
<SQL dialect="generic">
SELECT *
FROM ORDER
WHERE STATUS IN (1,2,3) and ORDER_FIELD = :DYNAMIC_REPLACED_STRING
</SQL>
</View>

How can this be achieved in MDX?

Regards,
Amit