It was already possible to secure hierarchies or levels. Starting from Fixpack 1 individual dimensions or even attributes can be secured. The security no longer needs to be hard-coded but can use existing tables in the database. Commonly used, the first, last and current period rules allow for rolling up semi-additive measures. Aggregating inventory can now be done graciously. From the administration perspective, it is made easy to deploy, configure and manage Dynamic Cubes using the Dynamic Cube management console.
A Dynamic Cube API was added allowing the programmer to write an interface to generate and deploy cubes programmatically. Figure 8: Cube Designer Configuring advanced security.
Some changes to the user interface were made to navigate the BI content in a more visual way. Reports that are executed manually on Cognos Mobile will no longer retrieve the entire report before showing results but rather retrieve a page at a time. Although the total execution time remains the same, the first page of the report is shown much faster in Cognos Mobile.
Meanwhile, Fixpack 2 was released with additional features. The iOS application can be themed and reports can be shown in portrait mode. Cognos Workspace can be viewed and manipulated on iOs and Android devices.
You can drill from an Active Report to a report that uses a different package or type of data source. Drill through is also supported from and to a saved Active Report. The introduction of Dynamic Query Mode has been a leap forward in query technology. The Java-based, extensible query engine was introduced in the Cognos platform with the release of Cognos The dynamic query layer was specifically developed to meet the performance challenges that are present with interactive reporting and ad hoc analysis.
DQM uses advanced in-memory caching and aggregation to seriously lower execution times. Through every new release, IBM has been investing a lot of effort to further improve the performance and usability of the Dynamic Query Mode.
Every release offers new compatible source databases. Next, popular databases like Oracle and SQL server were added. With the A big problem in previous versions was the slow execution of master-detail queries, especially when complex reports were bursted.
This was due to the fact that a detail query was executed for every master record. This approach is a lot slower than fetching a single instance of the detail query that holds all the master records.
Now, DQM will whenever possible use a single query, rather than having a detail query for every master record instance. When bursting reports, the query can also be pre-fetched. The queries will run in parallel with the report rendering, producing much faster output when rendering takes a long time.
Not new -but noteworthy- is that queries can be run concurrently. Normally report queries are sequentially processed.
This often results in faster report output. However many other changes were done below the hood to optimize resource utilization and improved scalability in mobile, batch reporting, report rendering, active reports, dynamic cubes and bursting. In previous versions you needed to configure the Internet Information Services gateway manually to run using the bit libraries by running a.
As of now, the bit libraries are installed by default for bit installations of Cognos BI Server. Cognos can be configured to use external repositories. An external repository cannot only be used as an external repository but also for content archival. Content archival means that stored versions of a report are moved away from the content store and stored somewhere else.
Using an external repository will not only store the report output externally, but also the metadata. You can store entire folders somewhere else encrypted zipfiles , but this is completely transparent in Cognos Connection.
A user cannot see the difference between a folder that is stored in the Content Store and a folder that is stored externally. By using content archival, saved report outputs can be archived to an external repository. Click on the button below to watch the recording. Related Posts 03 Mar March 3, Get in Touch! All Rights Reserved.
This site uses cookies in order to improve our marketing and services. Click 'Accept Cookies' to agree to the use of these.
Or follow the guide on how to disable them in our Cookie Policy. Cookie Policy Accept Cookies. Manage consent. Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website.
These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience. Necessary Necessary.
Users familiar with Excel will be pleased to hear that you can now Freeze and Unfreeze column and row heading when scrolling. There is a Data Visualization Guide called Visual Recommender that will help you select the appropriate chart type based on your data values in your workspace, including reason for that decision. The ability to print your workspace has also been included in this release. Technically, it also includes support for Safari and Google Chrome.
Cognos Insight Cognos This is fully supported and documented. Using JavaScript it allows you to set, read, delete and validate prompts values. Exporting report output to Excel is now easier as they have increase the maximum number of columns to 16, and 1,, rows.
Users can also export in a new format called Excel Data, which is a lightweight transfer of Excel without any report formatting. Dynamic Cubes The most significant feature in Cognos It is aimed at any organization with large or mature star and snowflake schemas that would like to provide their users with an OLAP experience without having to compromise on the data details or high performance.
0コメント