Search found 2165 matches

by jim wood
Mon Jul 16, 2018 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drop Down Calendar Selection
Replies: 18
Views: 5919

Re: Drop Down Calendar Selection

BTW A pick list isn't just a single list. If you do create a pick list cube (or not) you can link the lists via rules for say Day, Month and year to only show the values as they apply, so you can set month to null if no year is selected, then set day to null if no month and then change the values di...
by jim wood
Fri Jun 29, 2018 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web does not show any TM1 Service
Replies: 6
Views: 184

Re: TM1 Web does not show any TM1 Service

Have you set the admin host in web?
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: 148

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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...