Search found 1845 matches

by Steve Rowe
Fri Dec 01, 2023 12:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Saving and Reusing user settings
Replies: 10
Views: 12746

Re: Saving and Reusing user settings

Sounds like a good first step. You could have put your rule against the Picklist attribute rather than in the picklist cube. You only tend to need picklist cubes with much more complex logic against a data cube rather than the simple 2d list we are working with here. (i.e. it's the picklist cube you...
by Steve Rowe
Fri Dec 01, 2023 9:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM usage exploding with CubeUnload and ViewConstruct
Replies: 5
Views: 11695

Re: RAM usage exploding with CubeUnload and ViewConstruct

If the method you have picked for keeping the cubes aligned is not working, have you considered other methods? A couple of methods, there are probably others.

If you have logging enabled you could consider replication.
Export and import of active periods

Cheers,
by Steve Rowe
Thu Nov 30, 2023 3:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prerequisites and Challenges: PAW installation
Replies: 6
Views: 9290

Re: Prerequisites and Challenges: PAW installation

any suggestions please we are in the middle of the decision-making to with PAW or stay with TM1 Web. Go RHEL for PAW. PAW is massively better than TM1Web, assuming you want to use dashboards of course. Much better dev and admin tools as well. You get to use Pafe too, baring in mind that Excel 365 a...
by Steve Rowe
Thu Nov 30, 2023 3:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prerequisites and Challenges: PAW installation
Replies: 6
Views: 9290

Re: Prerequisites and Challenges: PAW installation

Is there any way to monitor the excluded directory to see if any files/folders are modified for malicious activity? something like that? to prevent those excluded files/folders from safe. please suggest if these are feasible options. I think this is a virus scanner so you're getting circular now......
by Steve Rowe
Thu Nov 30, 2023 3:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Saving and Reusing user settings
Replies: 10
Views: 12746

Re: Saving and Reusing user settings

Hi, This is the section of the help on picklists https://www.ibm.com/docs/ru/planning-analytics/2.0.0?topic=dimensions-creating-pick-lists It's normal (for me) to use a subset (https://www.ibm.com/docs/ru/planning-analytics/2.0.0?topic=types-subset-pick-lists) driven picklist. Normally the set that ...
by Steve Rowe
Thu Nov 30, 2023 9:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Saving and Reusing user settings
Replies: 10
Views: 12746

Re: Saving and Reusing user settings

If you want to knit your reports / front ends together so that user selections follow the user around the sheets, environments and across sessions, do something like the following. 1. Build a Front End Selection cube, dimensioned by }Clients and "Selection" which contains the selection ref...
by Steve Rowe
Wed Nov 15, 2023 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance drop between 2.0.9.1 and 2.0.9.15
Replies: 7
Views: 9954

Re: Performance drop between 2.0.9.1 and 2.0.9.15

Just in case you've been misinformed somewhere, is there a reason you are going to 2.0.9.15? It's over a year old now, 2.0.9.18 is probably what you should be moving too. Around the 15 release there was a lot going wrt to ODBC that may have impacted other areas. Given that it's fairly trivial to fli...
by Steve Rowe
Tue Oct 31, 2023 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Office 2019 Update breaking Pafe
Replies: 3
Views: 6271

Re: Office 2019 Update breaking Pafe

I think the .Net update KB5031904 is not related as I've just been working with a customer who had not had that update but was experiencing the issue.

So, as you say, perhaps an issue with an Office update that has since rolled back.
by Steve Rowe
Tue Oct 31, 2023 12:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Office 2019 Update breaking Pafe
Replies: 3
Views: 6271

Re: Office 2019 Update breaking Pafe

Just to follow up on this. We experienced this across multiple customers and internally across various versions, no real pattern. We think, but cannot prove that the issue was triggered by this automatic update, the timing of the update matches for those impacted. https://support.microsoft.com/en-gb...
by Steve Rowe
Tue Oct 31, 2023 10:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Office 2019 Update breaking Pafe
Replies: 3
Views: 6271

Office 2019 Update breaking Pafe

Hi,
We've seen internally and at a customer the last Office 2019 update breaking Pafe (i.e. ribbon not loading).
Deleting the Office Connection folder and reinstalling the .xll didn't work.
Reinstalling Excel resolved the issue.

Anyone else seeing this issue and have a better fix?
by Steve Rowe
Fri Oct 06, 2023 2:47 pm
Forum: Enhancements
Topic: Slice from Cube Viewer should goto a new book
Replies: 3
Views: 11991

Re: Slice from Cube Viewer should goto a new book

Great thanks, excellent!

Scratch that, frustratingly that switch doesn't appear to work with the carbon viewer that is the default in Pafe 2.0.90
by Steve Rowe
Thu Oct 05, 2023 9:20 am
Forum: Enhancements
Topic: Slice from Cube Viewer should goto a new book
Replies: 3
Views: 11991

Slice from Cube Viewer should goto a new book

Fairly simple one.

Currently a slice from the cube viewer in Pafe goes to the active book.

Request to be able to configure it so that it slices to a new book or have the full range of options that are available off the task bar.

https://ideas.ibm.com/ideas/PAOC-I-1269
by Steve Rowe
Thu Oct 05, 2023 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Inconsistent top/bottom filter in PAW
Replies: 1
Views: 415

Re: Inconsistent top/bottom filter in PAW

What you may find is that it is including zeros in the top count and then suppressing them.

i.e. if you have 10,5,0,0,0,-5,-10
You will only get two numbers in a suppressed top / bottom 5.

If you have a low record count you are better off sorting the list then using top / bottom
by Steve Rowe
Fri Sep 15, 2023 5:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory usage gradually increased to maximum (64 GB) after restarting the tm1 service
Replies: 9
Views: 1929

Re: Memory usage gradually increased to maximum (64 GB) after restarting the tm1 service

You should be clear about what RAM is increasing. If the server is maxing out are you sure the TM1 DB is the cause? Can you see what is using this RAM? I ask this because I recently had an issue at a two different clients where the RAM on the box was maxing out but not visible vs anything in task ma...
by Steve Rowe
Tue Aug 15, 2023 10:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Data Between cubes; Failing due to consolidated members
Replies: 4
Views: 704

Re: Copy Data Between cubes; Failing due to consolidated members

I think this is the second use case that I outlined. You need to set your export up to use the C level of Period Month Main (the YTDS) and in order to get them to appear in the query you will need to uncheck the Exclude Consolidations in View check box (or use the equivalent TI command). The both th...
by Steve Rowe
Mon Aug 14, 2023 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Data Between cubes; Failing due to consolidated members
Replies: 4
Views: 704

Re: Copy Data Between cubes; Failing due to consolidated members

In this situation you would add an attribute to use for the mapping. sPeriodToWriteTo = Attrs ('PERIOD MAIN' , vPeriodInSource, 'Mapping Attribute to PERIOD MONTH MAIN'); CellPutN('CubeAInput' ,..... sPeriodToWriteTo.....); If it is just that your source has YTDs at leaf and your destination movemen...
by Steve Rowe
Thu Aug 10, 2023 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hello Forum Members, I am reaching out to seek guidance and assistance regarding a setup we have in our client's environ
Replies: 2
Views: 948

Re: Hello Forum Members, I am reaching out to seek guidance and assistance regarding a setup we have in our client's env

Also worth checking what activity is going on in the TM1 DB. Could there be a long running / broken TI hogging the processors? Has the issue persisted through a restart of the TM1 DB? Given the symptoms you describe I'd be looking for some kind of change to the infrastructure or change in the TM1 DB...
by Steve Rowe
Wed Aug 09, 2023 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Write Access Denied in TM1 worksheet
Replies: 3
Views: 694

Re: Write Access Denied in TM1 worksheet

Rule based values can not be overwritten, your user is wrong. A possible exception might be where the rule has a switch in it to allow entry, this might happen in Budget versions vs an Actual version. It would read something like. ['KPI']= If (Attrn ('Version' , !Version , 'IsBudget')=1 , Stet , ['A...
by Steve Rowe
Fri Jul 21, 2023 8:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Buttons do not work after upgrade of PASSL
Replies: 2
Views: 8750

Re: Action Buttons do not work after upgrade of PASSL

Hopefully you have already raised with IBM support? If it's bug then they will likely be the only ones that can help...