Cognos Analytics

 View Only
  • 1.  Cannot Edit Queries in Report Studio 11.0.4

    Posted Thu April 25, 2019 10:51 AM
    Hello. I'm fairly new to Cognos.

    We have 11.0.4 installed, but any time I try to edit a query, the option is grayed out. Any idea why? I've tried various data modules from different data sources, but still no good.

    Additionally, I do not see the option to add drill-throughs when i right click a column in a data list (not sure if that's related).

    Thanks in advance.

    ------------------------------
    Sahil
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cannot Edit Queries in Report Studio 11.0.4

    Posted Thu April 25, 2019 11:24 AM
    ​The proper capabilities may not be enabled for your user id.
    Please check with your cognos admin on your capabilities.

    You can also check the available capabilities in my preference


    ------------------------------
    Babu Periassamy
    ------------------------------



  • 3.  RE: Cannot Edit Queries in Report Studio 11.0.4

    Posted Thu April 25, 2019 12:26 PM
    Oddly enough i am the admin. It's a testing/training environment. Is there any possibility that the installation was incorrect or I have capabilities not turned on? Below are the capabilities listed (i see drill through btw).

    Administration
    Administration tasks 
    Configure and manage the system 
    Data Source Connections 
    Distribution Lists and Contacts 
    Mobile Administration 
    Printers 
    Query Service Administration 
    Run activities and schedules 
    Set capabilities and manage UI profiles Styles and portlets 
    Users, Groups, and Roles 
    Analysis Studio 
    Cognos Insight 
    Cognos Viewer 
    Context Menu 
    Run With Options 
    Selection 
    Toolbar Collaborate
     Allow collaboration features 
    Launch collaboration tools 
    Dashboard 
    Data Manager 
    Data sets 
    Detailed Errors 
    Drill Through Assistant 
    Event Studio
    Executive Dashboard
    Use Advanced Dashboard Features
    Use Interactive Dashboard Features
    External Repositories
    Manage repository connections
    View external documents
    Generate CSV Output
    Generate PDF Output
    Generate XLS Output
    Generate XML Output
    Glossary
    Hide Entries
    Import relational metadata
    Lineage
    Manage content
    Manage own data source signons
    Mobile
    Query Studio
    Advanced
    Create
    Report Studio
    Allow External Data
    Bursting
    Create/Delete
    HTML Items in Report
    User Defined SQL
    Scheduling
    Schedule by day
    Schedule by hour
    Schedule by minute
    Schedule by month
    Schedule by trigger
    Schedule by week
    Schedule by year
    Scheduling Priority
    Self Service Package Wizard
    Set Entry-Specific Capabilities
    Snapshots
    Specification Execution
    Upload files
    Watch Rules
    Web-based modeling

    ------------------------------
    Sahil Patel
    ------------------------------



  • 4.  RE: Cannot Edit Queries in Report Studio 11.0.4

    Posted Thu April 25, 2019 01:53 PM
    @Sahil Patel - You are on an old version of Cognos Analytics. Our latest release for 11.0.x code stream is 11.0.13. Cognos Analytics 11.1.1 is also available.

    If I recall correctly, the option to edit queries built off of a data module came in a later release.   ​Let me test and get back to you. Unless you have a more recent version of Cognos Analytics.

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 5.  RE: Cannot Edit Queries in Report Studio 11.0.4

    Posted Thu April 25, 2019 01:58 PM
    Hey Denny,

    That would be perfect! I've been trying to verify that myself but haven't been able to. For right now, this is all I have access to (just temporary for training purposes).

    Thanks in advance.

    ------------------------------
    Sahil Patel
    ------------------------------



  • 6.  RE: Cannot Edit Queries in Report Studio 11.0.4

    Posted Thu April 25, 2019 02:16 PM
    @Sahil Patel I just quickly tested against my 11.0.4 and you cannot make direct edits to queries that are sourced from a data module. I'm not sure of the exact version where this was changed, but I can confirm in 11.0.13 and 11.1.1 you can make edits to queries sourced from a data module.


    ------------------------------
    DENNY NAREZNY
    ------------------------------