Search found 197 matches

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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...
by burnstripe
Thu Jun 22, 2023 10:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help in creating a PAW report
Replies: 2
Views: 589

Re: Help in creating a PAW report

You could create two alternate hierarchies Account Location In your dim1 which has the concatenation of account and location So you had Acc1-loc1 Acc1-loc2 Acc2-loc1 Acc2-loc2 In the account hierarchy you would have Parent: acc1 child: acc1-loc1 Parent: acc1 child: acc1-loc2 Parent: acc2 child: acc2...
by burnstripe
Wed Jun 21, 2023 4:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: consolidating a dynamic subset via the rules file
Replies: 3
Views: 634

Re: consolidating a dynamic subset via the rules file

Rather than looping through the elements in the subset in a ti process and incrementing, you could use the mdx view you already have as the source for the process so the values are already aggregated. To do this solely in rules Cellvaluen may be an option, I believe you can refer to a subset in plac...
by burnstripe
Tue May 02, 2023 10:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to sum all elements except the current?
Replies: 11
Views: 2320

Re: Rule to sum all elements except the current?

Reflecting, consolidations is the only way to go. From a performance perspective you're going to need to use consolidations and should you attempt to refer to a consolidation with all leaves it's going to cause a circular reference, alternate hierarchy or not. Other options to using consolidations w...
by burnstripe
Tue May 02, 2023 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to sum all elements except the current?
Replies: 11
Views: 2320

Re: Rule to sum all elements except the current?

Assuming that element 3 value can just be a calculation and doesn't need to be fed then you could maybe do this ['dim1':'dim1':'Element 3','Value']:N ['Dim 1':'hier','all elements'] - ['dim 1':'hier':'Element 3']; Where you're referring to an alternative hierarchy to pull back all elements and subtr...
by burnstripe
Tue May 02, 2023 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Virtual Machine configuration and PA
Replies: 7
Views: 2179

Re: Virtual Machine configuration and PA

Hi Steve, I also agree looks like dynamic memory allocation is in effect with a startup close to 35gb you're seeing and max of 72gb Not sure if this is run from the host server or the VM itself but this could confirm your suspicions https://www.dtonias.com/which-virtual-machines-use-dynamic-memory-h...