Search found 1845 matches
- 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...
- 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,
If you have logging enabled you could consider replication.
Export and import of active periods
Cheers,
- 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...
- 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......
- 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 ...
- 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...
- 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...
- 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.
So, as you say, perhaps an issue with an Office update that has since rolled back.
- 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...
- 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?
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?
- 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
Scratch that, frustratingly that switch doesn't appear to work with the carbon viewer that is the default in Pafe 2.0.90
- 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
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
- 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
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
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- Mon Jul 17, 2023 4:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel asks for Credentials in PAX when the CAM Authentication Service should get Credentials
- Replies: 2
- Views: 590
Re: Excel asks for Credentials in PAX when the CAM Authentication Service should get Credentials
Thanks for updating the group John, appreciated!