Search found 2136 matches

by jim wood
Tue Jan 16, 2018 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alias update and stargate view
Replies: 5
Views: 242

Re: Alias update and stargate view

I'm pretty certain that the system regards an alias change as meta change and would lock down the system. It may be taking longer as it will wait for any user activity to end before executing where as a data load (unless you're updating a dimension) will go in as a thread and will not halt user acti...
by jim wood
Wed Jan 10, 2018 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 333

Re: Poll : Which version of Excel is used in your business

tomok wrote:
Wed Jan 10, 2018 11:57 am
Alan Kirk wrote:
Tue Jan 09, 2018 8:20 pm
I addressed this on my YouTube channel last week.
I'd love to watch your shows/webisodes/whatever they're called. Not just to learn more about this topic but also to see if you really do look just like Mark Harmon.
Right hair colour
by jim wood
Tue Jan 09, 2018 8:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 333

Re: Poll : Which version of Excel is used in your business

Just to throw a spanner in the works I use Office 2011 on my mac :oops:
by jim wood
Fri Dec 22, 2017 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Date Validation
Replies: 1
Views: 347

Re: Date Validation

Make sure the date fields are numeric. The format them as dates. That way it shouldn't take anything else,

Jim.
by jim wood
Wed Dec 06, 2017 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Workflow
Replies: 10
Views: 528

Re: Custom Workflow

I would:

1) Create a test service (Containing copy of production)
2) Connect Application web to the test service
3) Open PM and create an application using whatever hierarchy option you want
4) See how the web forms come through from the application folders etc
5) Decide if this is a good fit

Jim.
by jim wood
Wed Dec 06, 2017 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Workflow
Replies: 10
Views: 528

Re: Custom Workflow

You only need to use PM to setup the hierarchy, security and which forms are used for data entry etc. It shouldn't screw anything up as it won't deploy any rules or anything like that.
by jim wood
Mon Nov 13, 2017 4:23 pm
Forum: Useful code, tips and tricks
Topic: Inspecting views
Replies: 3
Views: 469

Re: Inspecting views

Thanks Wim. Will be very handy for anybody inheriting a system that has (how should I say) evolved over time.
by jim wood
Thu Nov 02, 2017 12:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Subsets & BI
Replies: 2
Views: 177

Re: MDX Subsets & BI

Thanks for getting back to Mac. As it turns out the issue was with a filter rather than a subset coming through in BI but thanks your reply,

Jim.
by jim wood
Wed Nov 01, 2017 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unusual Problems with Text Files in TI Processes
Replies: 3
Views: 206

Re: Unusual Problems with Text Files in TI Processes

Are there any free form text fields within the Data? If there are, within this field there may carriage returns or ". If there are if would throw everything off.
by jim wood
Wed Nov 01, 2017 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Subsets & BI
Replies: 2
Views: 177

MDX Subsets & BI

Guys,

We are seeing different numbers of elements in subsets in BI than in architect. Does BI run with the last subset size or does it refresh the subset?

Jim.
by jim wood
Wed Nov 01, 2017 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 process in chore starts with 2 min delay
Replies: 2
Views: 162

Re: TM1 process in chore starts with 2 min delay

Are there any other chores running at the time? Are there any meta updates happening? Have you checked top (or whatever the modern fangled thingie is) when it is happening to see if anything else is running?
by jim wood
Fri Oct 27, 2017 5:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Workflow
Replies: 10
Views: 528

Re: Custom Workflow

This is food and drink for most experienced consultants. One issue is they'd need to have more information. Most custom workflow builds are just that, custom, and can change depending on the circumstances. Also keep in mind, this is the day job for most consultants, and while we understand that you ...
by jim wood
Fri Oct 20, 2017 2:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension update result in element loss
Replies: 6
Views: 232

Re: Dimension update result in element loss

Instead of having hard coded rule like that, create a lookup cube or an alias and have the rule looking at it, so something like: ['Method'] = S: IF(CapIt(AttrS('Accounts',!Accounts,'Flag'))@='Y' ,'N/A' ,Continue ); That way the rule will not fail even if it is removed. It also takes away the proble...
by jim wood
Fri Oct 20, 2017 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension update result in element loss
Replies: 6
Views: 232

Re: Dimension update result in element loss

Orlando,

That just can't be it as the process issue would have arisen earlier. You need to keep in mind when the delete all is committed. My guess would be that one of the rule accounts has actually been removed from the chart accounts. May be it's being recycled?

Jim.
by jim wood
Thu Oct 19, 2017 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension update result in element loss
Replies: 6
Views: 232

Re: Dimension update result in element loss

Does the process do a complete rebuild? If it does my guess would be that an account hard coded in to a rule is being removed. But without knowing the rule / process detail it's very difficult to say for certain.
by jim wood
Thu Oct 12, 2017 4:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: replace a subset value in db function
Replies: 4
Views: 269

Re: replace a subset value in db function

I always lean towards a lookup cube as it can be used within multiple cubes if you don't have a shared time dimension or even multiple time dimensions within the same cube.
by jim wood
Tue Oct 10, 2017 11:49 am
Forum: Useful code, tips and tricks
Topic: TM1 Tip - Parallel Processing with tm1runti
Replies: 1
Views: 250

Re: TM1 Tip - Parallel Processing with tm1runti

Moved this post to useful code, tips and tricks as it will be easily visible for longer.
by jim wood
Fri Sep 29, 2017 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW server hardware requirement
Replies: 6
Views: 396

Re: PAW server hardware requirement

16GB of RAM / 8 cores is recommended. For 100 users that should be fine. Most of the heavy lifting is done by TM1 so RAM usage is pretty stable. That's a very glib statement. Some rule heavy models with less users can take a crap load more memory than 16GB. I have 16GB in my desktop at home for gam...