J
Joe
i'm trying to change colors on the pivot grid dynamically based on something
in my application. i thought it would be a simple string in the commandtext,
but i keep getting a "query could not be processed" error.
i do not use mdx in the rest of my app, i let the pivot grid talk to ssas
2005 without interference.
i'm trying the following:
mdxString = "Back_Color ([measures].[my measure]) = 255"
objPivot.CommandText = mdxString;
the final version will be an IIF statement, but i can't even get this to
work right now.
suggestions??????
in my application. i thought it would be a simple string in the commandtext,
but i keep getting a "query could not be processed" error.
i do not use mdx in the rest of my app, i let the pivot grid talk to ssas
2005 without interference.
i'm trying the following:
mdxString = "Back_Color ([measures].[my measure]) = 255"
objPivot.CommandText = mdxString;
the final version will be an IIF statement, but i can't even get this to
work right now.
suggestions??????