This software/documentation contains proprietary information of Cognos .. Framework Manager User. Guide. Creating and publishing models using. This document applies to IBM® Cognos® 8 Business Intelligence Version and may How is IBM Cognos 8 PowerPlay Studio Different from IBM Cognos Series 7 After Exporting to PDF the Label for the OTHER Category in a Pie Chart . Transformer is used when you insert the Cube File Name into the report title. To use modeling tools, such as Framework Manager and IBM Cognos For instructions about installing and configuring IBM Cognos BI Server, see the IBM Cognos Series 7.x Transformer models to IBM Cognos BI Transformer or later.

Author: JoJokasa Voodooramar
Country: Serbia
Language: English (Spanish)
Genre: Marketing
Published (Last): 23 December 2006
Pages: 109
PDF File Size: 10.18 Mb
ePub File Size: 4.53 Mb
ISBN: 141-9-54631-633-3
Downloads: 29894
Price: Free* [*Free Regsitration Required]
Uploader: Tojarn

Specify How Missing Values Appear. Optimization of the Operating Environment. Unable to Open the Great Outdoors Sales. Advanced database administration DBA or data modeling skills are not required.

These fictitious records include sample data for sales transactions, product distribution, finance, and human resources. Instead, you can use IBM Cognos packages and reports as data sources. You use this component to create a model, a business presentation of the information in one or more data sources.

After you choose a supported product Does it need to be converted to a supported data transfodmer type before it is imported? You can use Cognos Transformer to presummarize the data when your users do not require access to all the details in the source.


For example, if your organization processes 50, transactions daily, and you create the cube weekly, you can summarize the transactions at the weekly level before Cognos Transformer begins processing. Analyze the data flow from the point at which your data is generated until the data is input into Cognos Transformer. Determine if the data can be streamlined or rationalized at any point, perhaps by creating a data warehouse, a series of data gudie, or a data-extract process to reorganize it.

You begin with one data source. You can enhance the business value of your model later, by adding more sources or manipulating the data derived from the existing data sources.

Cognos Products and Tools – TechyLib

To verify that you have maintained a 1: Lower ratios allow for efficient partitioning and faster cube creation times in Cognos Transformer, as well tranxformer easier data exploration in your reporting component. Cognos Transformer Developer Guide. Check Cube Build Status When you build a cube in Cognos Transformer, you can check the status of the cube build at any time without opening it by using the PowerCube Status command on the Tools menu.

You can check the status of all the cubes that are defined for a model at the same time. Cognos Series 7 user class. This option is supported only for migration testing, and cannot be used to deploy cubes in production 8.4. If you plan to upgrade, ensure you save all your models as. Framework Manager, before you import the data. However, you can create PowerCubes directly in Cognos Finance. After import, you can combine the IBM Cognos data with the data from other sources as required.

Individual query items can be used as source columns in the Cognos Transformer model, and can be updated using guire Modify Columns feature.

Cognos Transformer, Cognos Transformer maps the rollup or regular aggregate setting of the package source query items to a corresponding measure rollup type cognoa Cognos Transformer.

However, when you use a query item from a data source that uses report-based measures as query items in Cognos Data Preview Data preview windows may not show data rows grouped or sorted as they appear in a report; however, this does not impact how Cognos Transformer uses the data when building cubes. Extra Query Items When you create a data source using a report that contains groupings, the report query sometimes shows extra query items.


In Cognos Transformer, you can specify Unicode as a valid character set. You can then export the report to a. Cognos PowerHouse 4GL portable subfile. In Cognos Transformer, specify the portable subfile dictionary. Accept the default Character set or specify an alternative. The MUN is much like the business key in a table. The mappings between these assigned codes and their associated source values are stored in the Cognos Transformer model for use in subsequent cube build operations.

However, errors may arise if the model is not saved after a cube refresh, or if the processing order changes for any reason. In addition, source values that conform with the business keys in other applications used in IBM Cognos BI will have the best success rates when used with drill-through applications and other business intelligence applications.

From the Cognos Transformer Welcome page, click Create a new model. Type a name for your new model and click Next. Signons list, and is not saved in the model. To create a Cognos Transformer signon that appears in the Signons list and is saved in the model, enter a valid user name and password and select the Create a Transformer signon from the user name and password or select an existing one for use with this data source check box.

These data sources may contain prompts that add interactivity for users. An asterisk beside a prompt name identifies a mandatory prompt. This prompt exists in the Cognos Transformer query, but cannot be found in the report or package used as a data source.

Save to save the command line file to your computer. Remove Obsolete Prompts Cognos Transformer stores prompts and their values in the Cognos Transformer model and uses this information for data requests and to generate a prompt specification.

Since prompts apply to all queries in the Cognos Transformer model but are maintained separately for each query, the specified values should be the same in all queries.

IBM Cognos User Manual

Change a Data Source Type If you decide after you import a data source in Cognos Transformer that the data can be more effectively sourced from a different data source type, you can change the data source. You cannot change a data source for a query in the model to match another query already in the model.

OLAP packages with parent-child hierarchies, Cognos Transformer will interpret each parent and child as unique dimensions. Browse to select a dimensional package and click Finish. When adding queries from a report, Cognos Transformer displays the source query using the Query name specified in the query definition for example, Query 1. You can quickly resynchronize your model columns after a data update if your model uses a single query based on a text data file, an IQD, or an IBM Cognos package or report.

Resynchronize your model by invoking the Modify Columns command from the Tools menu. To allow Cognos Transformer to automatically match query items to columns, select the columns in tgansformer model and click Auto Match. If Cognos Transformer provides one or more locations in the data source that may be appropriate for unmatched columns, do one of the following: This is necessary so that the data is processed properly in the model.

You then specify this. E3 Net Income B E8 For a model requiring only the Guuide, Quarter, Expense, and Expense Amount columns, Cognos Transformer reads all the expense types and expense amounts for each quarter and for each division. Cognos Transformer reads rows 1 to 5 in the range DataTable. When you split a single, large data source into smaller, denormalized sources, you can shorten the guids time if the columns in all measure-containing sources are associated with unique levels in the model.


This is because Cognos Transformer can associate such measures directly, without confirming their context in the level hierarchy. Level Derived Indirectly When a level is derived indirectly, the source is not related to the level, but is related to descendants of the level. The default color is light yellow. For example, this source contains a column that provides category values for the unique level Product No.

For example, a data source can be read during category generation, during cube creation, or both. You can use this capability to avoid unnecessary processing, resulting in a more efficient model design. Here are some typical scenarios: Default Cognos Transformer reads all columns in the source that relate to levels in the model to see if they are associated with measures.

If the source is purely structural, the cube is not created or updated, and an error message appears.

Transformer associates the values from both of these sources with a specific level in one transformr the dimensions in the model. Cost 4 bytes and Revenue 4 bytes. Results Cognos Transformer can now correctly interpret the columns.

For example, the first record represents a transaction that generated in traansformer, occurring on January 3,involving Product1, Color1, that cost to produce. Set the Output scale property for the measure that uses the source column. When you create a data source using an IBM Cognos package, Cognos Transformer automatically uses the scale specified in the Framework Manager query, which in turn matches the scale defined in the source database.

Set the Level of Detail for Dates Values for some measures in a model often apply to time periods that are not at the lowest level in the time dimension. In such cases, you specify the actual level of detail to which the date values apply.

For example, actual revenue values may be derived from invoice information that accumulates on the dates that orders are filled. The value in the date column must be the same for all data in the array.

To ensure that Cognos Transformer processes the array correctly, you must use the first month of your fiscal year as the date in your date column. This specifies the year-begin date gujde the year in which the array applies. Procedure You define the Month01 column in each data source as the first column in a twelve-member array.

By default, Cognos Transformer interprets the years 00 to 19 as toand the years 20 to 99 as to For a different default setting, open the cogtr. If you do not create a Cognos Transformer signon, you will not be able to build cubes in batch mode.

When a data source has more than one signon configured, the multiple signons are shown on the Content Store Data Source tab in the Data Source property sheet.

In the Password box, type the password. In the Namespace list, select the appropriate namespace. It then automatically v creates a time dimension based on the date column If the dates are not in a predefined format, Cognos Transformer may cognks you to define the format.

Powerplayy property sheet, click OK.

In the dimension tree for the package, select the dimensions, hierarchies, or levels that you want to add to your model and click OK. The list of available functions varies ugide the Data class. For example, the first-of-month and today functions are only available for the Date data class. When the expression is complete, click OK.