Search found 459 matches

by mattgoff
Tue Jun 21, 2016 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 instance doesn't show up in Perspectives list
Replies: 16
Views: 9274

Re: TM1 instance doesn't show up in Perspectives list

Also, make sure all TM1 servers have unique ports.
by mattgoff
Tue Jun 14, 2016 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple-domain Login
Replies: 3
Views: 3782

Re: Multiple-domain Login

May I know your TM1 version, and what kind of file encoded wrongly? :?: Various revisions of 10.2. I don't recall the exact file, but it was one of the ones you have to edit to set up Kerberos integrated login for TM1 Web. Note that the failure mode of this issue was that integrated login on TM1 We...
by mattgoff
Wed Jun 08, 2016 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple-domain Login
Replies: 3
Views: 3782

Re: Multiple-domain Login

We use multi-domains successfully, so I can confirm it's possible. My advice would be to open a ticket with IBM on this one. Kerberos logging can be difficult to trace. I had an issue with Kerberos integrated login on TM1 Web and it took over a year and a dozen meetings w/ IBM before we finally foun...
by mattgoff
Tue May 03, 2016 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Conversion to US Dollar issue
Replies: 3
Views: 3016

Re: Conversion to US Dollar issue

Since you seem to be using static currency scenarios where FX rates don't change in time This jumped out for me too, and I'm concerned that it's a flaw/oversight in the database design. Chuks, are you sure that you want to use one rate for all periods? I also don't see a version dim, so if that exi...
by mattgoff
Thu Mar 17, 2016 5:46 pm
Forum: Enhancements
Topic: RFE 85099: Toggle for Read-Only Mode in Perspectives
Replies: 7
Views: 21335

Re: RFE 85099: Toggle for Read-Only Mode in Perspectives

I'm not sure I agree. It sounds like you're saying "DBS is simple and works great except for this one usability flaw... so don't use DBSes." Why not fix the usability flaw? Although the majority of my users are Excel wizards, AFAIK none use VBA. Anything involving TI means a TM1 admin has ...
by mattgoff
Mon Mar 14, 2016 6:47 pm
Forum: Enhancements
Topic: RFE 85099: Toggle for Read-Only Mode in Perspectives
Replies: 7
Views: 21335

Re: RFE 85099: Toggle for Read-Only Mode in Perspectives

I agree, an "upload/activate DBSes for session" button would be a better solution, particularly because it eliminates the need to the user to remember to disable upload in advance.
by mattgoff
Mon Mar 14, 2016 5:56 pm
Forum: Enhancements
Topic: RFE 85099: Toggle for Read-Only Mode in Perspectives
Replies: 7
Views: 21335

Re: RFE 85099: Toggle for Read-Only Mode in Perspectives

Would you not be better off removing the reliance on users to a custodian and have this built in to your scenario control? You could rather build cell security rules to add this layer - overall read-only, group read-only etc. This way the model is read-only where and when it needs to be? Also, the ...
by mattgoff
Thu Mar 10, 2016 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consol in feeders
Replies: 7
Views: 3337

Re: Consol in feeders

Yes, please no pseudocode. This post is a perfect example why (since it's impossible): a = b - c c = d + e e = a * z a = b - (d + e) a = b - (d + a * z) <--- nope (while algebraically solvable, not TM1 solvable) Following the Request for Assistance Guidelines will allow us to spend time looking at y...
by mattgoff
Wed Mar 09, 2016 4:35 pm
Forum: Enhancements
Topic: RFE 85099: Toggle for Read-Only Mode in Perspectives
Replies: 7
Views: 21335

RFE 85099: Toggle for Read-Only Mode in Perspectives

http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=85099 It's not uncommon for users to make inadvertent changes to data in TM1, particularly if they're making use of the DBS statement. Best method is to enclose DBS in an IF statement, but even if this is done (it often is not)...
by mattgoff
Wed Mar 09, 2016 4:33 pm
Forum: Enhancements
Topic: RFE 85102: Change "No values available" to non-modal notification
Replies: 4
Views: 18447

RFE 85102: Change "No values available" to non-modal notification

http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=85102 When browsing data in the cube viewer, if the selected elements/subsets to not return any data TM1 presents a modal dialog box with the message "No values available." Since it is modal, the user must dismiss the...
by mattgoff
Fri Feb 05, 2016 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Rule applies to cell
Replies: 11
Views: 6444

Re: Error Rule applies to cell

We can't really help you with the info you've provided. Please read the Request for Assistance Guidelines . To provide any meaningful help, we'll need cube/dim structure and copy of the exact code that's giving you the error. Screenshots of the cubeview showing the cell writeable would help us confi...
by mattgoff
Thu Feb 04, 2016 6:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Rule applies to cell
Replies: 11
Views: 6444

Re: Error Rule applies to cell

The most common reason for this is as qml states, but I have an open PMR with IBM on this occuring on cells which I know are not rule targets. Further, it doesn't happen every time, i.e. repeated runs of the process may or may not generate the error, and even the affected cells change. Unfortunately...
by mattgoff
Tue Feb 02, 2016 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parameter of sub process not passing through
Replies: 10
Views: 4923

Re: Parameter of sub process not passing through

Is "Year" really your param name or is that a placeholder for this post? If the former, "Year" is a reserved word, and you get a modal error if you attempt to use it for a variable name. I would have expected your code to be:

Code: Select all

ExecuteProcess('SubPro','pYear',pYear);
by mattgoff
Wed Dec 23, 2015 6:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Performance awful reading and writing within same cube
Replies: 9
Views: 5016

Re: TI Performance awful reading and writing within same cube

It is funny how TI seems to rule the roost these days. When it comes to allocations my first stop is always rules. Really? My first thought when I'm planning a rule is "do I really need to have this real time" and, if not, move it to TI instead. For us, allocations are very much a non-rea...
by mattgoff
Mon Nov 30, 2015 5:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recover }ClientGroups cube
Replies: 6
Views: 3492

Re: Recover }ClientGroups cube

Assuming you have filesystem access: Create a .rux file to map one user to admin. Restart server. Log in to account which now has admin access. Add admin access to second user. Log out first user. Log in via second user, delete rulefile, grant access to first user (and whomever else). If you shutdow...
by mattgoff
Sun Nov 22, 2015 9:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rep and Sync
Replies: 5
Views: 4761

Re: TM1 Rep and Sync

We're using it successfully and have been since 9.5.1 and now on 10.2.2 FP2. [...] Only issues we have are with users using wifi to enter data. We think we're getting micro-drops on the wifi networks and somehow stuff gets missed out of logs. The only gaps we've ever seen are consistent with this a...
by mattgoff
Wed Oct 28, 2015 11:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating new cube using existing dimensions but cannot see data
Replies: 19
Views: 7961

Re: Creating new cube using existing dimensions but cannot see data

Apologies I have reposted this in another post as replies to this one have stopped. Well, everyone here answering questions is volunteering their time, span across timezones, and have a lot of their own work and problems to solve. You can't rely on this forum for instant answers. But in essence, as...
by mattgoff
Tue Oct 27, 2015 12:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating new cube using existing dimensions but cannot see data
Replies: 19
Views: 7961

Re: Creating new cube using existing dimensions but cannot see data

So for the new cube I have just copied the rule file from the old cube in the hopes that they will just work in the same way they did in the old cube. That's not going to work (at least not in the way you think it will). Plus, you need to add feeders (hint: those are in rules for other cubes). If y...
by mattgoff
Tue Oct 27, 2015 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating new cube using existing dimensions but cannot see data
Replies: 19
Views: 7961

Re: Creating new cube using existing dimensions but cannot see data

The new cube has the same exact rules as the old cube. In the old cube data was pulled from other cubes, so it is just the same rules that pull the data from those cubes. Initially I want the cube to just be like the old one with the new versions dimension. In versions there are actuals, then a for...
by mattgoff
Wed Oct 07, 2015 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 integrated Login Kerberos
Replies: 4
Views: 4063

Re: TM1 10.2.2 integrated Login Kerberos

it seems that i fixed issue. no exception anymore. But despite I still have a "login failed, please try again" message I have an open PMR (73855,49R,000) with IBM on exactly this problem (and have since December 2014). Support just scheduled a meeting for Oct 30 (!!!) with someone I assum...