Cognos Analytics

Expand all | Collapse all

Cognos on cloud

  • 1.  Cognos on cloud

    Posted Thu March 25, 2021 06:22 PM
    I purchased Cognos on cloud a week ago, but I have a problem with the Cognos login interface, I cannot find the new "Report" feature, nor the "administration consol" in "manage". i wrote an IBM but it didn't fix the problem. someone a slvp solution? thank you


  • 2.  RE: Cognos on cloud

    Posted Fri March 26, 2021 01:42 AM
    Hello Hachemi

    Which cloud license did you purchase?  Reports only available in the Premium license.

    Also, there is no Administration tab in the Cloud version, as far as I am aware.  What did you want to do in Admin?

    Cheers
    Gill

    ------------------------------
    Gill Staniland
    ------------------------------



  • 3.  RE: Cognos on cloud

    Posted Fri March 26, 2021 02:47 AM
    Hi,

    I assume you are talking about Cognos on Demand? In this case, it depends on the license subscription you have choosen ( which you can change at all time). Only premium covers the reporting feature. in all cases you will not have the legacy "administration console" the admin options are limited to what is available under "manage" ( note that this is a SaaS service and IBM take care of most admin tasks)

    hope this clarifies

    Peter

    ------------------------------
    Peter D'Haeyer
    ------------------------------



  • 4.  RE: Cognos on cloud

    Posted Fri March 26, 2021 01:16 PM

    Hi, Thank you for your reply, this is what I bought: IBM Cognos Analytics on Cloud Standard Authorized User per Month.
    I can't do nothing with this,
    I played  17,80 € for nothing,






  • 5.  RE: Cognos on cloud

    Posted Fri March 26, 2021 01:31 PM
    Hi 

    With the Standard license, you can create Dashboards which include all sorts of visualisations, connect to many data sources, upload flat files, create data models.

    Quite a bit.  What do you need to be able to do?


    ------------------------------
    Heather Staniland
    ------------------------------



  • 6.  RE: Cognos on cloud

    Posted Fri March 26, 2021 02:59 PM
    Thank you very much for the answers, I also wante to know why I was unable to connect to a sql server database? Thank you






  • 7.  RE: Cognos on cloud

    Posted Fri March 26, 2021 03:10 PM
    Hi Hachemi

    Is you SQL Server DB on prem?  If so, you will probably need to set up a Secure Gateway, to be able to connect Cognos Cloud to SQL on prem.

    Go to Manage > Secure Gateways.  But first read this to check how to do that: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_ca_manage_secure_gateway_installing.html

    Once you have a secure gateway connection to the SQL Server, you can go to Manage > Data Server Connection and add a SQL connection.  Here is an example connection string that we have setup: jdbc:sqlserver://HELLO-PC:1433;Database=NPC2;

    Hope that helps

    ------------------------------
    Heather Staniland
    ------------------------------



  • 8.  RE: Cognos on cloud

    Posted Fri March 26, 2021 04:46 PM
    Hi Heather, 
    My SQL server is not Premium, 
    Must have Sql server premium to connect To Cognos Analytics? , 
    Thank you very much 





  • 9.  RE: Cognos on cloud

    Posted Sat March 27, 2021 12:31 AM
    Hi
    i meant is your Sql Server on Premise ? (ie not in the cloud) 
    Any version of Sql server is fine.

    ------------------------------
    Heather Staniland
    ------------------------------



  • 10.  RE: Cognos on cloud

    Posted Sat March 27, 2021 03:47 AM
    Hi Heather,
    My SQL server is not on cloud, it is installed in my computer.






  • 11.  RE: Cognos on cloud

    Posted Sat March 27, 2021 04:50 AM
    OK. then you need to follow this process to create a bridge between the Cloud (Cognos on Demand) and your computer:

    https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_ca_manage_secure_gateway.html

    ------------------------------
    Heather Staniland
    ------------------------------



  • 12.  RE: Cognos on cloud

    Posted Sat March 27, 2021 06:39 AM
    Yes, this is what I want to do,
    Thank you very much 






  • 13.  RE: Cognos on cloud

    Posted Mon March 29, 2021 04:14 AM
    Hi Heather,
    I noticed that the Secure Gateway is being deprecated. See links below: 
    https://cloud.ibm.com/docs/SecureGateway?topic=SecureGateway-client-requirements
    https://www.ibm.com/cloud/blog/ibm-cloud-secure-gateway-deprecation

    ------------------------------
    Thomas van der Meer
    ------------------------------



  • 14.  RE: Cognos on cloud

    Posted Mon March 29, 2021 12:43 PM
    Thanky you very much Heather






  • 15.  RE: Cognos on cloud

    Posted Thu April 08, 2021 10:32 AM
    Make sure you have the Premium edition to expect Reports to be a feature.  We ran into that.  The regular plan only allows Dashboard development.


    ------------------------------
    Marcus Hogins
    ------------------------------



  • 16.  RE: Cognos on cloud

    Posted Thu April 08, 2021 10:42 AM
    I did not purchase the Premium Edition, 

    Thank you sir,

    Cordially,