Search found 219 matches

by RJ!
Tue May 31, 2016 2:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAFE Report Design Tips
Replies: 0
Views: 1286

CAFE Report Design Tips

I was playing with CAFE the other day and noticed this: Say you have a list of Elements that you want in your report but are not in the order that you want them displayed in, you can select these Elements individually & then use the "Keep" (Right Click>Cognos Analysis>Keep) to rearrang...
by RJ!
Tue May 31, 2016 2:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Slices vs. Active Forms vs. Spreadsheet Browser
Replies: 8
Views: 6812

Re: Dynamic Slices vs. Active Forms vs. Spreadsheet Browser

I've already pointed out that Drill to Transactions is a big missing feature at the moment for us, otherwise our set up is so basic that CAFE & Perspectives are much of a muchness in terms of what you can do. The Boss likes TM1 formulas for DBRA to pull extra info when creating reports (i.e. Lon...
by RJ!
Fri May 27, 2016 4:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Slices vs. Active Forms vs. Spreadsheet Browser
Replies: 8
Views: 6812

Re: Dynamic Slices vs. Active Forms vs. Spreadsheet Browser

Hopefully you also have access to CAFE (Cognos Analysis for Excel) as well to experiment with as that will be what is replacing the above at some stage...
by RJ!
Tue May 17, 2016 3:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API based Webpages on VMWare
Replies: 2
Views: 2112

Re: REST API based Webpages on VMWare

We wanted REST API as it's a sneaky way to get a complete Web App up & running without IT getting too nosy & push us off to more expensive Tech to host it (i.e Webshere/Weblogic + the servers to run them on).
by RJ!
Thu May 12, 2016 1:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API based Webpages on VMWare
Replies: 2
Views: 2112

REST API based Webpages on VMWare

Hi All, We have been "requested" to move our Local (Physical) TM1 Environment from Australia to a VMware farm in North America. At some stage, we'd like to develop some web pages that leverage the REST API and interact with TM1. I'm not particularly familiar with VMware, is there anything ...
by RJ!
Tue Apr 26, 2016 10:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to cancel a thread that cannot be cancelled in TM1 Top
Replies: 25
Views: 21419

Re: How to cancel a thread that cannot be cancelled in TM1 Top

Hmmm... I wonder if this would also clean out those pesky duplicate REST calls from CAFE Users that tend to lock up TM1.
by RJ!
Mon Apr 18, 2016 7:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Execute Powershell Script from TI
Replies: 6
Views: 8804

Re: Execute Powershell Script from TI

We had access to run scripts on our Servers using the TM1 but our IT boffins decided to turn something off so that only proper User ID's can run script, not system ID's.
Might be worth checking if the server admin is managed by another team.
by RJ!
Mon Mar 07, 2016 11:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP5 available
Replies: 8
Views: 5579

Re: TM1 10.2.2 FP5 available

IBM Cognos TM1 10.2.2 Fix Pack 5 release notes wrote:The list of known Cognos TM1 issues that were addressed in this release
Are they suggesting that there are "Unknown" issues being addressed as well?
by RJ!
Fri Feb 26, 2016 7:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAFE - User Authentication - ALWAYS need to be ADMIN??
Replies: 4
Views: 3732

Re: CAFE - User Authentication - ALWAYS need to be ADMIN??

Just confirming that users are able to connect to Perspectives or Architect without issues?

None of our CAFE Test/UAT users required Admin.

Are they able to login with User Name & Password if you change to Security Mode 1?
by RJ!
Sun Jan 17, 2016 10:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Thru Cube - DB Transactions - Invoice
Replies: 5
Views: 3953

Re: Drill Thru Cube - DB Transactions - Invoice

Realised that after reading the OP again, though he did ask for other options...
by RJ!
Thu Jan 14, 2016 6:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Thru Cube - DB Transactions - Invoice
Replies: 5
Views: 3953

Re: Drill Thru Cube - DB Transactions - Invoice

Are users randomly looking for Invoices while exploring the cube or are they likely to be looking for something specific when they go into the Cube? If it's something specific, we have something set up where the user will use ISB (InSpreadsheet Browser) to open a preset View and we have a VBA code t...
by RJ!
Wed Dec 16, 2015 4:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.3 - IBM Planning Analytics
Replies: 40
Views: 37294

Re: TM1 10.3 - IBM Planning Analytics

Sorry to burst your bubble but I just looked again at the presentation from Insight and the message on smart caching was that it was a really difficult problem to solve, work is still in progress, but it apparently won't be in the next version. I wouldn't be surprised if it's there as a parameter t...
by RJ!
Tue Dec 15, 2015 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: how to restrict user input using macros in Excelladdin
Replies: 10
Views: 5522

Re: how to restrict user input using macros in Excelladdin

HI Team , i want restrict user input negative value into excel template using macros . If I'm reading that right, I think you need to have code against an "On Change" procedure in your Excel Template that monitors the cells your looking at... Though if it was me, I'd just use Data Validat...
by RJ!
Tue Dec 15, 2015 5:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.3 - IBM Planning Analytics
Replies: 40
Views: 37294

Re: TM1 10.3 - IBM Planning Analytics

Still no drill to transactions in CAFE...
by RJ!
Thu Nov 26, 2015 3:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAFE (10.2.2) with TM1 Formula issues
Replies: 5
Views: 4060

Re: CAFE (10.2.2) with TM1 Formula issues

kangkc wrote:I think if you have tones of workbooks with DB formula to convert. This will be the last thing we have in mind. Thanks anyway.
If you convert to a FlexView, you'd only need to copy-paste to replicate the workbook form...
Though if more than 10-20 workbooks, would be quite tedious!
by RJ!
Wed Nov 25, 2015 11:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAFE (10.2.2) with TM1 Formula issues
Replies: 5
Views: 4060

Re: CAFE (10.2.2) with TM1 Formula issues

For Point 1, why not use CAFE's native write back and use the submit button?

I'm not really seeing the need for DBRW formula other than to get stuborn DBRA functions to work.
by RJ!
Wed Oct 28, 2015 6:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAFE with TM1 Formulas
Replies: 5
Views: 4199

Re: CAFE with TM1 Formulas

My understanding is that Perspectives will be binned so I can only see IBM working on a solution where CAFE can do the formula calc's or provide an alternative Drag & Drop option (most likely from the way their UI is going). Will likely be in the next release mid next year (fingers crossed). If ...
by RJ!
Thu Oct 22, 2015 12:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAFE with TM1 Formulas
Replies: 5
Views: 4199

CAFE with TM1 Formulas

Hi All, Has anyone else been experiencing CAFE prompting you to log in a 2nd time if you want to use Perspective's formulas? It seems that IBM have almost resolved the "Zombie" threads when using CAFE (was a half-@ss fix in FP3, and a little better in FP4), we still get these Zombie thread...
by RJ!
Thu Oct 08, 2015 9:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web causing increase usage of RAM?
Replies: 3
Views: 2820

Re: TM1Web causing increase usage of RAM?

Had not see that link, will get our IT Support to confirm the settings & update the thread. FYI - We don't use Web sheets or active forms etc. TM1 Web has been used as a stop gap for our regional colleagues to use in a similar manner as Perspectives in that they can explore & "Snapshot/...
by RJ!
Wed Oct 07, 2015 1:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web causing increase usage of RAM?
Replies: 3
Views: 2820

TM1Web causing increase usage of RAM?

Hi All, Has anyone else experienced TM1Web causing increases in RAM usage? Our IT guys have raised this as a possibility for our latest growth spurt on RAM... I personally think it's more likely to be from the latest Plan/Forecast cycle but just want to double check. NOTE that we have already increa...