How to get KPI measure with ADOMD? RRS feed

  • Question

  • I'm trying to access the KPI metadata via ADOMD (using MDSCHEMA rowsets).  When I get the KPI Value field it, for example in Adventure Works, it returns what I believe is the hidden measure associated with the KPI (e.g., [Measures].[Net Income Value]). 

    Unfortunately I can't find this measure anywhere in the cube.  I've tried getting back the list of measure (MDSCHEMA_MEASURES) that are not visible (restriction used is MEASURE_VISIBILITY=2), but I still don't get back most of the KPI measures. 

    So how do I get those?  If you use the Adventure Works cube you can see that most of the KPI Values have MDX expressions, but I can't seem to get to them.

    Wednesday, September 30, 2009 5:25 PM