Script for Automation of Cube Building

Cube Building Script


The below code will help to automate your cube building process in Windows.


@echo on
  C:


cd "C:\Program Files\IBM\cognos10TF\bin\"

Cogtr.exe   -n -s "C:\Documents and Settings\rdogra\Desktop\ORO-DRS new approach\ST3 Financial\DRS ST3\FAMIS Expenditure Report.pyj"

cd "C:\Program Files\IBM\cognos10TF\bin\"

Cogtr.exe   -n -s "C:\Documents and Settings\rdogra\Desktop\ORO-DRS new approach\ST3 Financial\DRS ST3\FAMIS Expenditure Report 2012.pyj"


@echo off

xcopy "S:\Kishore\internal eeo.mdc" "S:\Rahul Dogra" /c/d/i/y

exit

Cognos 10.X Online Training

ONLINE COGNOS TRAINING

Cognos Course Content:


1.Introduction to Data warehousing (DWH) 

• Introduction to DWH 
• Characteristics of DWH 
• OLTP Vs OLAP Databases 
• Different Approaches of DWH (Kimball Vs Inmon) 
• Data mart Vs Data Warehouse 
• Fact Table Vs Dimension Table 
• Concepts of Schemas (Star schema & Snowflake schema) 
• Industry leading ETL and Reporting tools 

2. Introduction to Cognos 

* About Cognos 8.4
* 3 – Tier Architecture
* Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3)
* Features of Cognos 8.4
* Cognos Vs other OLAP tools
* Cognos components (Modeling & Reporting)
* Different cognos services

3.Cognos Connections 

* Personalize cognos connection
* Create and manage portals, shortcuts, report views.etc
* Working with Cognos configuration, content Store
* How to Connect to different Data Sources
* Security setup
* Import and Export of Package (Deployment)
* Running the Report Burn
* Scheduling Reports

4.Framework Manager 

* About Framework Manager
* Framework Manager, Metadata Modeling
* Creation of Interface and Usage
* Creating Model & Namespace (Layers)
* Importing Metadata
* Naming convention for objects in a project
* Creating Query Subjects & Query Items
* Merging Query Subjects
* Creating Relationships & Setting Cardinalities
* Creating Parameter Maps & Macros
* Creating of Model Filters, Prompts & Calculations
* Add Business Rules and Set Governors
* Assigning package level security
* Improving performance
* Publishing Package

5.Query Studio 

* Introduction
* About Ad-hoc Reports
* Types of Report(List, Cross Tab, Chart Reports & Others)
* Applying Filters, Prompts & Calculations
* Sorting, Grouping, Sections & Aggregate Functions
* Run and Manage reports

6.Report Studio 

* Type of Report Templates
* Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
* Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
* Generating and Creating Prompt Page
* Types of Prompts
* Query Calculations & Layout Calculations
* Static Filters and Dynamic Filters
* Conditional Block
* Conditional Formatting
* Master Details
* Cascading Prompt
* HTML Items & Hyperlinks
* Set Operators
* Setting Burst Options
* Drill through
* Drill up & Drill down
* Setting Variables
* Report Functions
* Report Validation
* Reports Run with Options (separate course not included in this package)

7.Analysis Studio 

* Insert Data
* Change the number of Visible Items
* Nest Data
* Replace Data
* Sort Data
* Explore Data
* Change the measure
* Drill down for Details
* Hide Items
* Insert a calculation
* Save a custom set
* Define a filter
* Compare sets of data
* Using Dynamic Context

8.Event Studio 

* Creating Agents
* Adding Event conditions
* Task and Task execution rules
* Scheduling Agents 

Text Box prompt with Comma Seperated Values in Cognos 8.x

The following technique allows users to enter comma separated values into a text box prompt.

Use a filter expression to parse out the values. For example, a report has a prompt with parameter ?Id? and is used to filter query item [Id]

The filter expression would be as follows:

cast([Id],varchar(200)) in ( #csv ( split(' ', split(',', split(' ,', split(' , ', split(', ', prompt('Id','token') ) ) ) ) ) ) # )

1. This filter converts the Id to text and looks for the value IN a list of comma separated values.
2.  Due to the nature of the macro functions, the result of the function is a series of string elements. 
3. The cast function applied to a numeric field ensures that the appropriate data types are being used within the filter expression. 
4. The split() macro functions are in place to handle additional white space that users may enter between the comma-delimited values. 
5. It allows you to enter multiple Order Numbers separated by commas, in a text box prompt.

when  you runt he reports it asks you to enter the values in text box prompt.
there enter 1,2,3 and then click on finish

it will give the data for Ids 1,2 and 3.