Embedding a TM1 View into our Corporate Portal

[damientaylorcreata]

Hi Guys,

I am wanting to display a particular cube view embeded into our corporate portal. I have looked at doing this with EV, however I am unable to find a way of passing the login credentials to the ActiveX object.. The only other way I can see of doing this is to use the API, however this would very time consumer and a high maintenance solution.. Does anybody have any other ideas? Anyone else tried to do this?

Basically we are creating a Projects section to our portal and would like to display the related project P&L for each project selected. Therefore we need to be able to display the appropriate TM1 Cube view relating to the projects selected.

Regards,
Damien

[David Usherwood]

Suggest you look at the URL API could do what you want. Look under
Developing Custom Web Applications with the URL API
in the Developer's Guide.

[jim wood]

I'm at client were we are doing exactly that. The way we have got around it is that we integrated security. Both TM1 and EV have been integrated with Cognos BI security. While this might seem an expensive solution if you don't have Cognos BI, you might want to look at other integrated security options,

Jim.

[damientaylorcreata]

Hi David,

The TM1Web option seems like a good option! I have just tested and it works well. However I am unable to find a way to pass in particular element to the object... For example the portal needs to pass in a project number and the browser should be able to pass in the project to the project dimension and the reload the view. Do you know if there is an action for changing a dimension element selection? If not, this may not work well. However apart from that it works well and allows me to pass credentials etc.

Thanks,
Damien

[rmackenzie]

It's in the Developers Guide:

Selecting Title Elements for the Cubeviewer Object
You can set the title elements in a Cubeviewer object by adding the title parameter to your URL using the following format:

&title_DimensionName=
element
where:

DimensionName is the name of the title dimension that you want to change.

element is the string value for the name of the new title element you want to select.

If you want to select the new title element by element index, instead of element name, include the UseIndex parameter in the URL as follows:

&title_DimensionName=element&UseIndex=yes
Or
&title_DimensionName=element&UseIndex=1

[damientaylorcreata]

Perfect! Thanks guys I am happy with this solution now! Really appreciate your help on this.

[nick_leeson]

A blast from the past but I have a similar requirement and I am struggling with this, any help would be much appreciated.

This is URL string and I am using the SalesCube as an example.

http://localhost/tm1web/TM1WebMain.aspx ... seIndex=72

I can get the CubeViewer to work without any major drama's i.e. without passing the dimension I want to change the Dimension but struggling with this, the Dimension is Account and I want to be able to see EBITDA and Index of EBITDA is 72.

Its still defaulting to the original view saved.

I am on 10.1 and OS 2008 R2 .

Cheers