Search found 1882 matches

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.
by Steve Rowe
Fri Aug 30, 2024 4:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Trace Feeder and Check Feeder Disagree
Replies: 5
Views: 4483

Re: Trace Feeder and Check Feeder Disagree

You've got to the right answer. It's important to remember what triggers a feeder to execute as they aren't live like a rule is. When a server starts (assuming no persistent feeders) When data changes from null to non-zero Forced recompile via TI. Changing the structure of a dimension doesn't force ...
by Steve Rowe
Wed Jul 17, 2024 12:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Instance is not showing in tm1 Architect
Replies: 2
Views: 3324

Re: IBM Instance is not showing in tm1 Architect

Hi, Please make sure you post in the correct forum. So 1. PAW and Pax are irrelevant to Architect, so no need to think about them. 2. In the admin host setting for Architect you need the IP address or the FQDN for TM1 Admin Host, this is nearly always the IP address of the machine that the TM1 DB is...
by Steve Rowe
Tue Jul 09, 2024 8:00 am
Forum: Useful code, tips and tricks
Topic: VBA to clean up named ranges.
Replies: 2
Views: 15394

Re: VBA to clean up named ranges.

Interesting, had not encountered this before.