Search found 202 matches

by burnstripe
Mon Jul 08, 2024 12:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Very slow DBRW performance when a cube is used as data source
Replies: 3
Views: 537

Re: Very slow DBRW performance when a cube is used as data source

I believe there's 2 factors causing this. 1) the cloud environment will have a higher ping (latency) , result in slower response time 2) pax will be recalculating after every change to the worksheet Some options to address this are: 1) change existing method. A) Consider outputting the content with ...
by burnstripe
Thu Jun 20, 2024 9:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder recalculation at restart with persistent feeders on
Replies: 2
Views: 226

Re: Feeder recalculation at restart with persistent feeders on

Possible reasons A process called DeleteAllPersistentFeeders() before it was restarted The service when restarted did not stop gracefully, aka terminated Cube file was newer then corresponding feeder file (can happen if service not stopped gracefully) Feeder file was missing for a cube, forcing full...
by burnstripe
Mon Jun 10, 2024 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Install PA2.1.0 Questions
Replies: 3
Views: 3482

Re: Install PA2.1.0 Questions

You should be able to synchronise excel sheets if you set the synchronisation scope for the book correctly
by burnstripe
Mon Jun 10, 2024 10:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Install PA2.1.0 Questions
Replies: 3
Views: 3482

Re: Install PA2.1.0 Questions

There isn't a direct replacement for old school applications in paw. There is a feature, Applications and Plans in PAW which allows you to group content into a series of tasks and set task dependencies (i.e. one task begins after another completes if desired). There's no concept of taking ownership ...
by burnstripe
Tue May 07, 2024 6:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Email Alerts with PAW
Replies: 3
Views: 2593

Re: Email Alerts with PAW

I believe the only way to return the state of the process is via a master process and getting the state code. A way around this may be to create a generic process to execute desired process and pass the relevant parameters. And map the buttons to the generic process instead. The master parameter may...
by burnstripe
Wed Mar 20, 2024 7:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics workspace is down
Replies: 8
Views: 3530

Re: Planning Analytics workspace is down

Is there sufficient memory on the server? The installation of new services could have pushed the memory usage up which could cause paw to fail if the memory on the server was already marginal.
by burnstripe
Tue Mar 12, 2024 11:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE Issue on Win 11
Replies: 7
Views: 1645

Re: PAfE Issue on Win 11

Shot in the dark, but I know tm1 used to have a dependency on Internet explorer for authentication, with Windows 11, this is no longer there... and the old PAW is likely still requiring the legacy method of authentication. I would try exploring option 4 in this link, adding the old paw link https://...
by burnstripe
Tue Mar 12, 2024 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE Issue on Win 11
Replies: 7
Views: 1645

Re: PAfE Issue on Win 11

Personally I would recommend updating PAW, that's a big version difference and perhaps IBM had to implement something on the server side to support Win 11 clients
by burnstripe
Thu Mar 07, 2024 10:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can not see new TM1 server instance in TM1 architect
Replies: 1
Views: 670

Re: Can not see new TM1 server instance in TM1 architect

Check that ports on the new server are unique, the described behaviour sounds like another server is already using those ports
by burnstripe
Wed Feb 21, 2024 5:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can not see models list in TM1 Architect
Replies: 9
Views: 1265

Re: Can not see models list in TM1 Architect

There could be several reasons for the instances not showing, some of which are.. - Firewall (unlikely since other clients could connect) - Incompatible client (architect version differs pa server version possible but do not suspect as it sounds like the other architect versions hadn't been updated)...
by burnstripe
Tue Feb 20, 2024 11:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can not see models list in TM1 Architect
Replies: 9
Views: 1265

Re: Can not see models list in TM1 Architect

Is the install set up to use the IBM certs or self certified certs? If it uses self certified the issue it may be the certificates are missing... Here's a link on it... https://www.ibm.com/support/pages/how-configure-custom-ssl-certificates-planning-analytics-20-and-201 I'm wondering if the tm1api.c...
by burnstripe
Sat Feb 17, 2024 5:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drilldown in reports by user
Replies: 2
Views: 416

Re: Drilldown in reports by user

If I've interpreted your message correctly... You could have a cube with the following dimensions: }Clients Accounts Measure... The measure dimension would have a string field say Mayor Accounts selection. The cube could have a picklist allowing the user to confirm their selection by entering Y, fro...
by burnstripe
Mon Jan 29, 2024 9:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Date calculation not working in Excel due to Windows date format
Replies: 1
Views: 544

Re: Date calculation not working in Excel due to Windows date format

Do you have a serial number stored as an alias to the date? If you did you could then have pull this serial into the excel report and then perform the further excel calc B2 = A2 + 3 substituting A2 with the new serial number. As an aside, were you aware of a date picker https://community.ibm.com/com...
by burnstripe
Sat Oct 21, 2023 4:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recreating Hierarchy by Attribute
Replies: 2
Views: 2876

Re: Recreating Hierarchy by Attribute

This would be the approach I would take - creating my own alternative hierarchy based on attributes without using function CreateHierarchyByAttribute and just use HierarchyDeleteAllElements instead of using HierarchyDestroy before Except I would perform this all in the metadata tab. If the elements ...
by burnstripe
Sat Oct 21, 2023 5:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW How to make View Filters work together
Replies: 9
Views: 9508

Re: PAW How to make View Filters work together

Check out the link below. You could create a cube with two dimensions, one with the }clients dim, the other with elements container size and destination. The container size would have a picklist showing available sizes. The user would make, store their chosen selection (against their userid tm1user ...
by burnstripe
Sat Sep 02, 2023 7:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any tm1web log setting to get user access websheet info
Replies: 6
Views: 1429

Re: Any tm1web log setting to get user access websheet info

Here's a link to another thread on the topic.
https://www.tm1forum.com/viewtopic.php?t=14808

The tm1web logs can produce this information such as who accessed what websheet and when. After changing the Log4j properties you'll then need to parse through the file to extract the information you need
by burnstripe
Mon Aug 21, 2023 5:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Connect in Excel
Replies: 4
Views: 928

Re: Server Connect in Excel

Which excel add-in are you using, the legacy perspectives or newer pafe/pax. If it's pafe/pax then for the addin to be fully functional you'll need to install planning analytics workspace (paw) which I wouldn't recommend attempting to install on your laptop. There's an awful lot of hoops you'd need ...
by burnstripe
Fri Jul 14, 2023 12:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX - Excel calculation based on Dynamic Report (Active Form)
Replies: 6
Views: 1518

Re: PAX - Excel calculation based on Dynamic Report (Active Form)

Thank you it helped May be you know another workarounds except offset ? In some places write that it is resource consuming The other question I guess is does sheet1 need be linked to sheet2 like this. I.e. What's stopping sheet1 from also being a dynamic report sharing the same filters as sheet2? T...
by burnstripe
Wed Jul 12, 2023 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX - Excel calculation based on Dynamic Report (Active Form)
Replies: 6
Views: 1518

Re: PAX - Excel calculation based on Dynamic Report (Active Form)

On dynamic reports the data rows are destroyed upon rebuild, so any direct reference to these rows will be destroyed on rebuild. Hence the links are broken as you are experiencing. One workaround would be to use the offset function were the range start is above the dynamic rows, then when the report...