Cognos Analytics

Cognos Analytics

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

 View Only
Expand all | Collapse all

Permissions: wow to edit a dashboard but not save it at current location

  • 1.  Permissions: wow to edit a dashboard but not save it at current location

    Posted Wed October 16, 2024 05:56 AM

    Hey!

    In my Cognos environment we have a set of user roles which have no direct access to packages & datamodules. To give them the ability to create user-defined reports or dashboards, I've created reports and dashboards in a distinct folder per data source. These reports and dashboards then have some tweaked settings like color palettes, styles, local classes, and pre-applied data containers. The users should have the ability to open these objects and start modifying them based on the data they find in there already.

    With reports all is fine. The users have the "run" permission for that folder and can also enable the edit mode and modify the reports. BUT they cannot save their modifications to the reports in that folder in Team content. They have to save them in their "My content" or somewhere else I gave the write permission.

    Unfortunately, this does not work for dashboards. If a user has only run permissions, the edit mode cannot be activated as the toggle switch is inactive. It is necessary to have write permission to be able to toggle the switch.

    Does anyone has an idea if it's possible to set certain permissions on the dashboards so users can enter the edit mode but cannot save into the current location and forced to choose a different folder in Cognos?



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------


  • 2.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Mon October 21, 2024 12:20 PM

    There is a way, but it requires implementing an Extension which will modify the Dashboard toolbar for the Restricted users.

    The extension will remove the default Save Menu button.

    Restricted users should have Permission Run on the Folder where the Dashboards are.

    But for Each Dashboard they should have permission Write.

    Then they Can start editing but will not have an option to Save, only Save As.



    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------



  • 3.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Tue October 22, 2024 02:15 AM

    Hi Andrei,

    sounds good, but it's not a solution for me as this would remove the "save2 button globally on all dashboards for these users. I just want to remove it from certain dashboards - not all.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------



  • 4.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Tue October 22, 2024 08:30 AM
    Edited by Andrei Istomine Tue October 22, 2024 08:43 AM

    >this would remove the "save2 button globally on all dashboards for these users.

    It's possible to restrict an extension for certain User groups only.

    >I just want to remove it from certain dashboards - not all.

    This extension can be implemented as a non-visible Custom Widget. 

    Though, in any case implementing an extension is an overkill since users can always Save the Dashboard first and then Edit.



    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------



  • 5.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Tue October 22, 2024 08:47 AM

    Hi Andrei,

    once again. We don't understand each other. I know that an extension can be secured so it applies only for certain user groups only. But I DON'T want to remove the button on a group level. If I would upload that extension, then the "save" button will beremoved for theses users for all dashboards. It's just these special dashboards that should not be able to overwrite at their current location - not all dashboards..

    I don't understand why IBM has implementd this in two ways. One for reports (which works) and one for Dashboad (which doesn't).



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------



  • 6.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Tue October 22, 2024 09:03 AM
    Edited by Andrei Istomine Tue October 22, 2024 09:02 AM

    All makes sense. The Cognos Dashboard functionality has lots of room for improvement. :-)

    >If I would upload that extension, then the "save" button will be removed for theses users for all dashboards. It's just these special dashboards that should not be able to overwrite at their current location - not all dashboards..

    If this Extension is a Custom Widget, it will remove the Save button only for Dashboards where it is added explicitly



    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------



  • 7.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Tue October 29, 2024 12:47 PM
    Edited by Philipp Hornung Tue October 29, 2024 01:03 PM

    Hi Robert,

    You probably thought of it as well and I haven't tried, but what if you make a dashboard read-only and the user needs to copy it for editing? -> OK, I see from your parallel CUG post that you don't want this :-)

    Best regards

    Philipp

    P.S. I hope I will see you in Frankfurt



    ------------------------------
    Philipp Hornung
    Product Owner & BI Manager
    Techniker Krankenkasse
    Hamburg Germany
    #IBMChampion
    ------------------------------



  • 8.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Wed October 30, 2024 01:30 AM

    Moin Philipp,

    actually that's the quirk I wanna get away from. Users constantly keep asking me why the heck they can go directly into edit mode for reports but not for dashboards in the same location. But I see: IBM has just implemented it in two different ways and there's no way around it.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------



  • 9.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Wed October 30, 2024 03:49 AM

    Hi Robert,

    Users in my organization totally recognize your issue and so I opened a case for this at IBM Support. Their reply was: "Please note that these are entirely different reports and dashboards. And so are the capabilities granting access to them. And there are a lot more options with report capabilities than the dashboard more details here (under dashboard and report studio ). So, will advise not to compare."

    This answer doesn't solve the issue but only gives a technical explanation.

    From an Analytics User functional perspective however, this makes no sense at all.

    I could do nothing other than vote up to an existing idea and tell others to do so too. It is: https://ibm-data-and-ai.ideas.ibm.com/ideas/CA-I-4295 "Allow for customisations to Dashboard to allow for users to edit but not save".

    Marc



    ------------------------------
    Marc van Waardenburg
    ------------------------------



  • 10.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Wed October 30, 2024 04:20 AM

    Hi Marc,

    I voted for the idea as well. THX.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------



  • 11.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Mon November 04, 2024 08:18 AM

    So in our setup the data sources are in a different folder structure than the dashboards themselves which the allows you to do this.

    • The data source needs the user to have write access in order for the user to be able to use the edit button.
    • Placing the dashboard outside the datasource package folder allows you to then just give them run access.
    • The will be able to use edit but unable to save to that specific folder or overwrite the dashboard you originallly created and forced to save to another folder (preferably my content or shared folder)
    • Downsides , the data source folder can be saved to but they have to navigate there to find it
      • When building a new dashboard they have to navigate there to select the Datasource.


    ------------------------------
    Chris Stadler
    ------------------------------



  • 12.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Fri November 22, 2024 06:48 AM

    Hi @Chris Stadler,

    actually this is already my setup: data sources (packages) are placed in one hidden folder and the dashboards are in another one. I tested your approach and gave the users write access to the data sources and only run rights for the dashboard. They are still not able to edit the dashboard at the stored location. The toggle switch is deactivated and can't be clicked. :-(

    Is there anything you may have done else?



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------



  • 13.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Mon November 25, 2024 12:40 PM

    Actually I am wrong.  This used to work this way until like 11.1.7, now they have to press save first and save it to their personal folder before it lets them edit.  It has been a while since we had any questions about this and I forgot about that change sorry for the confusion.



    ------------------------------
    Chris Stadler
    ------------------------------



  • 14.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Fri November 22, 2024 10:43 AM

    Hi Robert,

    workaround: if you put ReportIDs and Usernames in the extension, you could then programmatically decide to hide or display the save.

    Anyhow, this would mean maintenance over time. 

    Upvoted your idea.



    ------------------------------
    Ralf Roeber
    https://linkedin.com/in/ralf-roeber/
    ------------------------------



  • 15.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Mon November 25, 2024 12:02 PM

    Hi Robert, 

    Unfortunately I have no longer administrative capabilties and can't check myself. But I'm thinking of advanced folder capabilities regarding dashboarding for the dashboard folder and/or the data source folder. Maybe there is a configuration that meets your requirements. 

    Best regards

    Philipp



    ------------------------------
    Philipp Hornung
    Product Owner & BI Manager
    Techniker Krankenkasse
    Hamburg Germany
    #IBMChampion
    ------------------------------



  • 16.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Mon November 25, 2024 03:46 PM

    @Robert Dostal

    Unfortunately, the custom extension will not work b/c users can simply access Cognos with the option "factoryMode=true"   to disable the extension...



    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------



  • 17.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Tue November 26, 2024 05:24 AM

    Thank you all for your suggestions. It is just not possible to have the same settings for dashboards like with reports... Thanks IBM for nothing - again.

    The users will have to copy the dashbopard to another location before they can enable the edit mode.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------



  • 18.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Wed November 27, 2024 06:25 AM

    If users has run permissions, they cannot edit, but they can use Save As button.

    For my understanding, is the behavior that you are looking, the ability to save dashboard in other place.



    ------------------------------
    JEAM COELHO
    Cognos Solution Architect

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------



  • 19.  RE: Permissions: wow to edit a dashboard but not save it at current location

    Posted Wed November 27, 2024 06:50 AM

    Hi Jeam,

    yes, if users have only run permissions, they cannot enable the edit mode for dashboards (but for reports). They have to do a "Save as..." before being able to edit the dashboard. Plus: they have to close the dashboard after saving it somewhere else coz the system does not capture the changed permissions on the fly. They then have to navigate to the other location (my content) and open it a second time. That's why they find the whole process cumbersome.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------