Search found 1392 matches

by Steve Rowe
Thu Jan 11, 2018 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cumulative balance in TI or Rule
Replies: 3
Views: 478

Re: Cumulative balance in TI or Rule

For the TI a lot will depend on how your data arrives and if you only do single day at a time and it arrives in time order. If you can be sure you are processing daily data in day order then your TI can just take todays total, yesterdays cumulative, sum them and add it to todays cumulative. For me t...
by Steve Rowe
Wed Jan 10, 2018 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cumulative balance in TI or Rule
Replies: 3
Views: 478

Re: Cumulative balance in TI or Rule

Several ways come to mind. Have a cumulative day consolidation in your dimension, this could be built in a straight forward way with a TI. Your cumulative HO measure could then reference this in a rule. [Cumulative HO] = N: DB ( ......'Daily HO' , !Day | 'Cumulative'....); i.e. !Day | ' Cumulative' ...
by Steve Rowe
Tue Jan 09, 2018 11:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 929

Poll : Which version of Excel is used in your business

It would appear that IBM are withdrawing support of Excel 2010 for both Perspectives and PAx in the Planning Analytics release as from 1st of March 2018. I don't think this has been announced anywhere but it can seen as a footnote in the prerequisites section of the Software Product Compatibility Re...
by Steve Rowe
Wed Jan 03, 2018 6:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX - Does it have rules tracer?
Replies: 5
Views: 590

Re: PAX - Does it have rules tracer?

You should consider that this forum is not run by IBM and both the OP and macsir should take care with blanket statements like that made above. There are a lot of assumptions in the previous statement, starting with "IBM consider the rule tracer to be developer only functionality", the above post is...
by Steve Rowe
Tue Jan 02, 2018 2:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reset views and tabs in TM1 applications web
Replies: 11
Views: 1222

Re: How to reset views and tabs in TM1 applications web

Hi, I think I missed the point... You are talking about a users "view" of the published public View object which the TM1 Application functionality is remembering so that when they log back in they are in the same place as when they left. Not something I have ever tried to interfere with so not sure ...
by Steve Rowe
Tue Jan 02, 2018 9:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reset views and tabs in TM1 applications web
Replies: 11
Views: 1222

Re: How to reset views and tabs in TM1 applications web

Not sure we have the full picture here.

If the views you are talking about are public views then don't give users the rights to save them, then then there should not be an issue.

If you need to reset public views then do it in a TI process rather than messing around in the file system.
by Steve Rowe
Thu Dec 21, 2017 10:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 1607

Re: Count in rules

The key thing with feeders to remember is all the action is at the N level, it is impossible to feed a consolidated cell. Consolidated cells are fed internally when an N level under it becomes non-zero. This is why your consolidation is not showing, since all the cells below it are zero the cell has...
by Steve Rowe
Wed Dec 20, 2017 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 1607

Re: Count in rules

If you have persistent feeders on, which you probably do by default then I suggest turning it off, stopping the server, deleting the .feeder files and restarting. It is possible if you are have written the rule after loading the data that the feeders are not being triggered. Others may disagree but ...
by Steve Rowe
Tue Dec 19, 2017 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 1607

Re: Count in rules

Good link, should be required reading. The other thing to consider is when it is appropriate to use a rule. Given that the number that drives this is loaded from a TI, it would have been easy to populate the count value at the same time. Although this would use more RAM at rest, the eventual calcula...
by Steve Rowe
Mon Dec 18, 2017 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Where is data source for TI in PAW?
Replies: 4
Views: 488

Re: Where is data source for TI in PAW?

Yup, IBM are in the process of migrating all admin / development functionality from Perspective / Architect to PAW. Whilst the PAW piece has been done for the main scripting pages, the datasource and variables parts have not yet been migrated. So you need to set-up the TI in the old world still. Onc...
by Steve Rowe
Tue Dec 12, 2017 5:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Replies: 10
Views: 1235

Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!

I'd be checking what is happening something along the follow lines. If I'm logged in as admin and when I hit the button the TI executes (i.e. I have checked the log and see it runs) then I know the action button is working. If nothing happens server side then the Action button is broken and need to ...
by Steve Rowe
Mon Dec 11, 2017 12:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW questions
Replies: 8
Views: 1085

Re: PAW questions

Wim, I encountered the DimSiz hole as well, was told that you can use DimSiz('dimname:hierarchyname') to get the correct value back, believe this works with many of the old style TI functions if you can't find the equivalent. Not sure if this is formally supported though so I'd use the new functions...
by Steve Rowe
Mon Dec 11, 2017 10:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyway to prevent Files to Accidentally DBSW ?
Replies: 8
Views: 667

Re: Anyway to prevent Files to Accidentally DBSW ?

A small extension to the conditional DBS is to put some VBA in the auto open event of the work book that turns the flag off and/or the before close event. That way the workbook always requires the flag to be set manually and it doesn't matter if the workbook is saved with the flag on or the workbook...
by Steve Rowe
Wed Dec 06, 2017 5:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Work unit operation failed due to lock error. Error code: 1
Replies: 2
Views: 302

Re: Work unit operation failed due to lock error. Error code: 1

These kind of errors need to raised directly with IBM. Just in case you are not aware, this is an un official forum with no formal link to IBM. In order to get IBM to investigate the crash you will need to get a reproducible test case together and crash dumps, together with a whole bunch of informat...
by Steve Rowe
Wed Dec 06, 2017 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To use or not to use persistent feeders?
Replies: 20
Views: 4076

Re: To use or not to use persistent feeders?

I also find out the feeder file someway contains feeders for not rule calculated cells also. For example in every cube we snapshot version to not rule calculated reporting version elements in the version dimension. When I take out the rule from the biggest cube that cube still generated a feeder fi...
by Steve Rowe
Wed Dec 06, 2017 10:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to Filter on Numeric Attribute
Replies: 6
Views: 459

Re: MDX to Filter on Numeric Attribute

Sort of off topic but... Isn't this a symptom of the way numeric attribute are implemented in the first place? Numeric attributes aren't really numeric cells in the same way that data is and IMO are just a "mask" on a string attribute. Personally I rarely use them since they behave like strings and ...
by Steve Rowe
Wed Dec 06, 2017 9:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrading from 10.2.2 to Planning Analytics Local
Replies: 2
Views: 669

Re: Upgrading from 10.2.2 to Planning Analytics Local

Our experience has been quite different to Stefan's, on current releases at least. The complexity of the environment obviously does increase once you want PAW or PAx as you will need the PAW server in place, which mostly implies a second piece of hardware. If you are on an Express rather than a PVU ...
by Steve Rowe
Tue Nov 28, 2017 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form formatting calculated rules
Replies: 3
Views: 384

Re: Active Form formatting calculated rules

Is it an expected behavior? Is it because formatting and custom calculations are done in the same pass? Not convinced I have tried exactly this but you are probably right. I would think that you are better off putting a conditional format rule in the cell format itself at the top for formats that h...
by Steve Rowe
Fri Nov 24, 2017 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos report with summary rows - performance
Replies: 1
Views: 344

Re: Cognos report with summary rows - performance

I think that you need to perform more analysis so that you can determine where the performance hit is coming from. Suggest you check the same report view in TM1 directly and check the performance there, then you will know if the issue is a TM1 one issue or relates to the query and tool you are using...
by Steve Rowe
Wed Nov 22, 2017 9:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Questions for Code editor (TI/Rule)
Replies: 8
Views: 995

Re: Questions for Code editor (TI/Rule)

Hi Thomas, would you mind giving some more detail on the use case for active form client memory runaway?