Anand,Quote:> I think I figured out a way to know the Calculated measures.
> I issue a MDSCHEMA_MEASURES RequestType and watch for <EXPRESSION> tag
> in the returnd rowsets for the measures. The tag is present for the
> calculated members, and is absent for the others.
This is very unsafe thing to do. It would miss many other cases (calculated
members which are not measures is one obvious example). If your goal is to
discover when DRILLTHROUGH will work, the closest I can think of would be
UPDATEABLE cell property. All the calculated cells are both not updateable
and not drill through'able. However, there still will be cells which are
updateable but not drill through'able and vice versa.
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.