Search found 2159 matches

by jim wood
Fri May 25, 2018 4:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 10
Views: 886

Re: Server Locked after save data process and save data is running for a long time .

IBM refuses to do anything more unless we hand over our entire model and data, which we do not do. Why would you not? "Hand over" is probably not good wording. You do know that their license agreement with you precludes them from disclosing any of your data, anywhere, for any reason? I guess your m...
by jim wood
Thu May 24, 2018 5:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Warning - read only users
Replies: 1
Views: 111

Re: Warning - read only users

Good to know. Thanks Wim,

Jim.
by jim wood
Wed May 23, 2018 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation advice
Replies: 3
Views: 148

Re: Consolidation advice

May be add a measure called % split and calculate at the consolidated level?
by jim wood
Wed May 23, 2018 11:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation advice
Replies: 3
Views: 148

Re: Consolidation advice

This sounds more like an allocation rather than a consolidation. Like all allocations you to agree a method with those in finance. For costs you normally allocate the likes employee costs via FTE.
by jim wood
Tue May 08, 2018 9:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Statement Failed
Replies: 12
Views: 348

Re: SQL Statement Failed

Does the user you are using to connect to the DB via ODBC have access to the table? Keep in mind that when you run it in Studio you will be running it as you,

Jim.
by jim wood
Fri May 04, 2018 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Stuck on Zero Out
Replies: 4
Views: 243

Re: Process Stuck on Zero Out

Note sure if it is getting unhappy here: SUBSETELEMENTINSERT(dimIndex, subRef, strLoopEle, SUBSETGETSIZE(dimIndex, subRef) + 1); may be worthwhile trying: SUBSETELEMENTINSERT(dimIndex, subRef, strLoopEle, 0); If memory serves, I remember the 0 index adds to the end but you will need to test. Failin...
by jim wood
Mon Mar 12, 2018 6:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI Processing Time
Replies: 8
Views: 777

Re: Improve TI Processing Time

Based on what you've said the main culprit is either under performing feeders or just a plain old overly complicated rule on either side. But saying that there are other variables like users entering data, etc that could explain the reasons for this. Without doing an investigation it'd be difficult ...
by jim wood
Fri Mar 09, 2018 6:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tool to detect overfeeding?
Replies: 16
Views: 6286

Re: Tool to detect overfeeding?

It's not necessarily reversing your rule, it could also be that 1 element feeds several other elements, even if that one element does not occur in the rule. Very true. The example I always give for this is product margin. Sales units is the drive of sales, but it's also the driver of Margin, you do...
by jim wood
Thu Feb 22, 2018 12:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Chore Schedule Information
Replies: 10
Views: 832

Re: TM1 Chore Schedule Information

Moved to correct forum
by jim wood
Wed Feb 21, 2018 8:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add CAM Users
Replies: 5
Views: 381

Re: Add CAM Users

Thanks Declan. When I go in I get 2 options: Active Directory or Cognos. Cognos only contains groups where as all users in active directory. That's where the fun begins, the client I'm at has literally thousands of employees and they never remove anybody from AD. It's like trying find a needle in a ...
by jim wood
Wed Feb 21, 2018 12:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add CAM Users
Replies: 5
Views: 381

Re: Add CAM Users

macsir wrote:
Tue Feb 20, 2018 9:48 pm
I don't quite get it. Can't you add users through Clients/Groups interface?
Local user yes, CAM users no. We can add CAM groups, but when we go in to add user we only get the groups still rather than individual users.
by jim wood
Tue Feb 20, 2018 8:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add CAM Users
Replies: 5
Views: 381

Add CAM Users

Guys, I have a quick gander at the web and I can't find anything easily. Is there a way to manually add a CAM user before they have logged on? Normally they appear upon their first logon attempt. I wondered if just inserting a client including the namespace would work but of course that is just an a...
by jim wood
Mon Feb 12, 2018 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: General Data Protection Regulation (GDPR) and TM1
Replies: 5
Views: 476

Re: General Data Protection Regulation (GDPR) and TM1

I've not come across this myself (been onsite for the last 4 years) but other guys working for IBM partners may have come across it. I guess we'll see....
by jim wood
Fri Feb 09, 2018 12:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: General Data Protection Regulation (GDPR) and TM1
Replies: 5
Views: 476

Re: General Data Protection Regulation (GDPR) and TM1

I asked as this is a specific questions which would normally be asked at the point of purchase, usually answered by the vendor.
by jim wood
Thu Feb 08, 2018 3:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: General Data Protection Regulation (GDPR) and TM1
Replies: 5
Views: 476

Re: General Data Protection Regulation (GDPR) and TM1

Have you asked IBM? Also moved to correct forum.
by jim wood
Mon Jan 29, 2018 8:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Set Up in Cognos Administration update TM1 User Group
Replies: 3
Views: 316

Re: User Set Up in Cognos Administration update TM1 User Group

You need to manually add any new groups to TM1. Their group status is not then reflected until the logon when the link for the user is refreshed,

Jim.
by jim wood
Thu Jan 25, 2018 8:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Set ODBO Datasource in Prolog
Replies: 10
Views: 1583

Re: Set ODBO Datasource in Prolog

Taxi for me. Sussed it. I had my override code below the query generated code in the prolog. Thanks for all your help PowerDim,

Jim.
by jim wood
Thu Jan 25, 2018 6:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Set ODBO Datasource in Prolog
Replies: 10
Views: 1583

Re: Set ODBO Datasource in Prolog

I tried to simplify the query:

Code: Select all

DatasourceQuery = 
'SELECT NON EMPTY
  { [OnBoarding - Projects].[?pProject?] } * { [OnBoarding - Version].[Forecast] } * { TM1SUBSETALL( [OnBoarding - Attribute Measures] ) }
ON COLUMNS
FROM [OnBoarding Attributes]';
But still not working