Cloud Pak for Data

Cloud Pak for Data

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
  • 1.  Connection to IBM Planning Analytics on cloud

    Posted Thu September 29, 2022 02:08 PM

    Hi all,

    I am trying unsuccessfully to set up a connection to IBM Planning Analytics on cloud.

    In some project, I set up a new asset, then a connection, and then select IBM Planning Analytics.

    The connection details are like this:

    Select test connection and:

    Now, on the same project, I set up another asset, a Jupiter Notebook that goes like this:

    Cell 1:

    # install TM1Py library

    !pip install TM1py

    Run ok.

     

    Cell 2:

    from TM1py import TM1Service
     
    tm1 = TM1Service(
            base_url='https://kcmdev.planning-analytics.ibmcloud.com/tm1/api/mytm1db',
            user="someuser",
            namespace="LDAP",
            password="somepassword",
            ssl=True,
            verify=True,
            async_requests_mode=True)
    Run ok.

     

    Cell 3:

    # Read all cubes and print cube names
    tm1.cubes.get_all_names()

    And I get all the cube's names.

     

    I will appreciate any suggestions or guidance for setting up the connection.

    Thanks.



    ------------------------------
    Jose Luis Senas
    Data Analyst
    Kimberly-Clark Mexico
    Mexico City
    ------------------------------

    #CloudPakforDataGroup


  • 2.  RE: Connection to IBM Planning Analytics on cloud

    Posted Thu September 29, 2022 04:19 PM
    Hi Jose!
    I am not the person to answer your question, but I have forwarded it to a few folks who should be able to help you. I have asked them to respond to you here.

    ------------------------------
    Karen Gonzalez
    ------------------------------



  • 3.  RE: Connection to IBM Planning Analytics on cloud

    Posted Fri September 30, 2022 09:24 AM
    You can try to add api/v1/ at the end of the TM1 Server API root URL, such as:  https://kcmdev.planning-analytics.ibmcloud.com/tm1/api/mytm1db/api/v1/.

    ------------------------------
    Yi Li
    ------------------------------



  • 4.  RE: Connection to IBM Planning Analytics on cloud

    Posted Fri September 30, 2022 05:07 PM
    Hi Yi Li,
    Changing TM1 Server API root URL to https://kcmdev.planning-analytics.ibmcloud.com/tm1/api/mytm1db/api/v1/ worked all right.


    Thanks!

    Next step, to import cube data into CPD.

    Best regards.


    ------------------------------
    Jose Luis Senas
    Data Analyst
    Kimberly-Clark Mexico
    Mexico City
    ------------------------------