TM1 Forum

Hey everyone,

I've got a question regarding opening the cubeviewer from a websheet with an URL.

http://<server>/TM1Web/TM1WebMain.aspx?action=OpenObject&type=Cubeviewer&value=Spartenergebnis$$Kosten$$PUBLIC&title_Kostenarten=700

This is the URL i am using right now. It opens the cubeviewer without any problems, but does not set the title dimension "Kostenart" to the element 700. Title Dimension means context, right? Or does it refer to columns or rows? if it does refer to columns or rows, what is the command to set the context dimensions? Are there any undocumented features? What about alias names? does the parameter passed by title_dimensionname has to match the actual alias chosen in the view?

I want not to only so set this dimension, but also year, month, etc. I intend to use the HYPERLINK() formula of Excel in combination with a DBRW as the Linktext.

Thanks in advance,
Roger

The TM1 Web URL is case sensitive (and the documentation examples in the developer guide as I recall aren't always 100% correct.) Try
$$PUBLIC&Title_Kostenarten=700

OK, this works, many thanks!

Do you know any method to control the column and row dimensions of a cube view?

As far as I am aware the web URL API only allows for specific setting of a title element by member name or index (this at least is better than TI which only allows for title index and not by name.)

To change row or column elements you have to change the view object itself by changing the subsets that are assigned to the row and column dimensions. The user can do this themselves once they arrive at the view but you can't do it for them in the URL of the hyperlink. Depending on the user's group membership and element security there may be other ways to control which elements they see but fundamentally if you need to "swap" row or column members based on context then you will need to have per-built views for each case I think.