Category: COGNOS

Slice and Dice in Cognos Powerplay

Cognos

Slice and Dice multidimensional analysis technique allows users to rearrange dimensions in a report and provide broad perspectives of the data. Slicing and Dicing in Cognos can be performed in the following ways: Dragging and dropping the dimension folders from a dimension viewer (on the left) or dimension toolbar (in the top) to the crosstab area Selecting category in a dimension viewer and doing the right click on the selected category and choosing Replace Rows (or Replace Columns or Replace Layers) Selecting category in a dimension viewer and clicking the corresponding icon from the left-hand side menu Swapping rows and columns is also a Slice and Dice cube investigation activity. It can be accessed from Main Menu -> Explore -> Swap -> Rows and Columns DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Major difference between Cognos PowerPlay and Cognos 8 Analysis Studio

Cognos powerplay

Cognos 8 Analysis Studio is a web-based system and is the component of IBM Cognos Analytics that you can use for multidimensional analysis and exploration of large data source. Cognos PowerPlay is an application that manages data exploration and reporting which is based on the PowerPlay Cubes. The major differences between Cognos PowerPlay and Cognos 8 Analysis Studio are: ● Multidimensional data analysis: The features regarding additional calculations, ranking, sorting, generating charts, calculating subtotals, summarizing, filtering is equally implemented in both Analysis Studio and PowerPlay● Exploring and reporting: Cognos PowerPlay has two data exploration modes – Explorer and Reporter, with can be easily switched in a dynamic way. It is a widely used feature by business users which implements dynamic data analysis and static reporting. Whereas, Cognos 8 Analysis Studio users need to utilize both Analysis Studio and Report Studio.● Security: Cognos 8 Analysis Studio is an integrated architecture and implements a common security model which makes it easy to manage and support authorizations. Whereas, applying security to offline Cognos PowerPlay cubes is possible, however once the cube is distributed, the data may not be fully secure.● Support and maintenance: Cognos 8 Analysis Studio is an integrated platform. It is […]

Read More +

Find Out Drill down in Cognos Powerplay

Cognos Powerplay

Cognos Powerplay drill up & down operations allows moving up and down the hierarchy of categories in a dimension. To drill down means to go from a higher summary level into more details. Drilling up expands the focus of a report and moves into a lower detail level. In Cognos Powerplay you can Drill up and down the hierarchy tree in the following ways: • Hover the mouse pointer over a category you want to explore in more details and if the cursor changes to a plus sign, it means that the drill-down is available, and you can double click the category to drill down. • Alternatively, instead of double-clicking you can right-click on a selected category and select Drill Down. • Drill down by clicking the plus sign. • To drill back up go to the cube summary row or summary column and once the cursor changes to the plus sign with an up arrow, double-click it to go one level up. • Alternatively, instead of double click you can right-click on a selected category and select Drill Up. • Drill up by clicking the summary row. • It is also possible to drill up and down in a […]

Read More +

Where to use Cognos Powerplay?

Cognos Powerplay is an application that manages data exploration and reporting which is based on the Powerplay Cubes. It fully implements the concept of OLAP multidimensional analysis and can create various reports according to the user’s needs. Some of the major features of Cognos Powerplay: It enables users to explore large volumes of summarized data with sub-second response times in a Web or Excel environment. Cognos Powerplay draws information from relational databases to model and builds Powercubes. Cubes are data sets that can contain tons of millions of consolidated rows of data and categories. Business rules and calculations can be built right into them and time series analysis is delivered automatically. Cubes and reports can be deployed to Web clients or to Windows and Excel clients, all using the same application server. Cognos Powerplay provides both a multidimensional data store and a feature-rich end-user experience. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

DataTerrain launches SAS BI Automated Report Conversion Solution

DataTerrain a leader in Business Intelligence migration solutions, announced the launch of Automated reports conversion solution for customers who are migrating from SASBI platforms to other BI platforms like Jasper, Cognos or OBIEE. DataTerrain’s Automated conversion solution enables customers with SAS BI reports migrating accurately to the target Platform. The Automated conversion framework includes the analysis phase, where all the source elements are examined and the missing elements are identified, that can be used for pin-pointed analysis to narrow down the report migration issues. DataTerrain’s experts can help recommend solutions for the compatibility issues and resolve them. The Automation conversion solution also includes conversion of native functions and complex formula logics embedded in SAS BI reports and provide an equivalent solution to achieve the same in the target platform. Customers can take advantage of DataTerrain’s Automated conversion solution to preserve years of efforts in designing the reports while migrating to new BI platform. DataTerrain’s Automation conversion services are offered under a Fixed-cost basis for any type or number of reports basis. There are NO long-term contracts required and can be utilized for a specific project to a broader spectrum of support Please contact connect(at)dataterrain(dot)com for more information. About DataTerrain DataTerrain […]

Read More +

DataTerrain launches automated conversion solution to Cognos

DataTerrain a leader in Business Intelligence migration solutions, announced the launch of reports conversion solution for customers who are migrating from legacy platforms to Cognos platform and support both 10.x and 11.x versions. DataTerrain’s conversion solution to Cognos includes both the reports and the Framework Manager. DataTerrain’s automation tool, which forms the core of the conversion solution enables the customers with legacy BI platforms like BRIO, Discoverer, Oracle 10g to migrate to Cognos. The converted metadata (Framework Manager) works seamlessly in the Cognos platform and supports Adhoc reports. The analysis component of the automation tool examines all the elements, identifies the missing elements and provides a detailed log that can be used for pinpointed analysis to narrow down report migration issues. The converted reports work seamlessly in Cognos. The conversion framework includes the analysis phase, which thoroughly reviews all the source elements, identifies the missing elements, that can also be used for pin pointed analysis to reduce the report migration issues.DataTerrain’s experts can provide solutions for the compatibility issues and resolve them. Customers can take advantage of DataTerrain’s conversion solution to preserve years of efforts in designing the reports and metadata while migrating to Cognos. DataTerrain’sconversion Services are offered under […]

Read More +