TM1 Forum

To start with Java Extensions - https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_turb.2.0.0.doc/c_ti_java_support_in_turbointegrator.html To start with POI - https://poi.apache.org/ You have to use Eclipse Java EE IDE as developer tool for this task With POI you ...

Why don't you look to the TI Java Extension and POI side. These both can help you to generate Excel reports directly from TI without involving your OS and its troubles. To do that you have to investigte POI and TI Java Extension (and java).

No one has idea

yes, I have no private objects in my model.

Thank you for your discussion. I can add more... I can't select this (dynamic) subset for the cube view in PM. I did it in architect only successfuly. And only after that i tried to open this cube view in PM and Cognos Insight. In architect all works fine, but I can't see the same result in PM. This...

...there is no scope to code MDX in creating a Subset in Performance Modeller.

In Performance Modeller I can cteate Subsets based on MDX expressions. And there is interface to create such subsets.

I have IBM Cognos TM1 10.1.1 (fp1). I made cube view with subset based on MDX expression. This expression consist of the filter based on the value of other dimension (measure) of this cube. In the Architect and TM1Web all works fine. But when I try use this cube view in Performance Modeler or Cognos...

Thank you for your replay.
BUT... what about the API libs in client distributive?.
I don't know now what should I require from my customers, who try to use my tools developed on TM1 API?
In past I have required to install TM1 client and set the path to the libs.

1) When you install the client version 10.1, I can not find the libraries. Net api. Also in the server side, I now can not find any documentation .Net api. 2) someone could give an example of API .Net to connect to a server in CAM SSO mode? In particular: how to get the CAM _Passport string? If ther...

lotsaram, thank you for your reply! The goal which is solving by this rule is universal calculation of averages. If in the dimension exists element which has two the same elements starting with '}1' and '}2' this element must be consolidated as avarage. And it doesn't matter how many such elements e...

Could anybody help me to create feeders for the following rule?: []=N:IF(SUBST(!Dim_El,1,1)@='}', IF(SUBST(!Dim_El,2,1)@='1', IF(DB('Cube_el',!Months,SUBST(!Dim_El,3, LONG(!Dim_El)-2))<>0,1,0), DB('Cube_el',!Months,SUBST(!Dim_El,3, LONG(!Dim_El)-2))), continue); C:IF(DIMIX('Dim_El','}1'|!Dim_El)>0, ...

My experience shows me, that Cognos Configuration settings don`t help me to avoid this error. The decision, which really helps to avoid this error is installing client side software of TM1 on the server, where the Framework Manager have been already installed.

what should we modify concretely in FM Cognos Configuration to point to the TM1 server?

Well, the empty process has been created. But...
Would you put some code to add some code to this empty process?

What about ODBO connection to this view from TI process?

What should i do to provide the opportunity of my users to create comments and attachments for any cell in TM1 Contributor's cube view, as in EP?
I understand, that it is not base functionality of this product.

It is actual for tabs (Prolog, Metadata, Data, Epilog) of TI, But if i should create variable with formula?

If you have definite logic of client's assignments to the TM1 Contributor you can create TI process, that will change client's security assignments or create rule in control cubes.

lotsaram wrote:...The best you could do to programatically launch a "cube view" would be to use the ISB control.

Can you tell me more about it or give me the way to investigate this topic?

I want to display cube data with cube viewer interface of reach client (not architect, but Perspectives), but i don't want USE the data of the cube for placing it on the Excel sheet. I need functionality to directly open the cube viewer with definite cube view without using navigation of Server Expl...