Search found 1885 matches

by Steve Rowe
Wed Jan 07, 2026 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: FEEDING String Rules on Consolidation Cells
Replies: 3
Views: 1444

Re: FEEDING String Rules on Consolidation Cells

The comments about populating with a TI are probably the most right If you want to do this with rules then the feeder needs to be in the 10d cube and needs to start from a leaf cell that is populated at the right level, as you suggest in your post. but 1. You need to put the Feedstrings statement in...
by Steve Rowe
Thu Sep 04, 2025 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom indentation for dimension dlements in PAfE
Replies: 1
Views: 39864

Re: Custom indentation for dimension dlements in PAfE

Hi, You may want to try setting the indentation argument of the TM1RptROw formula to 0. I suspect it is overriding your custom formats.

https://www.ibm.com/docs/en/planning-an ... -tm1rptrow

Cheers,
by Steve Rowe
Thu Aug 07, 2025 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Users unable to direct enter into a form
Replies: 7
Views: 272348

Re: Users unable to direct enter into a form

Hi, There's really only a couple of options here. 1. It is security and you've missed something in your analysis. It can't be locking as that would be impacting Admins too. 2. The view you're using as admin and as end user is different (i.e. consolidated / not at the lowest level) and so the cell is...
by Steve Rowe
Fri Jun 06, 2025 9:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: how to connect PAfe client to TM1 Server directly via RestAPI?
Replies: 2
Views: 23508

Re: how to connect PAfe client to TM1 Server directly via RestAPI?

Hi Chris,
I'm afraid it is not possible to connect PAfE direct to the TM1 DB, it must go via PAW.
by Steve Rowe
Wed Mar 19, 2025 11:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can I upgrade just the PAW piece from 2.0.78 to 2.0.88
Replies: 1
Views: 6367

Re: Can I upgrade just the PAW piece from 2.0.78 to 2.0.88

I wouldn't recommend it, but at the end of the day do it in your dev environment and test to see if it works, then you'll have your answer.

Do note though that the 2.0.9 series goes off support in October 2025, so you should be planning a full upgrade to the 2.1 series anyway.
by Steve Rowe
Thu Mar 06, 2025 9:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Creating a new landscape
Replies: 7
Views: 18523

Re: Help on Creating a new landscape

... My understanding is that in the medium term there is an expectation that PASS will become part of PAW. ... My understanding is the TM1Web, the UI to PASS will fall away and websheets will need to be embedded into PAW. To allow PAW to render these websheets, you will need PASS running as the &qu...
by Steve Rowe
Wed Mar 05, 2025 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Creating a new landscape
Replies: 7
Views: 18523

Re: Help on Creating a new landscape

Hi, Just to point out that PASS is required for some PAfE functionality, Universal Reports. In my experience people don't tend to run a web server. The TM1 DB and PASS goes on the windows box and PAW goes on the RHEL box. My understanding is that in the medium term there is an expectation that PASS ...
by Steve Rowe
Fri Jan 24, 2025 9:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CREATE BEG BALANCE TI PROCESS FOR TRIAL BALANCE
Replies: 2
Views: 7108

Re: CREATE BEG BALANCE TI PROCESS FOR TRIAL BALANCE

You need to check the content of the TIs listed in the Prolog and try and understand what they do.
by Steve Rowe
Wed Jan 22, 2025 9:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to identify overfeeding
Replies: 6
Views: 20134

Re: How to identify overfeeding

Let's start at the beginning then. :shock:

What are the symptoms you are experiencing that lead you to believe you are overfeeding?
by Steve Rowe
Wed Jan 22, 2025 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best way to optimize feeders
Replies: 4
Views: 15287

Re: Best way to optimize feeders

One thing to make sure of when you are recasting feeders is to make sure that. 1. If Persistent Feeders is turned on then delete the .Feeder files, with the server down. 2. Restart the database, even if you aren't using Persistent Feeders. Otherwise you aren't really testing your current feeder set.
by Steve Rowe
Tue Dec 03, 2024 4:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Saving and Reusing user settings
Replies: 14
Views: 22547

Re: Saving and Reusing user settings

There's no way of doing what you want at this time*, i.e. configure a picklist such that it opens the set editor dialogue. I can see that it would be useful and would give the best of both worlds where we get the richness of the set editor but also the ability to store and reuse the users selections...
by Steve Rowe
Thu Nov 21, 2024 5:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filter on multiple values using virtual hierarchies
Replies: 3
Views: 5155

Re: Filter on multiple values using virtual hierarchies

You probably need to drop down and use a TI to create the hierarchy using functions such as HierarchyElementInsert and HierarchyElementComponentAdd You would then use this to create a hierarchy that has double counting in it (which is odd and a little scary) Then you could have Bob = 001 + 004 + 007...
by Steve Rowe
Wed Nov 20, 2024 5:09 pm
Forum: Enhancements
Topic: Being able to edit and save flat views
Replies: 0
Views: 68092

Being able to edit and save flat views

Hi, PAW 2.0.99 contains functionality dealing with flat views used for exporting and as datasources for TIs. Thread discussing this is here https://community.ibm.com/community/user/businessanalytics/discussion/flat-views-and-exporting-as-text My idea is here. https://ibm-data-and-ai.ideas.ibm.com/id...
by Steve Rowe
Mon Nov 11, 2024 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Which platform do you use to write TI and Rules ?
Replies: 8
Views: 17627

Re: Which platform do you use to write TI and Rules ?

Rules and TI : PAW (with some text functions in Excel for stuff that repeats...)
Data : Pafe / PAW
by Steve Rowe
Wed Nov 06, 2024 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sparce cubes with rules
Replies: 1
Views: 4140

Re: Sparce cubes with rules

Hi Dirk,

The standard practice here would be to
A. Make sure you have written a Feeder statement, this would be in the sparse cube pointing at wherever the rules is.
B. Make sure you have skipcheck on where the rule is.

Can't say much more than that without more detail
by Steve Rowe
Mon Oct 21, 2024 5:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Migrate tm1 applications to PAW
Replies: 1
Views: 5173

Re: Migrate tm1 applications to PAW

I think you asking how to migrate the TM1 Apps Web or TM1 Applications workflow functionality to PAW Applications and Plans? As of right now in the 2.0.9 series TM1 Apps Web should continue to work, assuming you install Performance Modeler and use the same interfaces as before. However, if you are g...
by Steve Rowe
Tue Oct 08, 2024 1:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetMDXSet and SubsetCreatebyMDX error
Replies: 4
Views: 8298

Re: SubsetMDXSet and SubsetCreatebyMDX error

It's worth noting that the set editor in PA no longer requires / displays the opening set of curly brackets. If you are using the MDX from the set editor to derive the MDX for the MDX set you are building you need to remember to add the curly brackets back as the TI functions require the opening cur...
by Steve Rowe
Tue Sep 24, 2024 8:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Scan of rules not returning what I am expecting
Replies: 8
Views: 13041

Re: Scan of rules not returning what I am expecting

Steve Rowe wrote: Wed Sep 18, 2024 1:30 pm scribe, subscribe !
Pretty sure this was the example quoted in the help document at one time, just stuck in my brain....
by Steve Rowe
Mon Sep 02, 2024 8:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Trace Feeder and Check Feeder Disagree
Replies: 5
Views: 6465

Re: Trace Feeder and Check Feeder Disagree

Yes, also correct, Trace shows what would happen now if the feeder statement fired and Check shows what did happen.