Yes
Search found 41 matches
- Tue Mar 28, 2023 1:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Displaying 'Value' column in an MDXView
- Replies: 3
- Views: 637
- Tue Mar 28, 2023 2:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Displaying 'Value' column in an MDXView
- Replies: 3
- Views: 637
Displaying 'Value' column in an MDXView
Hi, When you preview a Native View in TI, you get the Value of an intersection in the column and each dimensnion element of the intersection in the row, like this: dim1 dim2 value 1 dim1.element1 dim2.element1 value1 2 dim1.element2 dim2.element2 value2 Is it possible to achieve the same result with...
- Fri Mar 10, 2023 5:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX exploration view automatic recalc?
- Replies: 2
- Views: 589
PAX exploration view automatic recalc?
Where can I set the automatic refresh in a PAX exploration view? It automatically refreshes when I change the order of the dimesions for me, but for other user it does not, couldn't find where is this option. Any help appreciated, thanks.
- Mon Jul 18, 2022 3:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX RestAPI VBA error
- Replies: 7
- Views: 1823
Re: PAX RestAPI VBA error
Indeed that is correct. We had to work around an issue with rebuilding(A) PAFEv66 quick reports in PAFEv76. Not just 3 additional slicers in the header, but also a defect with the QR shifting over to the right by one column. (A): We define rebuild as PAXAPI function Reporting.QuickReports.ReplaceWi...
- Wed Jul 13, 2022 12:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX RestAPI VBA error
- Replies: 7
- Views: 1823
Re: PAX RestAPI VBA error
I did try to unhide the row but nothing happened. The range is in the same sheet as the report. Hi Luiz, Wanted to laser focus on "rebuilds the sheet". Are you using PAFE API for this? If so, what function are you using? Have some thoughts and can help but don't want to go down a path you'...
- Tue Jul 05, 2022 9:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX RestAPI VBA error
- Replies: 7
- Views: 1823
PAX RestAPI VBA error
Hi. We have a quick report with some custom formatting that hasn't been working properly after updating to PAX 73. After updating the dimension filters (subnm), the user press a button that calls a VBA code that test some things, rebuilds the sheet, build the MDX, and query the data. But we've been ...
- Mon Jul 04, 2022 9:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW License
- Replies: 8
- Views: 3529
Re: PAW License
It's always worth checking with your IBM representative your licence capabilities but licence documentation may be found here https://www-40.ibm.com/software/sla/sladb.nsf/search/ My experience though (Disclaimer: not to be taken for granted) is generally if the licence has Planning Analytics in th...
- Sun Jul 03, 2022 9:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW License
- Replies: 8
- Views: 3529
Re: PAW License
So to use PAW, admin license is not required, but to work on PAW's admin utilities, Admin license is required. Correct Is PAW License separate? It depends on the exact nature of your existing arrangement, if you have upgraded from the 10 series then it is probably additional. If your first purchase...
- Sun May 23, 2021 7:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing TM1 database assets with Git
- Replies: 12
- Views: 11455
Re: Managing TM1 database assets with Git
Also, github is deactivating the basic auth that the tm1git uses to connect to their server in august 2021. Now they'll only accept tokens or SSH Key authentication , but tm1git doesn't have support for that! SSH is supported : https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=git-secure-s...
- Fri May 21, 2021 1:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing TM1 database assets with Git
- Replies: 12
- Views: 11455
Re: Managing TM1 database assets with Git
3. Is it possible to hot promote cube data files via this method? I can push/pull the data files but looks like I have to reboot the tm1 server to get data file loaded. Overall, I don't see any detailed examples from IBM apart from some detailed articles from other developers. I agree with you that...
- Wed Dec 09, 2020 11:22 am
- Forum: Useful code, tips and tricks
- Topic: Displaying custom error messages after running a process in PAW
- Replies: 4
- Views: 36820
Re: Displaying custom error messages after running a process in PAW
Well actually there's a much better approach. In the condition where you ItemReject just convert the process on the fly to having no data source. The Metadata and Data tabs will then be skipped and the process will proceed straight to the Epilog. E.g. If( some condition @= 'TRUE' ); DatasourceType ...
- Sun Dec 06, 2020 9:01 pm
- Forum: Useful code, tips and tricks
- Topic: Displaying custom error messages after running a process in PAW
- Replies: 4
- Views: 36820
Displaying custom error messages after running a process in PAW
Hello, ever since Planning Analtics Workspace 2.0.43 when a process execution results in errors, the error log line is displayed directly in PAW. More info about this here . EDIT 7/3/2022 : Ever since PAW 62 this is only working for ADMIN users, apparently it was a bug before. :roll: Thanks Thanks M...
- Wed Nov 25, 2020 2:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Workspace - what can it do?
- Replies: 21
- Views: 17006
Re: PA Workspace - what can it do?
It seems like barely anyone noticed this new featureSteve Rowe wrote: ↑Thu Nov 19, 2020 3:56 pm Hi,
Good shout on the error message luzig2019, hadn't picked this up.
Should I make a topic about this on the "Useful code, tips and tricks" section?
- Thu Nov 19, 2020 3:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Workspace - what can it do?
- Replies: 21
- Views: 17006
Re: PA Workspace - what can it do?
Since PAW 2.0.49 is possible to display custom error messages after executing a process via button.ultrakocka wrote: ↑Thu Nov 19, 2020 11:49 am 1) It's not possible to show custom error messages after running process with active button.
- Fri Aug 21, 2020 4:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy your PAW book design to another TM1 server
- Replies: 9
- Views: 11045
Re: Copy your PAW book design to another TM1 server
Hi, Thanks for sharing this. I have both databases ( Dev and Test) on the same server, one called FnP_Dev and the other one FnP_QA I created all the books and views in DEV and now when I try thing Life Cycle Management to migrate them to QA, yes the package gets created and it gets migrated, but al...
- Fri Aug 21, 2020 4:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Linking Views in PAW
- Replies: 2
- Views: 1915
Re: Linking Views in PAW
Go into edit mode, select the first cube view, click on "Properties" (the last icon in the edit bar that pops up when you go into edit mode), go to "Synchronize" and select "Syncrhonize dimensions" + all dimensions that you want to sync. Don't forget to do that for the ...
- Tue Aug 18, 2020 12:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security Assignments
- Replies: 1
- Views: 1150
Re: Security Assignments
Although in the IBM documentation says you can use Lock and Reserved in a cell level, when I tried using those values in a CellSecurity cube, nothing seemed to change. The only values that worked were Read, Write and None. So I guess you're right.
- Mon Aug 10, 2020 5:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy your PAW book design to another TM1 server
- Replies: 9
- Views: 11045
Re: Copy your PAW book design to another TM1 server
* no bulk promotions (you're going book by book) * you lose all security at this point on this book and need to reset it (from screenshots and what not?) Yeah it's annoying having to set up the security on each book manually again, but at least now you don't have to change the cube views, processes...
- Mon Aug 10, 2020 5:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy your PAW book design to another TM1 server
- Replies: 9
- Views: 11045
Re: Copy your PAW book design to another TM1 server
If the server name doesn't exist it should fail, saying TM1 database not available I've never seen this before. :oops: How do you create a snapshot of a database that doesnt exist thouogh? Like I made modifications on server A and want to migrate this to server B but both exist already. I could onl...
- Mon Aug 10, 2020 2:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy your PAW book design to another TM1 server
- Replies: 9
- Views: 11045
Re: Copy your PAW book design to another TM1 server
Hi, Isn't there also the option that when you Migrate and it errors (because the target server doesn't exist) it allows you to Select a TM1 database and you can then select the one you want? Maren This never happened to me before, I belive it's only for cloud clients no? On PAW local it doesn't let...