how to connect PAfe client to TM1 Server directly via RestAPI?

[wang_chris]

TM1 Admin server and TM1 Server are run on my local machine (windows), there is no PAW installed.

I run PAfe client (pa_excel_2.0.91_64b_win_ml.xll) with excel, and can see 'IBM Planning Analytics' panel appear on excel command bar. But when I tried to create a new connection to TM1 server with below setting:

Code: Select all

   
    Data Source Type: IBM Planning Analytics
    Connection URL: https://localhost:12662/api/v1       # (12662 is defined in my tm1s.cfg as HTTPPortNumber)
    Friendly Name: a

the connection test returns success. However, when I saved this connection and make a real connection with it, system reported an error with below message "can not find below webpage: https://localhost:12662/api/?ttps://loc ... 662/api/v1". I don't know why it repeats my input URL.

I can get json information return when I input URL "https://localhost:12662/api/v1/Configuration" on the browser directly. and my tm1s.cfg setting as below:

Code: Select all

    
    IntegratedSecurityMode=1
    UseSSL=T
    AdminHost=127.0.0.1
    PortNumber=12660
    ClientMessagePortNumber=12661
    HTTPPortNumber=12662

My question is
1) can PAfe directly connect to TM1 Server by RestAPI without PAW?
2) if above solution works, how should I set the connection URL? and should other parameters be set?

[Steve Rowe]

Hi Chris,
I'm afraid it is not possible to connect PAfE direct to the TM1 DB, it must go via PAW.

[Adam]

To elaborate a bit more, all the screens for cube viewer and set editor are webview2 screens from PAW. Without PAW, PAFE is not usable.