Search found 194 matches

by Mark RMBC
Tue Sep 10, 2019 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrated Login
Replies: 7
Views: 443

Re: Integrated Login

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
by Mark RMBC
Mon Sep 09, 2019 10:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrated Login
Replies: 7
Views: 443

Re: Integrated Login

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
by Mark RMBC
Mon Sep 09, 2019 8:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrated Login
Replies: 7
Views: 443

Integrated Login

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...
by Mark RMBC
Tue Sep 03, 2019 2:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW not working after network changes
Replies: 35
Views: 8898

Re: PAW not working after network changes

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...
by Mark RMBC
Mon Sep 02, 2019 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW not working after network changes
Replies: 35
Views: 8898

Re: PAW not working after network changes

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
paGateway issue.PNG
paGateway issue.PNG (80.05 KiB) Viewed 1833 times
We are unable to restart the container from the admin tool or via a reboot?

regards, Mark
by Mark RMBC
Thu Aug 29, 2019 1:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to create dynamic view with the help of MDX?
Replies: 6
Views: 1488

Re: How to create dynamic view with the help of MDX?

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...
by Mark RMBC
Tue Aug 27, 2019 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW not working after network changes
Replies: 35
Views: 8898

Re: PAW not working after network changes

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...
by Mark RMBC
Fri Aug 23, 2019 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW not working after network changes
Replies: 35
Views: 8898

Re: PAW not working after network changes

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
by Mark RMBC
Thu Aug 22, 2019 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW not working after network changes
Replies: 35
Views: 8898

Re: PAW not working after network changes

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...
by Mark RMBC
Thu Aug 22, 2019 12:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW not working after network changes
Replies: 35
Views: 8898

Re: PAW not working after network changes

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...
by Mark RMBC
Tue Aug 20, 2019 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW is not creating any containers in windows after installing 2.0.44
Replies: 7
Views: 1922

Re: PAW is not creating any containers in windows after installing 2.0.44

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?
by Mark RMBC
Thu Aug 01, 2019 5:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 3118

Re: Dynamic query argument in TI...

Hi,

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

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

cheers, Mark
by Mark RMBC
Fri Jul 26, 2019 10:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Piclists in Perspectives
Replies: 13
Views: 1012

Re: Piclists in Perspectives

Hi,

is there an hidden sheet called picklist in the one that isn't working?
by Mark RMBC
Thu Jul 11, 2019 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandboxes in Dynamic Reports?
Replies: 8
Views: 407

Re: Sandboxes in Dynamic Reports?

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!
by Mark RMBC
Thu Jul 11, 2019 9:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to change JVM setting on TM1Web
Replies: 6
Views: 332

Re: Unable to change JVM setting on TM1Web

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
by Mark RMBC
Wed Jul 10, 2019 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 17
Views: 3437

Re: Updating Element Attributes in TI Process

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 , '' )...
by Mark RMBC
Mon Jul 01, 2019 4:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service holding open ODBC?
Replies: 7
Views: 478

Re: TM1 service holding open ODBC?

No problem and thanks for the advice!
by Mark RMBC
Mon Jul 01, 2019 2:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service holding open ODBC?
Replies: 7
Views: 478

Re: TM1 service holding open ODBC?

Hi Bakkone,

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

I presume JIm had something else in mind?

cheers, Mark
by Mark RMBC
Mon Jul 01, 2019 1:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service holding open ODBC?
Replies: 7
Views: 478

Re: TM1 service holding open ODBC?

Hi Jim, thanks for the reply.

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

cheers, Mark
by Mark RMBC
Mon Jul 01, 2019 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service holding open ODBC?
Replies: 7
Views: 478

TM1 service holding open ODBC?

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