TM1 Forum

Morning I have used the TM1 scrambler utility for some time now to create scrambled versions of cubes to use in lower environments. (See Below) DebugUtility ( 114 , 0 , 0 , 'myCube' , 'C:\data\scrambled' , '' ) ; Most of the time I have used Windows and it has created C:\data\scrambled\myCube.cub on...

Could be cube logging is on.

Also Much quicker to delete view via supporting dimension element deletion and re-insertion but this is not always possible.

Otherwise Mr Geilis and the bedrock libraries is your best bet.

Sorry for my spitball idea above, it does nothing today or even this week to help fix your slow restart problem and if we're dependent on enduser complaints, our sample size will forever be too large. I tried to replicate your issue of a slower restart by creating 5,00 and 15,000 private subsets fo...

Set LoadPrivateSubsetsOnStartup=F in the config and see who complains about super long login time? Exactly my thoughts, but it turns out this default setting (which worked fine in windows) had to be changed to =T on IBM's advice for Unix when we started getting long logins. This worked fine for fou...

We encountered a problem where the time to load private subsets into memory went from 1hr 5min to 8 hrs. This occurs as pretty much the last operation of start up and there was a week between the two startups. We have a lot of users but we don't see what is changed to make this jump since we likely ...

gtonkin wrote: ↑Wed Oct 18, 2023 2:52 pm The new PA on AWS (PA aaS) trial is here

Thank you gtonkin and all respondents

You would think (maybe they do!) that IBM would have some kind of support network for people who have passed the badges, so when they lose their job they have access to training/development environments etc. I suppose that once they get TM1 itself established as part of the application running unde...

I would appreciate anyone's advice on Advice on training in Planning Analytics between jobs. I see there is an option to download a free trial from IBM, but I'm worried I might get roped into paying a lot of money to continue with that trial. I literally want to use Planning Analytics to upskill but...

MongoDB is a text optimised database where the PAW assets are stored as json. If it doesn't work you have no assets. There are two distinct issues that we have encountered with MongoDB since we moved to OCP. (Openshift container platform) 1. Corrupted MongoDB – PAW objects are lost forever unless yo...

Solution The user was attempting to login to the CAM authentication service with stored credentials which were out of date as the user had changed their password without the store updating. Type Credentials to get Credential Manager and then Windows Credentials. Delete the credential and it will cre...

Afternoon I have a very perplexing problem where PAX authentication has suddenly stopped working for a user. Normal troubleshooting has produced results and I am hoping someone in the wide world of the forum has encountered this. We are using PAX 72 with Mode 5 (CAM authentication) Normally the user...

As lotsa says, access to PAW is independent of TM1 at present and is through clunky .csv load/unload. The security gradation for users in PAW are just admin/non admin, but PAW users can be given permissions to access PAW objects by the owners of objects. When you need to connect to instances you wil...

So the TM1 Servers move to the cloud as a service for IBM managed clouds (Openshift I assume). This will be the same black boxing as the PAW HTTP and Webservices and mean traditional access to the servers disk objects is gone without admin access to the cloud platform. All good until something break...

Server and Instance connections are held in CustomProperties in Excel and Named ranges. You can bulk VBA through a directory of workbooks. You can't change any VBA code in the macros by VBA though you have to do that through find and replace for the Project.

Thanks Alan - I can confirm in 2022 this bug has not been resolved. The load on demand is ignored if the cube has any feeders including internal feeders! As you say, IBM docs should be updated to say Load on Demand is effectively useless since large cubes will always have some type of feeders. As al...

L & G A user was moaning that, when he was moving from Cell to cell in a spreadsheet with PAX enabled, it was taking 5 seconds. So PAX was intercepting an event and doing 5 seconds of work and then returning control to Excel to move the cursor. We told him to type and run this in VBA: "Appl...

Thanks Burnstripe - havent had time to try this - will let you know soon as I can.

When we make a "large" (>1MB) HTML request to Websphere from PAX (this can be report with many rows or typically a commit request that has a lot of tuples) we get it bounced back at the Webserver level as below. This severely limits what we can do in PAX. Capture.PNG So we found out that a...

Watch out with spreading esp auto spread. When you have loads of dimensions you can inadvertently generate a massive query. We had this and turned spreading off.

Hi, Refresh security, isn't that just a right-mouse button click on the server name ? Capture.PNG Wim, I stand corrected. Thanks all for your replies so far. Thanks Alan for your very comprehensive and entertaining response. qq On top of my original, hearing good things about 3rd party development ...