Executive Viewer changing Offspread members via URL API

[stuartbarnes27]

I am trying to open Executive Viewer reports from a TM1 Web sheet and dynamically pass the dimension selections from the websheet to change the Offspread selections (page headers) in the Executive Viewer report.

There is no useable documentation supplied by IBM but when I contacted them they gave me the following syntax to try:

http://server/EVServer?ToolBar=true&Tab ... tem=test&R
enderType=Xml&Xslt=SetOffspreadContext.xslt&OffspreadMembers=plan_report
:actual

With some work I was able to get this to work and it allowed me to switch one of the Offspread members, but after repeated attempts to contact IBM they are not able to provide any actual documentation or provide me the syntax to switch more than one Offspread member.

Ideally I would like to be able to switch year, month and possibly a couple of more dimensions but I just can't seem to figure it out, perhaps its a limitation.

Any ideas?

[jim wood]

Have you checked the EV Users forum: http://www.evusers.org

I was doing something like this a while ago but I can't remember how I did it. (Sorry)

I do however remember finding help with it on the EV forum. You'll need to register and it may take a small amount of time for them to set you up.

[stuartbarnes27]

I eventually dug around in the SetOffspreadContext.xslt file and found the following lines:

<!-- Split the Offspread Dimension and Member pairs which are seperated by a '|' -->
<!-- The Dimension and Member are seperated by a ':' -->

It appears that it does work:

OffspreadMembers=ITAM_Year:2012|ITAM_Month:Jun

IBM did eventually come back with the following link to documentation, but it made no mention of the above syntax.

http://pic.dhe.ibm.com/infocenter/cev/v ... _ev_9.html

[jim wood]

Good to know. Did you sign up for the EV forum. It's a pretty good resource once you're in.