Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Hide show sql generated

    Posted Sat September 25, 2021 08:29 AM
    Hi,
    Is it possible to hide the Show Generated sql property?

    Thanks

    ------------------------------
    Magnum BI

    https://www.linkedin.com/in/magnum-bi-0297a2214
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Hide show sql generated

    Posted Mon September 27, 2021 07:20 AM
    Hi Magnum,

    Are you referring to this entry in Authoring? Just want to make sure we're on the same page.



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



  • 3.  RE: Hide show sql generated

    Posted Mon September 27, 2021 07:40 AM

    Hi Magnum,

    that's a very good question... I'd also like to know if it's possible but I assume it will be tweaking some local files in the install location. I couldn't find any way in the "Manage" section.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------



  • 4.  RE: Hide show sql generated

    Posted Mon September 27, 2021 03:33 PM
    Hi,
    Yes i don't want for security reasons that my users are able to see the sql of report and his queries.
    Is it handle this?

    ------------------------------
    Magnum BI

    https://www.linkedin.com/in/magnum-bi-0297a2214
    ------------------------------



  • 5.  RE: Hide show sql generated

    Posted Wed September 29, 2021 03:32 PM
    Thank you Trevor for sharing this solution...but i need a more easy way.this would be a good features to have for a new cognos release.

    Robert, I am full of good ideas for cognos... follow me and support me;)

    ------------------------------
    Magnum BI

    https://www.linkedin.com/in/magnum-bi-0297a2214
    ------------------------------



  • 6.  RE: Hide show sql generated

    Posted Wed September 29, 2021 03:36 PM
    The following message has been sent to you in response to your discussion message.

    View inbox and reply to the message online

    Message From: TREVOR COMEAU

    Hi Magnum,

    This is entirely unsupported and could change with a UI update. I think this will remove the SQL option for all users.

    ..\webcontent\pat\profiles\profile_titan.xml

    <RSProfile xmlns="http://www.ibm.com/xmlns/prod/ba/rs/rsprofile.1/">

    <propertySheets>
    <propertySheet id="PropertySheetMain">
    <propertyVisibility action="hide">
    <property name="generatedSQL" />
    </propertyVisibility>
    </propertySheet>
    </propertySheets>
    </RSProfile>

    I am not sure if I want to publish this publicly yet as it is a bit of a hack.

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

    ------------------------------
    Magnum BI

    https://www.linkedin.com/in/magnum-bi-0297a2214
    ------------------------------



  • 7.  RE: Hide show sql generated

    Posted Fri October 01, 2021 08:11 AM
    Hi Magnum,

    I've confirmed that there is no native functionality for what you require.

    An enhancement for this scenario has been opened. 

    Cheers,
    Trevor

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