Search found 2163 matches

by jim wood
Fri Jun 22, 2018 5:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Oracle ODBC set to Cognos TM1
Replies: 2
Views: 83

Re: Oracle ODBC set to Cognos TM1

Moved to the correct forum
by jim wood
Tue Jun 05, 2018 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Usage of more Memory each time a Process is used
Replies: 3
Views: 162

Re: TM1 Usage of more Memory each time a Process is used

Hello there, Points about this are spread across this board but difficult to find. Basically TM1 caches values for users to come back to. Theory being that if you cache the value rather than calculate it every time you get better performance. When a data change comes in however, TM1 no longer uses t...
by jim wood
Wed May 30, 2018 12:31 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: 14
Views: 1444

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

So please Tomok don't just point fingers and throw mud, any old hack can do that. I just did it above, it's not nice and it achieves nothing. As you'll have heard many times, if you don't have anything good to say, don't say it. [hack in]Wow! I'm sorry that I made you feel it necessary to raise the...
by jim wood
Tue May 29, 2018 11:49 am
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: 14
Views: 1444

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

My point is that IBM's request for the model and data is valid. If you choose not to share it with them then you forfeit your right to whine about them not being able to help you with a randomly occurring issue. If only everything was that black and white. The day you're stuck on a client that does...
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: 14
Views: 1444

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: 6
Views: 431

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: 262

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: 262

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: 470

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: 340

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: 863

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: 6476

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: 908

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: 445

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: 445

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: 445

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: 518

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: 518

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.