TM1 Forum

Hi,

no progress yet, got as far as you really. Have parked this at the mo due to other priorities but will be back on it at some point.

I will let you know how I get on!

regards, Mark

Hi gtonkin,

I noticed your steps were for 10.2, before I look into this, do you think all those steps are still relevant for planning analytics?

regards, Mark

Hi, I am trying to create integrated login. I have managed to get architect and perspectives to work (Just click on the server and it lets you in). However with mode 2 when prompted for a user name and password, I can no longer login manually using my windows id and password, my windows password doe...

Hi dr.nibble, Yes, managed to remove the container, ran paw.ps1 stop, then paw.ps1 and everything is working (fingers crossed). Apologies for throwing questions at you, but could you answer the following please? Is it possible to have docker installed on one server and PAW installed on another serve...

Hi dr.nibble,

Hope you are listening!

We have an issue, separate to the one above, with the pa-gateway container having a status of dead.

The error message says
We are unable to restart the container from the admin tool or via a reboot?

regards, Mark

I am sure someone will say it would then be a good idea to make the subset(s) static. But I haven't yet seen where that makes anything run quicker! No sure how most people create views in TM1 but I just have one create view process which uses the expand and tabdim functions and creates a view for an...

Hi dr.nibble, many thanks. So we got the container running, not saying exited anymore. However we noticed in the admin tool configuration that the url's needed to be changed. Finally we were able to login to workspace but it wouldn't open any books and said, it could not find the TM1 database. Could...

Thanks dr.nybble.

Just to be sure, if I copy this script and save it to a folder location I can then run the script in powershell?

Also given the issues I explained in my previous comment do you think running this script would be worth a try or would you suggest anything else?

regards, Mark

Hi dr.nybble, I suspected this might have something to do with it. I don't know where the file is, I was just following some advice from IBM website https://www-01.ibm.com/support/docview.wss?uid=ibm10881484 They didn't specify you needed the location of the file. How would I find it? I don't know i...

Hi, I am getting a gateway error, it says exited. I have tried to run the .\WindowsContainerNetworking-LoggingAndCleanupAide.ps1 -Cleanup -ForceDeleteAllSwitches command in powershell but am getting the following error: .\WindowsContainerNetworking-LoggingAndCleanupAide.ps1 : The term '.\WindowsCont...

When you say not containers not starting up are you saying not automatically starting up or are you saying won't start up manually or automatically?

Hi,

Try making nDate a string and then cast in the sql code

So, WHERE NUMERIC_DATE <= cast('?nDate?' as whateveryouneedtocastitto)

cheers, Mark

Hi,

is there an hidden sheet called picklist in the one that isn't working?

Is there a full list anywhere of "Why PAx is not operationally ready to fully replace Perspectives".

If not could Garry share his personal list and I will start one!

Hi,

are you certain that both TM1 environments are version 10.2. I only ask because I think in 10.1 the maximum it could be set to was 4096, and only in version 10.2 could it be set above this?

regards, Mark

Hi, I am sure one of experts on here used the following, which I now use: Create a substet by mdx first, so: subsetcreatebymdx( sSub, sMDX); Then I use SubsetMDXGet, so: vMDX = SubsetMDXGet( vDim , sSub ) ; Finally use SubsetMDXSet, so: IF( vMDX @<> '' ) ; vNumElems = SubsetMDXSet( vDim, sSub , '' )...

No problem and thanks for the advice!

Hi Bakkone,

On the prologue? Won't that affect the meta and data tabs?

I presume JIm had something else in mind?

cheers, Mark

Hi Jim, thanks for the reply.

No there is no ODBCClose in the prologue or anywhere in the process for that matter

cheers, Mark

Hi,

does anyone know if the TM1 service can hold open an ODBC connection permanently for a TI execution?

We have some issues and IT have said TM1 is holding open an odbc connection and preventing some backups

cheers, Mark