Search found 155 matches

by Olivier
Wed Sep 30, 2015 12:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Raising negative number with fractional powers
Replies: 2
Views: 761

Re: Raising negative number with fractional powers

Hi,
You could use this kind of formula in TI to pre-calculate the results if practical.

Code: Select all

nMthlyRate = ((1+ nAnnualRate  )^( 1/12 ))-1;
I have been using it for rates conversion for example.
by Olivier
Thu Aug 27, 2015 1:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Future of TM1 UIs and APIs (Was TM1 C++ API issue)
Replies: 14
Views: 3759

Re: Future of TM1 UIs and APIs (Was TM1 C++ API issue)

Hi All, My favorite conference moment : shaking hand with Alan Kirk in real life 8-) Followed by the "trie" structure overview by Hubert. Followed by the REST API overview by Hubert. Looking forward to receive the presentation materials to redo the math around "trie" generation and get a better feel...
by Olivier
Tue Sep 02, 2014 3:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2 URL API websheet title elements
Replies: 4
Views: 2348

Re: TM1 10.2 URL API websheet title elements

Hi, Yes, URL API is back into action with an upgrade to 10.2.2. We did some basic testing and the title element selection is available since that update. (10.2.2). There is documentation available for the syntax : http://www-01.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_...
by Olivier
Mon Jul 28, 2014 5:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 10.2.2 Bug Spread C in conso crash server if weighting=0
Replies: 0
Views: 639

Tm1 10.2.2 Bug Spread C in conso crash server if weighting=0

Hi All, Just a quick note on a bug we identified in TM1 10.2.2. It relates to the spread functionality using the input of a "c" into a consolidation in order to clear the content of children cells. I have a couple of consolidation for which children have all a weight of zero. In order to take a shor...
by Olivier
Mon Jan 27, 2014 10:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2 FP1 Not Opening TM1 Web
Replies: 10
Views: 7518

Re: 10.2 FP1 Not Opening TM1 Web

Hi Jim,

Did you try to strat up TM1 application server ?
I am guessing some files might be generated form first service start ?

If that helps see below a screenshot of the Tm1Web folder content after FP1 install.
Tm1 Web folder content FP1.png
Tm1 Web folder content FP1.png (25.92 KiB) Viewed 7223 times
HTH,
Kind Regards,
by Olivier
Thu Jan 23, 2014 10:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2 FP1 Not Opening TM1 Web
Replies: 10
Views: 7518

Re: 10.2 FP1 Not Opening TM1 Web

Hi all, If the issue persists after deletion of the tomcat folder / config file. Your issue could also be related to "integrated login" and security mode ? We get a similar web log message when using security mode 2 ( mixed) and calling a view/websheet via url api with 10.2 FP1. It seems that FP1 ha...
by Olivier
Tue Dec 31, 2013 1:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2 FP1 is Now Available
Replies: 6
Views: 2916

Re: TM1 10.2 FP1 is Now Available

Hi All, I have been reading through the release notes, I could not see anything about URL API apart for previous 10.2 Web FAQs... Did anybody bump into some new information regarding URL API in 10.2 Web ? ( We are mainly interested in controlling/passing though parameters to view/reports titles sele...
by Olivier
Fri Dec 13, 2013 5:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2 Available for Download
Replies: 82
Views: 37754

Re: TM1 10.2 Available for Download

Hi All,

Was looking forward to this friday the 13th to get an hold on FP1 for Tm1 10.2 but so far nothing...
Was curious to know if anybody did have any feedback about a release date for FP1 ?
( IBM Site is advertising it for Jan 2014).

Cheers,
Olivier
by Olivier
Tue Sep 24, 2013 12:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2 Available for Download
Replies: 82
Views: 37754

Re: TM1 10.2 Available for Download

Hi All, Quick update, We did some basic test on TM1 url api and as suggested in the FAQ document, the websheet and cube views works fine but we could not get title selection parameters to work. The URL syntax is different in TM1Web 10.2. In the GA version, you are able to display both cubeviews and ...
by Olivier
Fri Sep 20, 2013 7:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2 Available for Download
Replies: 82
Views: 37754

Re: TM1 10.2 Available for Download

Hi All, Quick update, TM1 10.2 test install done but did not have a chance to get into advanced testing i.e. url api still not tested... The install was relatively straight forward. We had a challenge with port configuration due to some left over from a previous install see this documentation sectio...
by Olivier
Wed Sep 18, 2013 7:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2 Available for Download
Replies: 82
Views: 37754

Re: TM1 10.2 Available for Download

Thanks for the feedback Declanr.
I should have some more specific tests done by the end of the week on that subject...stay tuned :)
by Olivier
Tue Sep 17, 2013 11:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2 Available for Download
Replies: 82
Views: 37754

Re: TM1 10.2 Available for Download

Hi All, Thanks all for your feedbacks, and quick test Declanr :) Note : I edited my original post to avoid confusion about 10.1 ( url api is still documented there and is similar to 9.5...). I was provided with this link which details major changes with TM1 10.2 web / FAQs . http://www-01.ibm.com/su...
by Olivier
Tue Sep 17, 2013 5:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2 Available for Download
Replies: 82
Views: 37754

Re: TM1 10.2 Available for Download

Hi All, Getting started with Tm1 10.2... While going through the manuals, we noticed that the section "Developing Custom Web Applications with the URL API" does not show up in the developer guide as last seen on docs for TM1 9.5.2. http://pic.dhe.ibm.com/infocenter/ctm1/v9r5m0/index.jsp?topic=%2Fcom...
by Olivier
Thu Jul 11, 2013 5:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel workbook slow "first time" open with TM1 9.5.2
Replies: 2
Views: 1488

Re: Excel workbook slow "first time" open with TM1 9.5.2

Hi, Is the auto calculation excel option set on the file you are mentioning ? Would the file have been saved with the Auto Calc Excel option on ? If this is the case, try to save the file with the excel calculation option set to off. Else, Is one of the spreadsheet in your workbook containing an Act...
by Olivier
Wed May 29, 2013 5:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Formatting settings in TM1
Replies: 4
Views: 1253

Re: Formatting settings in TM1

I don't think this can be done in TM1 Cube views if that s what the OP had in mind. In Excel, it could be done in so many ways as Lazarus said. I would just add that If the element to format is determined by data / conditions / position in hierarchy / rules calculations, you could consider to create...
by Olivier
Tue Feb 12, 2013 10:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Error: No TM1 Databases containing TM1 Workflow data...
Replies: 5
Views: 1331

Re: TM1 Error: No TM1 Databases containing TM1 Workflow data

I am in the early days of testing TM1 10.1.1 and I have the same confusion at the moment.
( Attempted exactly the same exercise, use workflow on planning sample to have an idea of how it is operating...)

I will relook at it next friday, we could share our findings in this post...
by Olivier
Thu Dec 20, 2012 10:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewCreatebyExpression Tm1 9.4 Cognos 8.4
Replies: 5
Views: 1650

Re: ViewCreatebyExpression Tm1 9.4 Cognos 8.4

Thanks for this update whitej_d, it sounds promising.

Looking forward to an upgrade of our environment...
by Olivier
Mon Dec 10, 2012 6:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewCreatebyExpression Tm1 9.4 Cognos 8.4
Replies: 5
Views: 1650

Re: ViewCreatebyExpression Tm1 9.4 Cognos 8.4

Thanks Robin for the prompt response. The summary cube is an option we have suggesting for a while...for a range of other purposes :) I will add this point to my business case for a summary cube ;) My suspicion - based on experience - is that ViewCreateByExpression creates a server lock even when us...
by Olivier
Mon Dec 10, 2012 4:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewCreatebyExpression Tm1 9.4 Cognos 8.4
Replies: 5
Views: 1650

ViewCreatebyExpression Tm1 9.4 Cognos 8.4

Hi All, We have set up a few Cognos BI reports using Report Studio that query one of our Tm1 cubes. Our BI version is 8.4 and our Tm1 version is 9.4MR1 FP3 HF12. I noticed that every time a BI report get updated and read data from Tm1, a specific function "ViewCreatebyExpression" is be executed whic...
by Olivier
Thu Nov 15, 2012 3:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube size shows no influence of dimension elements deleted
Replies: 9
Views: 2500

Re: Cube size shows no influence of dimension elements delet

It's pretty stupid in this case, but TM1 has a bias toward speed optimization, as opposed to memory or disk consumption efficiency I am wondering if in this instance it is actually incurring a side effect on performance for calculations. Assuming we understand the way the data are flagged as not ha...