Hi,

Is there a way to know the type of cell I am querying? In the sense, is
it possible via MDX or XML/A to know if the cell is of calculated or
derived type?

thanks
Anand

--
Posted via http://dbforums.com

What is your definition of "calculated" cell vs. "derived" cell ? Why would
you want to know the difference ?

--
==================================================
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.
==================================================
"anand_h" <razurfish (AT) yahoo (DOT) com> wrote

No, I am not looking for the difference.
All I want to know is that the cell should be a real-physical cell on
which I can perform the DRILLTHROUGH. I understand that the
calculated/derived cells don't support DRILLTHROUGH.

Is there any way to know this?
Thanks
Anand

--
Posted via http://dbforums.com

Yes, there is a cell property called IS_DRILLTHROUGH_ENABLED, which you can
query to find out whether DRILL THOURGH will suceed on that cell (it can
fail for other reasons, like security for example).

--
==================================================
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.
==================================================

Mosha,
I am aware of IS_DRILLTRHOUGH_ENABLED for the Cube (using
MDSCHEMA_CUBES)..and if I understood you correctly, you are saying
something similar is also available for a Cell...so How do I get it for
a Cell? What would be the type of query like?

Please let me know.
thanks
Anand

--
Posted via http://dbforums.com

Anand,

You are right. I was sure that there is a cell property to determine whether
or not cell can be drilled through, but it is not there.

--
==================================================
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.
==================================================

Mosha,

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.

I verified the list I got using XML/A with the list of calculated
members shown by the MS Analysis Manager and they matched.

Anand

--
Posted via http://dbforums.com

Anand,

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.

HTH,
Mosha

--
==================================================
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.
==================================================

Yes Mosha, agree with you.
It's quite a dangerous way of concluding things
Looks like there's no known method of knowing this thing.
regards
Anand

--
Posted via http://dbforums.com