Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Multi Tenancy Beyond Folder

    Posted Wed October 09, 2019 09:20 AM
    We have a requirement to connect CA to a SQL database dataserver connection.
    Our SQL datawarehouse uses schema based multitenancy. 

    How is it possible for our end clients to connect to the same instance of CA and use the same reports and folders but have the reports only connect and display data from their particulcar SQL schema.



    ------------------------------
    Jonathan berry
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Multi Tenancy Beyond Folder

    Posted Thu October 10, 2019 09:45 AM
    Hi Jonathan,

    One way you can do it is to leave the Database name blank and add something  like this into the connection parameters. This example will replace DATABASE with your user name.

    DATABASE=#toupper($account.defaultName)#

    I don't know what you would use but I'd suggest testing with FM to see what specific parameter and/or macro is right for you. 

    Another potential solution could be using Command Blocks.

    ------------------------------
    TREVOR COMEAU
    ------------------------------

    Original Message


  • 3.  RE: Multi Tenancy Beyond Folder

    Posted Thu October 10, 2019 03:39 PM
    You can also add macros to the datasources in Framework Manager if you are using published models.

    ------------------------------
    TREVOR COMEAU
    ------------------------------

    Original Message


Related Content