Cognos Not In List

Looking for Cognos TM1 Interview Questions with Answers? Here we have compiled set of questions from the students who have attended interviews in Fortune 500 companies. The script will create a namespace folder (if needed) in the Cognos Namespace to store the groups. Filters and prompts can be configured using native SharePoint filter web parts. Select & Search in Cognos 10. When you make changes to a report in one folder, those changes are not reflected in copies of the report in other folders. Cognos Customer List. Under the Count column, highlight the item. i have 12 queries to perform Not in , and i have to aplly this filter all in 12 queries, then only i get distinct location numbers. Export Cognos report into Excel & PDF using Buttons Deployment of Public Folder/Reports/Package in Cognos Value of Optional Prompt if you entered anything or not. A sample Problem statement taken up in this blog illustrates the idea which can then be extrapolated to other such similar scenarios. Solution: Logos are copied to only gateway web contents. Cognos News Hub by Influential: IBM Cognos partners. It is (temporarily) broken. This feature is not natively found in Cognos, please see the below steps to help you create a report with with frozen panes. Subscribing to Cognos-Student-Consumer. I want to align in such a way that when report has run the output should be like one list. For example, a list shows all products in your product line. However, some areas such as the auditing of users and capability assignments are not included. In this video I will show you how to - * Setting up a report for bursting with a distribution list from the database * Running the burst report * Setting up a distribution list with a data element. This is fine for most situations, but the ability to navigate through an LDAP or AD tree is not. Also validating the object did not work. Set the following criteria: Conditions to either Show all the following values: or Do NOT show the following values. Crosstab reports in Cognos are used to display summary values. You might have faced the challenged aligning radio button prompt horizontally as Cognos do not support this behaviour. Go to System Administration. It is not supported for use with any developer edition. How to call the user defined function in cognos. any other ways of implementing logic. This list contains functions that can be used within a macro. In Cognos 10 and previous there were three ways of getting data into a JavaScript Object. Starting with an overview of high-level architecture and installation of Cognos 10 Report Studio , you will progress from building simple to advanced List and Crosstab reports and much more. A comprehensive list of defect corrections for major releases, refresh packs and fix packs of Cognos Analytics 11. The schedule requires you to set the default values for the prompt. To display a row we are testing for a row is not equal to zero. For the IBM Cognos Analytics (ICA) 11. Cognos Report Studio User Guide 6 December 2011 3. Steps: Open the previous saved sample report "mylist" in Report Studio. This has, needless to say, infuriated quite a few users. This approach helps users spot patterns and behavior that might otherwise not be. 9 COGNOS Analytics February 2018 For additional information regarding Cognos, policies and access, or modifications to. Cascading style picklist in IBM Cognos TM1 This neat trick shows you how to create a cascading style picklist in Cognos TM1. Some clients expose portions of their platform to the public, safe in the knowledge that users can only see what they're allowed to see. The CellPutN function needs the variables in the order of the cube's dimensions. For information on accessibility features that are available in Cognos Connection, see “Accessibility features,” on page 193. Usage of Cognos Statistics is available in most tools that are used to create reports and dashboards in C10. We have seen that cognos macro functions available in framework manager are also available in report studio. For one, Cognos and crosstabs are an unhappy couple. Macros allow you to alter SQL/MDX before it’s send to the datasource. Run the report to see the result: Enhancements: When you run the report you wil only see the ordernumber in the header of the section. The class ends with a discussion of how to trouble-shoot problems experienced with Cognos. Note the Filter Indicator in the header of the report. But during installation of Framework8. One of the challenging report requirement is to have automatic filters in Cognos report for an excel output report ,The purpose of this post is to illustrate the trick of adding automatic filters in an Excel output report The following are the required steps 1) Build a simple list report. 2 Workspace Advanced, we are starting to see at Lodestar an influx of Workspace Advanced "how to" questions. BI consultancy delivering results since 1993 | Fully-integrated Cognos BI solutions, Licences & Training. Cognos List lessons. Hi, i have to filter a list and a chart using values in drop down list. We will build the TI process to not only copy the cube data but also build the dimensions in the 1st server. In this example, the only folder higher that UCPath Reporting folder is the Team content folder. Note that you can set a default value for this parameter in the report properties page and tell the Cognos Viewer not to prompt for values if you want. Click the drop down list from the Filter button. Though it is not possible to achieve this using Cognos list properties, we can achieve this using a simple JS script. This is infuriating. Cognos Analytics ships with Websphere Liberty as the application server. Filters and prompts can be configured using native SharePoint filter web parts. This data item will not be be used in the report but will act as filter in the underlying query. For the IBM Cognos Analytics (ICA) 11. While running report, logo images are visible in html and when try to download in pdf/excel output, logo image is not available. Filters and its types in Cognos Filter: It is nothing but a condition to restrict the data to be displayed on the report. save it and run the report , in cognos viewer you can see the o/p of the simple list report. IllinoisState. 3 portal/UI, the “default action” when clicking on a report is dependent on whether the report is configured as a (new for ICA 11) “interactive” report vs. In addition to the preformatted standard reports, Argus Insight provides the Report Writer tool that you can use to create custom reports for ad hoc/special reporting requirements. How do yourestrict one user can see only the list and the other user can see both? Ans: Create a variable to check which user is logged in uning the session parameter (eg. Its sorts month as April,Aug, Feb, Jan, instead of Jan, Feb, March, April, For sorting months in its natural order, we have to make a way around the sorting of Cognos. So, as a public service, I will post them here. If you have a fact that is non numeric, the report will be blank. The schedule requires you to set the default values for the prompt. The report works when I do not have this in as an expression. This list contains functions that can be used within a macro. And while you can open up each one in the admin console, you have to drill down through multi-level menus to get any needed information. Cognos 10. A Studio is a user interface for a specific group of users. How to use Rank function in Cognos Report Studio? RAVI MAHAZAN 09:19 Report Studio No Comments There will be scenario when you need to display Top records in your Cognos report. When creating a report, to add a scroll bar to a list prevent the list to accompany multiple pages use 'scrollable area height' List property to enable it. So here is the fix list for 11. 3 Fix List July 22, 2019 | cognospaul The APARs have been updated, and the search index re-indexed, and the 11. Number of results to show per page. You can also change an existing report and save it with different nam. IBM Cognos Framework Manager IBM Cognos Framework Manager is the data modeling tool for IBM Cognos Business Intelligence. ) and others which do not, such as the ability to Schedule objects. I expected this because <> conditions is very slow when compared with not in or not exists. IBM Cognos Framework Manager is the metadata model development environment for IBM Cognos BI. So, as a public service, I will post them here. The drop down list is populated with static values of data item. Then you'll see a list of all the query items for the query associated with the layout. 4, it is now possible to customize an IBM Cognos Analytics on Cloud account. The report works when I do not have this in as an expression. List”; then your choice of departments will appear. In Cognos you can create or modify queries with the help of Query Explorer. A macro may contain one or more macro functions. You will not have functionality under the My Content folder because your profile is not defined to support that feature. Finding Content. COGNOS Creating Headers and Footers Headers and footers are containers where you can add objects such as text, images and report expressions. Click on the Format drop down list and choose a format. I'm not sure if that can be done easily as the crosstab has all address lines above the columns that is not in the list heading. 2 Answers are available for this question. Today's top 70 Ibm Cognos jobs in India. I came across a forum post where someone wanted to use SQL NOT LIKE with multiple values. Under the Count column, highlight the item. Note the Filter Indicator in the header of the report. The report is running very slow. query 1 not in (query 2) query 1 not in (query 3) query 1 not in (query 4) upto query 1 not in (query 12). In Cognos it is possible to group. It is not supported for use with any developer edition. The second way is to dump everything into a list, but then we need to loop through a table - slow and annoying. Select Crosstab as type of the report and click OK. This blog features articles and tips and techniques on Cognos, Business Intelligence and Business Analytics directly from industry experts and Cognos users. A classic example of this is an aggregation of Gross Margin %, which is calculated as Gross Margin/Revenue. While Cognos makes it possible to see details on upcoming scheduled reports these are presented simply as a list of upcoming scheduled objects. Details of the APARs listed below can be accessed by clicking the link for the APAR number. All the web and windows tools need to have access to the IBM Cognos gateway. Best of all the since the code is not compiled into an SDK application you can easily update it when your requirements change. These are not discussed in this document. 2 and later. The field validation on this page is not allowing me to paste it,but I have followed the same as u suggested by taking four HTML items and pasted the same code in there and placed as suggest. If you have accessed the package in the past, select it by clicking on the link on the top of the screen. They were trying to exclude multiple values from the SQL query, but they were needing to use wildcards. For one, Cognos and crosstabs are an unhappy couple. Select the column to filter by. The reason is,, if password is expired of the user whoever scheduled the job, then Cognos schedules stop working, Resolution:. Return to Cognos Report Studio topics menu. 3 failed to start! Review the Content Manager log files and then contact your system administrator or customer support. COGNOS Advanced Sorting in Report Studio This document covers how to create customized sort data items. union & minuns not good idea. *The source for an Event Studio agent is a package published in your Cognos Connection environment. In the new version of Cognos Analytics (Cognos 11), sorting is an out of the box feature. Because Excel is capable of running macros on execution, this is a "Pop Up" issue and not a Cognos issue. How to add a 'count' for the number of rows in a list report in the report header. List Cognos dispatchers configured as standby Content Managers after the above. In every new release of Cognos, there are some ups, and there are some downs. Make the checkbox against "Use Legacy chart Authoring" checked iv. Select Crosstab as type of the report and click OK. This allows you to control all your content using a single prompt. The username and password that you use to login into windows can also be used to login into Cognos. Consultez le profil complet sur LinkedIn et découvrez les relations de Rasheed, ainsi que des emplois dans des entreprises similaires. * Heat maps are not compatible with IBM Cognos running in Internet Explorer. Cognos displays the list of folders within the navigation path. IBM Cognos BI Training Centers in Radford, VA – List of IBM Cognos BI certification training, classes, Institutes in Radford, Know more about IBM Cognos BI fees details, class timings, course details, contact addresses and phone numbers on Sulekha IT Training. On the left panel > Properties > Conditional > Click on Conditional styles. Insert dataitems in the list. By Eric Soden. I want to align in such a way that when report has run the output should be like one list. Lauria’s class. union & minuns not good idea. One specific scenario when an employee leaves that causes a great deal of extra work on IBM Cognos administrators involves the ex-employee's scheduled jobs, reports, etc. List not aggregating correctly in cognos 8. A test cube, which I created “SK_Cube1” is missing in the SPSS list. COGNOS - Using List of Values 1 November 2010 COGNOS Using List of Values Using a List of Values when creating a Prompt Page in Cognos will make your report run faster because it is not looking at the actual table for the values for the prompt, it is simply looking at a list of the codes (values) that are available for that table. IBM Cognos Workspace Advanced Version 10. Cognos scripting: You can use the Cognos Script editor, or any other OLE compliant editor to create, modify, compile, and run macros. For this example, we are using the GO Sales (Query) package and a list report. In Report Studio,which is the most appropriate report type?. Phew, problem solved! Now I will never have to see that *beep* border in Cognos prompts again. Découvrez le profil de Rasheed Waraich sur LinkedIn, la plus grande communauté professionnelle au monde. Welcome to the Unofficial Cognos Training blog sponsored by PerformanceG2- a Premier IBM Cognos Business Partner, and industry resource. We have seen that cognos macro functions available in framework manager are also available in report studio. But during installation of Framework8. Esri Maps for IBM Cognos is supported for use with IBM Cognos Enterprise and IBM Cognos Express 10. Using this portal, content can be searched in the form of reports, scorecards and agents, it can be managed, structured and displayed. Not doing much, but let’s say that we want a list to magically appear, filtered based on wherever the user is hovering. Here is a simple list of existing Cognos Macro with description. The mission of APSCN is to provide all Arkansas public. So here is the fix list for 11. For the IBM Cognos Analytics (ICA) 11. The report works when I do not have this in as an expression. This will display the various SQLs that Cognos would fire against the DB and here's where you would notice that even if you have multiple objects. If you use your named departmental folder instead, the reports will be unique to that department. Beginning Professional Report Authoring with IBM Cognos Analytics is a two-day, instructor-led, online course. I am using cognos report sudio 8. For details on how to connect the Cognos Drop Down List Filter Provider to other Web Parts, including the QueryVision Report Viewer, see Filters & the Report Viewer. ) Using Cognos-Student-Consumer: To post a message to all the list members, send email to cognos-student-consumer@lists. Details of the APARs listed below can be accessed by clicking the link for the APAR number. While you can do this in Cognos Connection, it will only allow you to view permissions on each Cognos object one at a time. Log in to the portal (Figure 1). When Metadata Manager extracts a Cognos object that is associated with a data source secured against multiple namespaces, the Cognos user account must have the required. Audits for IBM Cognos 8 or 10 servers will not run from the c11AuditExtension application. This is fine for most situations, but the ability to navigate through an LDAP or AD tree is not. Looking for Cognos 11 training with an expert live instructor? We have trained 62,586 students from 11,834 organizations. These roles already have capabilities defined. Also validating the object did not work. Got some schedules in my Cognos environment who failed with the message: CNC-SDS-0413 There was a problem in executing the task. Usage of Cognos Statistics is available in most tools that are used to create reports and dashboards in C10. MotioPI is a FREE community driven tool which enables Cognos administrators, report authors and power users to perform everyday tasks that are traditionally tedious and time consuming. That means you can filter a Cognos Report and other content, like a SharePoint list at the same time! Support: We know life can be complicated so we try to keep things as simple as possible. Steps: Open the previous saved sample report “mylist” in Report Studio. We recommend using Chrome or Firefox. Use the pull down menu at the bottom of the navigation link list to select PIMS Reports (Figure 2). I want to create a field that shows days between RUN date and Received date when Status Classification = 'Open' and when it = 'Pend'. Click the Sort button's drop down list. A list or crosstab on report page is just a table element, styled and formatted according to Cognos global style sheets. In Esri Maps for IBM Cognos 6. you can get this list from LDAP directory server. This was not initially clear when working with a date only (not date/time) element. In this article you will learn the process of Conditional Formatting with String Variable, Boolean Variable and Report Language variable in Cognos Report Studio. (This report may take some time depending upon size of request. Cognos® Public Folders Home Page will open in a new browser window:. COGNOS - Using List of Values 1 November 2010 COGNOS Using List of Values Using a List of Values when creating a Prompt Page in Cognos will make your report run faster because it is not looking at the actual table for the values for the prompt, it is simply looking at a list of the codes (values) that are available for that table. (the list 11. cognos : 100% stacked Bar chart displaying percentages in bars using Java Script We can't display percentages in middle of the bars in cognos 10. MindMajix is the leader in delivering online courses training for wide-range of IT software courses like Tibco, Oracle, IBM, SAP,Tableau, Qlikview, Server administration etc. Select the column "products sold" on witch you want to have the style. The latest Tweets from Cognos NewsBot (@Cognos_NewsBot). IBM Cognos BI Interview Questions IBM Cognos Business Intelligence: 2011 IBM Cognos Business Intelligence (BI) helps organizations meet strategic objectives and provides real value for the business by delivering the information everyone needs while also reducing the burden on IT. I have tried with Firefox & Chrome where they work fine, however on IE it returns just a blank screen. List Page Headers & Footers List Page Headers & Footers are headers and footers that appear at the top or bottom of the list on. To see the configured metric list, click Back to default entry. Its sorts month as April,Aug, Feb, Jan, instead of Jan, Feb, March, April, For sorting months in its natural order, we have to make a way around the sorting of Cognos. Then you'll see a list of all the query items for the query associated with the layout. We have seen that cognos macro functions available in framework manager are also available in report studio. Such a variable has a name as in the following list, followed by the prompt name:. System requirements. cognos : 100% stacked Bar chart displaying percentages in bars using Java Script We can't display percentages in middle of the bars in cognos 10. I already selected no suppression option in the report, but still not working. cognos: adding tooltip in a list report Sometimes we may need to add tool-tip for a Column in a List report. X pages render a !DOCTYPE that results in the iframe running in "standards mode". And what's worse, the old manual method of searching for "Upgrade to IBM Cognos Analytics 11. Select Crosstab as type of the report and click OK. That means you can filter a Cognos Report and other content, like a SharePoint list at the same time! Support: We know life can be complicated so we try to keep things as simple as possible. In Cognos it is possible to group. Navigate to "Advanced" tab under Tools->Options iii. And while some people may have a lot to complain about in Cognos Analytics, there are some shining advances that force me to forgive all the questionable design decisions (even the loss of the menu and button bars in Repor. Some clients expose portions of their platform to the public, safe in the knowledge that users can only see what they're allowed to see. Click the Sorting option's button to display the Sorting dialog. Burst Reports with Master Detail relationships is not a good option to use in Cognos. The packages you use to generate reports are based on models that are created in Cognos Framework Manager. Accessing Cognos Reports 1. This will not change anything for excel or csv output. Each salesperson is responsible for a certain region and you want each person to only see their region's sales. Usually the 'proven practice' will tell you to do it via the query and parameters and a lot of other complicated ways. Hi, i have to filter a list and a chart using values in drop down list. In this post, we will show you how to use number property filters, in order to spot performance issues in your Cognos Enviroment with Motio PI Pro. Cognos displays the list of folders within the navigation path. IBM Cognos 11. You can create a list in which you put your two item "State" and "percapita". Descendants Function in Cognos Dimensional Reporting This function is used to extract set of descendants at a specified level/member (or) distance from the specified set of level/member. Esri Maps for IBM Cognos is supported for use with IBM Cognos Enterprise and IBM Cognos Express 10. Cognos graphs have plenty of options, most of which are covered by the various courses and help files. In addition to the File type mentioned above, it can be configured to write to the system log, a named windows event log, or a SQL database. In the Properties pane, double-click the Render Variable property. In the Sort List, notice the arrow displayed between the field icon and field name. Implemented the SSO (Single Sign On) between the JSP portal and the Cognos. Duties Include, But Not Limited To. Click the Sort button's drop down list. Cognos Reporting: A Basic Overview Updated on 07. I have 4 list one below the other in Cognos Report which has same columns, only first list has column heading and in other 3 lists the column titles are hidden. ini file so here it is: Sorting a list in Cognos. With the dynamic query mode, master detail relationships are optimized. List items immediately before the GTP was run. 0: User Guide Contents. This gives IBM's software a notable advantage over other Performance Management software, which cover an average 56% of characteristics for this module. The groups and roles created in Cognos 8 are referred to as Cognos groups and Cognos roles. Default Date Prompt. Details of the APARs listed below can be accessed by clicking the link for the APAR number. Rasheed indique 22 postes sur son profil. The following is the opinion of the writer and is not intended to malign any religion, ethnic group, club, organization, company, or individual. A triangle displays in the column header to indicate a sort has been placed on it. In my toolbox, I cannot see a 'list he. If you have not added any user as part of the System Administrator role in Cognos, then you have to add Everyone user group in System Administrator roles of Cognos again. This page includes extra samples that were not shipped with the product and legacy samples including 6 deployments, related models, and cubes. Notice that 0695. For details on setting up a Connection to Cognos, see the article Connecting QuerySurge to IBM Cognos Analytics. A prompt should come up asking for the OrderBy parameter value. For a list of Fix Central Machine Code updates available for installation on select machine types that do not require the machine to be covered under warranty, an IBM hardware maintenance service agreement, or a Special Bid Agreement please click here. Each user, group, distribution list etc. 1, then the user that originally created the journal in data entry is kept as the creator and is not replaced by the user that did the copy. If you have tried using certain SQL functions that you know should. Event Studio is still available in Cognos Analytics and will be so until the functionality is ported. Adding screen tips to column headers. You can no longer select/checkbox the reports and use the cut, copy, paste icons to move content. doc Create a Crosstab Report: In this topic, you will create a crosstab report for the Registrar who requested an Official Term Enrollment report that compares total student counts by residency and academic load. If you have any questions or need any additional information, please reach out to the UCOP Cognos Reporting Team at ITS-UCDSS-SA@ucop. I have 4 list one below the other in Cognos Report which has same columns, only first list has column heading and in other 3 lists the column titles are hidden. This will work for HTML output (maybe PDF?). [Month] and we want to sort it in natural order. *The source for an Event Studio agent is a package published in your Cognos Connection environment. Details of the APARs listed below can be accessed by clicking the link for the APAR number. You have a report that is for your sales team. Click on the lock to unlock the report. any other ways of implementing logic. To add the Everyone user group in the System Administrator role of. this take more time to run query. For example, you can combine a master list with a detail chart. Showing and Hiding Reports & Other Cognos Objects – Part 1 In ensuring that our web parts, in particular our Navigation Web Part, only show those folders, packages, reports and other Cognos object types that a user is permitted to see, we have had to fully understand all the options available for Cognos Adminstrators in Cognos Connection. These portlets leverage the Classic Viewer (C10. This is infuriating. Open ‐ Open an existing report currently saved in Public Folders or My Folders. create new report , select list. This report shows data for all Student Types that are in the package. "While many people jumped at the chance to go from SQL Server 2000 to 2005, the jump to 2008 will be a little more hesitant, mostly because of the difficulty in moving database. It's very simple and I have even make it work in much complex sorting logic than what you have. then in the source tab, all the objects will be populated from the package , from that drag and drop the required query item into the work area , to form a list report. It could be any fact measure over which you have to find out Top 10 or 20 records subject of requirement. For more information, see knowledge base article 000012099. º Internet Explorer 8 and 9 are no longer supported. IBM Cognos Analytics is a cloud and on-premise-based business intelligence solution that offers users access to a wide range of business analytics functionality to help them make well-informed decisions, faster. Themes and extensions are a great way to customize your Cognos instance. Merged cells in Excel output Let's say there is a list report with many columns. (This report may take some time depending upon size of request. IBM Cognos 11. While running report, logo images are visible in html and when try to download in pdf/excel output, logo image is not available. 1 Create Simple List Report In this task a list report will be created that will use to examine the behaviors of Global Filtering on a bursted report. Perform a job search on linkedin. Put a check next to your query item item so that Cognos can reference that item your in layout logic even though it does not appear anywhere in the layout. Select the list column to be rendered conditionally. or we can improve performance by changing query properties to allow the report server to execute queries concurrently where possible. Find the report that you wish to run and click on the report name. IBM Cognos service does not start or fails after starting You start the IBM Cognos Business Intelligence service but services either do not start correctly or are very slow to start. The class ends with a discussion of how to trouble-shoot problems experienced with Cognos. Consult your local IBM representative for information on the products and services currently available in your area. Hi, i got the following question from a customer of mine: What are the files/directories located in the Cognos 8 Temp directory? of course i know some of the files and what they are used for but does someone have a list or document which explains these files/directories and their purpose? thx!. Such a variable has a name as in the following list, followed by the prompt name:. The IBM Cognos platform is an open, enterprise-class platform that can provide your users with the business intelligence and performance management content they need to understand your business and help improve results. However TM1 Server is visible in a local client. The typical layout tasks you need to perform (e. To identify the SQLs that Cognos fires against the DB, you would need to use the Generated SQL/MDX option from the Tools Menu and not the one available for each individual Query Object in Cognos. Subject: [cognos8-l] Filter a column in a list report (not "for report") How can I apply a filter to only a column and not have it filter the rest of the report? I tried all kinds of variations of filter([expression], myfilter) - but it still filters the whole report. Here's a list of objects in Cognos Connection. with Filter Join Optimization. These portlets leverage the Classic Viewer (C10. Hi, How to control the display of SubTotals in a crosstab report. I expected this because <> conditions is very slow when compared with not in or not exists. doc Filter 1. Check that IBM Cognos service is available and properly configured. Just let us know your business requirements and we will customize Trifacta Wrangler for your business. Tip: You must select the list column, not list column body or list column title. The OLTP system doesn't even deal with millions of rows nor do we have an ETL system. Since I am NOT IBM, I cannot guarantee that what I have here is complete, or even correct. Do not Reclick. IBM Cognos Analytics is a web-based report development and data visualization tool designed to create list and crosstab reports; author complex multi-page dashboards across multiple relational and OLAP databases. 0 Sep-2018 Page | 4 This icon indicates your output prefer If you are unable to view folders or the list of Departmental (Shared) Reports for your school,. this take more time to run query. They were trying to exclude multiple values from the SQL query, but they were needing to use wildcards. "This is going to be the largest Intercloud in the world," Gori said. ) Using Cognos-Student-Consumer: To post a message to all the list members, send email to cognos-student-consumer@lists. For example, a list shows all products in your product line. Cognos 10 Getting Started with Internet Explorer and Windows 7 Cognos 10 Getting Started w/IE and Windows 7 Page 6 Saving Encrypted Pages to Disk On the Advanced tab, scroll down to the Security section and un-check Do not save encrypted pages to disk and click OK. Crosstab reports in Cognos are used to display summary values. Here is a simple list of existing Cognos Macro with description. Excel Reports Not Opening: Follow the steps below to assist when Excel reports are not opening correctly in Cognos. Before we start, it’s important to assume that users can successfully authentication independently with OKTA, AD or LDAP over AD configured with their Cognos Analytics environment (See Appendix A) via SSO (if enabled) Below is a list of the preconfigured namespaces that will be federated using OpenID Authentication Proxy: Environment: Gateway URL.