Search found 219 matches

by RJ!
Fri Feb 13, 2015 4:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 46797

Re: TM1 REST API ( Any early adopters )

After many, many hours... And remebering a few things from last years TM1 Conference I finally cracked it!! All you need is Dojo and a method to insert your Username & Password as Base64. The JavaScript Code is as easy as: require([ "dojo/request" ], function (request) { request("...
by RJ!
Thu Feb 05, 2015 3:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Diagram URL
Replies: 5
Views: 4636

Re: Custom Diagram URL

I'm assuming your not talking about Cognos Insight?

Or the Metric thingys you can set up in Performance Modeler?
by RJ!
Thu Jan 29, 2015 1:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: cognostm1 cubeview export recent six months data by using ti
Replies: 12
Views: 7527

Re: cognostm1 cubeview export recent six months data by usin

IF the whole point is to find the last 6mths & add to a subset, then why not use the MDX function "Last Periods"? # Build MDX String with CurrDate Variable MyVar = Number of Periods (in OP case 6) MyDim = Your Period Dimension CurrDate = Your start month (assuming its your "cTime&...
by RJ!
Wed Jan 21, 2015 12:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 46797

Re: TM1 REST API ( Any early adopters )

I'll keep keep testing it till I can get a response I guess.
by RJ!
Tue Jan 20, 2015 10:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 46797

Re: TM1 REST API ( Any early adopters )

Hi Brain,

Sorry, should have clarified, I am using the FQDN, I just put "Localhost:Port" on forum posts.

The Tomcat install is on the same server as TM1 so wouldn't have thought that cross origin resource sharing would be an issue? Or does that also include changes in the Port number?
by RJ!
Tue Jan 20, 2015 12:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Java API for TI missing jar
Replies: 14
Views: 10874

Re: Cognos Java API for TI missing jar

Do you have a Dev server to reinstall TM1with all the options including Tomcat etc?
by RJ!
Tue Jan 20, 2015 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Java API for TI missing jar
Replies: 14
Views: 10874

Re: Cognos Java API for TI missing jar

Would if I could (IT policies are very restrictive here at my work).

Tried IBM support?
by RJ!
Tue Jan 20, 2015 12:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change dimension position from Context to Column in CAFE
Replies: 8
Views: 6853

Re: Change dimension position from Context to Column in CAFE

I'm sure we are already on the latest FP. We also have an open APAR with IBM for bugs with CAFE, might get it resolved in the next FP fingers crossed. When I get the time I'll start testing the current package again. I'm sure our security policy is causing some of the grief as CAFE can't connect/upd...
by RJ!
Tue Jan 20, 2015 6:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change dimension position from Context to Column in CAFE
Replies: 8
Views: 6853

Re: Change dimension position from Context to Column in CAFE

Not 100% sure but since we've gone to the latest version of CAFE (10.2.2) we've had nothing but trouble with it. I too am unable to create a workable Flexview either. With one of the prior 10.1 versions of CAFE I was able to do as noted by tm1ist, have not had the time to confirm if it's a problem w...
by RJ!
Tue Jan 20, 2015 2:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 46797

Re: TM1 REST API ( Any early adopters )

Hi Nick,

Yes, that is my plan...

I just need to be able to connect to the TM1 server to be able to retrieve the data.
I thought the code I provided would give me the SessionID that can then be used to used with the the REST API to retreive TM1 data?
by RJ!
Mon Jan 19, 2015 11:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Java API for TI missing jar
Replies: 14
Views: 10874

Re: Cognos Java API for TI missing jar

For our install its in these folders:
Program Files\ibm\cognos\tm1_64\bin\
Program Files\ibm\cognos\tm1_64\bin64\


Whether you can get to those folders will depending on the restrictions your IT department has set for you.
by RJ!
Sun Jan 18, 2015 11:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using EXPAND function for dynamic code
Replies: 6
Views: 6526

Re: Using EXPAND function for dynamic code

Would the JAVA extensions help in this case?

i.e. solve the "expand" in JAVA and bring it back to TI?
by RJ!
Fri Jan 16, 2015 6:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 46797

Re: TM1 REST API ( Any early adopters )

Using the code provided by IBM (inserted to the "Body" of a HTML page), below is the error I see in Chrome Developer: XMLHttpRequest cannot load http://LocalHost:Port/tm1web/dwrx/jsonp/TM1_Dev/login. No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http...
by RJ!
Fri Jan 16, 2015 5:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 on Amazon AWS
Replies: 5
Views: 5244

Re: Tm1 on Amazon AWS

Just be carefull with CAFE, we have reported a bug to IBM regarding the Log Off function not working.
We'd eventually get a REST request to the server from a "zombie" user which would lock up the service.

An APAR has been raised and fingers crossed its resolved in the next fix pack.
by RJ!
Thu Jan 15, 2015 4:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 on Amazon AWS
Replies: 5
Views: 5244

Re: Tm1 on Amazon AWS

Per what Tomok said, your pretty much restricting yourself to TM1Web + CAFE to get any decent performance out of TM1.
Perspectives & Architect can be close to unusable.
by RJ!
Thu Jan 15, 2015 4:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Defined Rollups Persistence in Excel Report
Replies: 1
Views: 1696

Re: User Defined Rollups Persistence in Excel Report

Our experiance on 10.2.2 is that they are persistant for the user that created them.
by RJ!
Sun Jan 11, 2015 11:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 46797

Re: TM1 REST API ( Any early adopters )

I was indending to set up a Login splash screen to prompt for Username & Password.

Will work on that over the next week or so.
by RJ!
Thu Jan 08, 2015 7:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 46797

Re: TM1 REST API ( Any early adopters )

Hi Guys, Is this secure? Noticed a bit of chatter on various forums in regards to being able to be "sniffed"? I'm assuming that making sure we use HTTPS would suffice? <script type="text/javascript"> function login() { var xhr = new XMLHttpRequest(); xhr.open("POST", &q...
by RJ!
Wed Dec 31, 2014 1:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process name for }ElementAttributes_}Dimensions
Replies: 1
Views: 1956

Re: Process name for }ElementAttributes_}Dimensions

Have a look in side the Dimension and have a think about what is in there and what processes / changes you can make to your model that would affect them.

Note: It won't just be TI that'd affect changes to it
by RJ!
Wed Dec 31, 2014 1:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow performance from DBRW/CellGetN vs Cube Viewer
Replies: 10
Views: 6577

Re: Slow performance from DBRW/CellGetN vs Cube Viewer

I don't think we've ever done that kind of debugging before... Will give it a go. Another topic regarding the Debugging for reference: http://www.tm1forum.com/viewtopic.php?f=3&t=9969 And another from IBM which gives some instruction to enable on the server: http://www-01.ibm.com/support/knowled...