Hi:

QUOTE: "... if someone knows how to query the name of the KPI rather than hard coding it I would appreciate that very much also."

I'm not sure I understand what you mean by "rather than hard coding" it - do you mean querying the KPI directly, rather than creating a calculated member to contain the KPI, which you next query via the CM? Wouldn't something like this work (it returns the correct data from the Adventure Works AS DB)?

SELECT
{
KPIValue("Net Income"),
KPIGoal("Net Income"),
KPIStatus("Net Income"),
KPITrend("Net Income")
} ON AXIS(0),

{[Date].[Calendar].[Calendar Year].MEMBERS} ON AXIS(1)

FROM
[Adventure Works]

HTH,

Bill