IBM Cognos Business Insight is a web-based user interface that allows you to open or edit a dashboard or to create a dashboard. The Getting Started page You can complete the following activities from this page: Create a new dashboard View and open favorite dashboards from Favorites View how-to videos that provide an overview to Business Insight When you select any of the options on the Getting Started page, the page closes. Application bar The application bar displays the name of the current dashboard and contains the icons for different actions that you can perform in the dashboard layout area. For example, you can access the Action Menu, create a dashboard, open an existing dashboard, send an email or collaboration, change the layout, or search for content.
|Published (Last):||11 August 2011|
|PDF File Size:||19.1 Mb|
|ePub File Size:||5.1 Mb|
|Price:||Free* [*Free Regsitration Required]|
As I stated in the first article, Creating Our First Cube , the primary focus of this series is an introduction to the practical creation and manipulation of multidimensional OLAP cubes. The series is designed to provide hands-on application of the fundamentals of MS SQL Server Analysis Services "Analysis Services" , with each installment progressively adding features and techniques designed to meet specific real-world needs. In addition, I will be performing all steps on a Windows Server, although the steps will be quite similar with later Windows operating systems.
PowerPlay provides the capability for establishing connections to our cubes, among other functions. Because we are targeting users of PowerPlay, we will assume minimal installation of the products involved, exposing the specific setup required to enable reporting from Analysis Services cubes.
This comes in response to the expressed need of several readers for options in this regard - options beyond the mere browse capabilities within Analysis Services. As we did with the Excel PivotTable Report in the first of our Reporting Options articles Article Ten , we presented an introduction to using FrontPage to retrieve and display information from our cubes in Article Eleven, first discussing the steps needed to define our data source, and to establish a connection to the cube.
Finally, we discussed various presentation and formatting considerations for the two options. Reporting Options for Analysis Services Cubes: Cognos PowerPlay In this lesson, we will continue our exploration of what has become a popular topic, a topic which, as I mentioned in Article Ten, generates many e-mails each week in my inbox, Reporting Options for Analysis Services Cubes.
As I stated in the first of the Reporting Options articles, our focus is to explore options for obtaining reports from Analysis Services cubes within a range of similar business intelligence capabilities. My intent is therefore to review the process of establishing connectivity and enabling reporting capabilities for each of the options, and not to compare the product features themselves, to any significant extent.
As I stated from the outset of the Reporting Options articles, I will consider providing a similar examination of other reporting products at a later time, based upon any suggestions I receive from readers, if this turns out to be useful. After a brief introduction to the application, we will examine some of the options offered by Cognos PowerPlay for report building with Analysis Services cubes.
As we did with the MS Office reporting options in the previous two Reporting Options articles, we will present an introduction to using Cognos PowerPlay to retrieve and display information from our cubes.
We will discuss in order the steps needed to set the application up specifically for accessing a non-Cognos cube, then expose the steps required for the definition our data source, and for the establishment of a connection to the cube. Next, we will briefly examine the layout and navigation of the two reporting approaches that PowerPlay offers, and examine illustrations of browsing and reporting our cube data from each.
In this article, we will examine using Cognos PowerPlay to report from the client platform, as well as over the web. As the two approaches share several preparatory steps, we will perform the common setup procedures, and then we will expose the specific setup of each. As virtually anyone using PowerPlay is aware, in a "typical" implementation, the application forms the reporting component of an end-to-end OLAP solution, whose proprietary OLAP data sources, "PowerCubes," are created via another component called Transformer.
The motivation is obvious, as the ascendancy of the RDBMS-generated cube is, at this stage, both inevitable and irresistible. Introduction and Scope In exploring the use of Cognos PowerPlay with Analysis Services cubes, we soon become aware that there are multiple approaches to reaching our ends.
The integration of security is involved and beyond the scope of this article. Our intent here is simply to offer another option for reporting from Analysis Services Cubes, as we have stated in each article of the sub-series.
PPES also provides for user access to PowerPlay reports, which typically originate in one of the PowerPlay client applications, via a report server. Performance becomes more efficient because of minimal client processing and reduced data traffic between the client and server involved in any given operating relationship. The dual benefits are realized as a result of the lowered need of the client to obtain data, and because caching mitigates a portion of the need for communication.
We will examine the setup of the components together, as most of the steps of establishing connectivity to the Analysis Services cube are held in common between the different reporting options. As I stated earlier, for the purposes of this article, we will assume that we wish to establish simple security, meaning that you may be prompted for logon input at more than one juncture while processing.
Introduction to IBM Cognos Business Insight - IBM Cognos
PowerCubes provide secure and fast data access. Keep in mind that Cognos cubes are static and building a PowerCube is a repetitive process cubes may be refreshed every day, every month or even once a year. PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Each source can be expanded and it lists all available columns. Users can browse the source data by using Data Source Viewer. It allows creating new dimensions and modifying existing using an user-friendly graphical interface.
Reporting Options for Analysis Services Cubes: Cognos PowerPlay