TM1 Forum

lotsaram wrote: ↑Tue Mar 28, 2023 7:01 am I guess you are talking about the preview window for TurboIntegrator?

Yes

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...

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.

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...

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'...

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 ...

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...

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...

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...

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...

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 ...

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...

Steve Rowe wrote: ↑Thu Nov 19, 2020 3:56 pm Hi,
Good shout on the error message luzig2019, hadn't picked this up.

It seems like barely anyone noticed this new feature
Should I make a topic about this on the "Useful code, tips and tricks" section?

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.

Since PAW 2.0.49 is possible to display custom error messages after executing a process via button.

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...

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 ...

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.

* 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...

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...

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...