Cognos BI and TM1 Online training

We are providing online instructor led Cognos training We've  many instructors for Cognos training who offer courses at very affordable price and duration levels.  For your Cognos training needs, look no further. Whether you are a corporation seeking to adopt Cognos training technology or an individual looking to gain knowledge and position as an Cognos professional .We are also providing Cognos certification guidance and materials .

We are offering courses in Cognos 8,10 BI,ETL,Cognos planning ,TM1 and Powerplay,etc  along with professionally prepared training material.You can contact me at jamsheer.k@gmail.com for any training related queries.

We are covering the below topics

 1.  Cognos Query studio  

 2.  Cognos Report studio
 3.  Cognos Event studio
 4.  Cognos Analysis studio

 5.  Cognos Connection

 6.  Cognos Administration
 7.  Cognos installation and configuration

 8.  Cognos Transformer

 9.  Cognos Powerplay
10. Cognos Data manager
11. Cognos Framework Manager

12. Complex Relational and dimensional reporting using reportstudio

We are providing latest cognos certification dumps for cognos8 as well as 10 .Below the list of the certification test

For cognos 10

Test COG-180 - IBM Cognos BI Professional

Test COG-612 - IBM Cognos 10 BI Author

Test COG-622 - IBM Cognos 10 BI Administrator

Test COG-625 - IBM Cognos 10 BI Data Warehouse Developer

Test COG-632 - IBM Cognos 10 BI Metadata Model Developer

Test COG-635 - IBM Cognos 10 BI OLAP Developer

Test COG-642 - IBM Cognos 10 BI Scorecard Developer

Test COG-645 - IBM Cognos 10 BI Multidimensional Author

Test COG-700 - IBM Cognos 10 Planning Application Consultant

Test COG-480 - IBM Cognos Planning Professional

Test COG-300 - IBM Cognos TM1 Analyst

Test COG-310 - IBM Cognos TM1 Developer

For cognos8

   1.  Test BI0 -  210 - IBM Cognos 8 BI Professional

   2.  Test COG-105 - IBM Cognos 8 BI Technical Specialist

   3.  Test COG-112 - IBM Cognos 8 BI Author

   4.  Test COG-122 - IBM Cognos 8 BI Administrator

   5.  Test COG-125 - IBM Cognos 8 BI Data Warehouse Developer

   6.  Test COG-132 - IBM Cognos 8 BI Metadata Model Developer

   7.  Test COG-135 - IBM Cognos 8 BI OLAP Developer

   8.  Test COG-145 - IBM Cognos 8 BI Multidimensional Author

   9.  Test COG-180 - IBM Cognos 8 BI Professional

   10.Test COG-300 - IBM Cognos TM1 Analyst

   11.Test COG-310 - IBM Cognos TM1 Developer

   12.Test COG-400 - IBM Cognos 8 Planning Application Consultant

   13.Test COG-480 - IBM Cognos 8 Planning Professional

Latest Cognos 10 Certification dumps

Latest Cognos8 Business Intelligence Dumps for all of the tests listed below

Test COG-180 - IBM Cognos BI Professional
Test COG-612 - IBM Cognos 10 BI Author
Test COG-622 - IBM Cognos 10 BI Administrator
Test COG-625 - IBM Cognos 10 BI Data Warehouse Developer
Test COG-632 - IBM Cognos 10 BI Metadata Model Developer
Test COG-635 - IBM Cognos 10 BI OLAP Developer
Test COG-642 - IBM Cognos 10 BI Scorecard Developer
Test COG-645 - IBM Cognos 10 BI Multidimensional Author
Test COG-700 - IBM Cognos 10 Planning Application Consultant
Test COG-480 - IBM Cognos Planning Professional
Test COG-300 - IBM Cognos TM1 Analyst
Test COG-310 - IBM Cognos TM1 Developer

Contact me at jamsheer.k@gmail.com for any of the dumps listed above

Cognos Certification Dumps

We are providing latest cognos certification dumps for cognos8 as well as 10 .Below the list of the certification test

For cognos 10

Test COG-180 - IBM Cognos BI Professional

Test COG-612 - IBM Cognos 10 BI Author

Test COG-622 - IBM Cognos 10 BI Administrator

Test COG-625 - IBM Cognos 10 BI Data Warehouse Developer

Test COG-632 - IBM Cognos 10 BI Metadata Model Developer

Test COG-635 - IBM Cognos 10 BI OLAP Developer

Test COG-642 - IBM Cognos 10 BI Scorecard Developer

Test COG-645 - IBM Cognos 10 BI Multidimensional Author

Test COG-700 - IBM Cognos 10 Planning Application Consultant

Test COG-480 - IBM Cognos Planning Professional

Test COG-300 - IBM Cognos TM1 Analyst

Test COG-310 - IBM Cognos TM1 Developer

For cognos8

   1.  Test BI0 -  210 - IBM Cognos 8 BI Professional

   2.  Test COG-105 - IBM Cognos 8 BI Technical Specialist

   3.  Test COG-112 - IBM Cognos 8 BI Author

   4.  Test COG-122 - IBM Cognos 8 BI Administrator

   5.  Test COG-125 - IBM Cognos 8 BI Data Warehouse Developer

   6.  Test COG-132 - IBM Cognos 8 BI Metadata Model Developer

   7.  Test COG-135 - IBM Cognos 8 BI OLAP Developer

   8.  Test COG-145 - IBM Cognos 8 BI Multidimensional Author

   9.  Test COG-180 - IBM Cognos 8 BI Professional

   10.Test COG-300 - IBM Cognos TM1 Analyst

   11.Test COG-310 - IBM Cognos TM1 Developer

   12.Test COG-400 - IBM Cognos 8 Planning Application Consultant

   13.Test COG-480 - IBM Cognos 8 Planning Professional

Contact me at jamsheer.k@gmail.com for any of the dumps listed above

Adding Comments in Cognos Report Studio Expressions

You can add comments in  Report Studio expressions using  the below syntax.

#/*

Comments

*/#

Cognos Chart report Customisation

The customization of  the chart reports in cognos is very easy  there are many customizations other than conditional variable customizations in cognos for changing the report display properties, format options like header, footer, labels, titles, grouping, summarizing ,performance tuning like query performance, database performance etc.

To show or Hide the legend options or baselines markers or notes in a chart

Under the option for Chart Annotations, select on the the Legend or Baselines or Markers or Notes property and modify as per the requirement .

To show or Hide the axes in chart

Under the option for Axes, select Y1 or Y2 or Ordinal Axis's property and change it.

To show or Hide the axis line or axis title in Cognos charts

Click on the Y-axis and in the options pane, below the General Modify the properties for Axis Line and Title

To show or Hide the gridlines in chart report types

click on the y-axis or the ordinal axis. Below the General button, you find the Gridlines/ Minor Gridlines as a property, change it.

To display the border around the legend

Click on the legend icon. Below the General, alter the property called borders.

To make the Chart display in different 3D appearance

you can do that by changing the Depth or Visual Angle property in general options.

To show or Hide the border around the chart object

Modify the property called border property under the charts properties box.

To display the tool tips

Note: Some of the pdfs cannot render the tooltips.

to change this, you can simply modify the tooltips property.

To change the options like range or interval in Y-Axis properties

you can select the options Minimum value, Maximum Value, Scale interval, Scale Property Under the options General.

To modify the data format

Click on the y-axis and below option Data, you find the Data Format property, change it.

To alter ordinal axis properties like label truncation or skip interval

Click on the ordinal axis. Below the option General, Click on the Truncation -> Allow Rotation or Allow Stagger or Allow Skip property.

To remove it. a white space around the chart

Click on the option for Padding/Margin property and change it.

You can find the below options under the options Color and BackGround.

To change the colors of the lines and bars in charts

Change the Palette or Conditional Palette property.

 Apply a palette to a series

Change the Series Color property.

Change the default color or font for all chart elements

change the Background Color, Foreground Color, or Fill Effects property.

And you can also change the Font or Relative Alignment property, below the opions for Font & Text.

To Insert a background image or watermark in a chart report

Go to the Background Image property and change it.

Override the default font or color for axes and chart values

Select the lock icon in the toolbar and unlock the chart object,You can also Click on the chart body by clicking on the place between the axes, and modify the Background Color or Foreground Color or Font or Fill Effects property.

To Resize the chart

Below the options for Positioning, modify the Size & Overflow property.

 Insert a background image or watermark in the chart body, that is, the space between the axes

Select the lock icon in the toolbar and unlock the chart object, click on the chart body by clicking between the axes, and change the Background Image property.

IF THEN ELSE and CASE in FILTER

You can't directly use the case statement in a filter expression inorder to change the filter condition according to the prompt selection by a user.To acheive the result it can be done in two ways one is we can use a nested case expression

Methode 1:
case when ?p_param?=1 then
    filter1
else case when ?p_param?=2 then
    filter 2
end
end

Methode 2:

The same result can be acheived by using if else if .
eg:

if (?p_param? = 'CURRENT DAY')

then ([gosales].[Sales].[Current
Day]=[gosales].[Daily Calendar].[Current Day])

else if (?p_param? = 'WTD')
then ([gosales].[Sales].[WTD]
=[gosales].[Daily Calendar].[WTD])

else if (?p_param? = 'PTD')
then ([gosales].[Sales].[PTD]
=[gosales].[Daily Calendar].[PTD])

else if (?p_param? = 'YTD')
then ([gosales].[Sales].[YTD]
=[gosales].[Daily Calendar].[YTD])

else (0)

Apply a new template to an existing report in Report Studio

Use the ... and .. tags in the template xml file to replace these two parts in the Report xml file.

Steps:

1.) Open the template in the Studio and click Tools, Copy Report to Clipboard
2.) Open Notepad (or similar text editor) and paste the template xml copied in step #1
3.) Open the existing report in Report Studio and click Tools, Copy Report to Clipboard.
4.) Open another instance of Notepad (etc), and paste the report xml copied in step #3
5.) Click on the notepad instance with the template xml contents (to give it focus).  Find and highlight the section from to , and copy it.
6.) Return to the instance of Notepad with the report xml (from step #4).  Find and highlight the section from to , and paste in the copied XML from the template XML file.
7.) Repeat steps 5 and 6 for to .
8.) Within the modified report XML instance of Notepad, do a "Select all" (Ctrl-A, right-click menu, or from the toolbar menu) and copy the entire contents.
9.) Within Report Studio, click Tools, then Copy Report from Clipboard.

Installation of Cognos8.4 with Oracle Database and Apache Http Server

Step 1

Install Cognos components. This will take a lot and I recommend to restart the computer between every three components or so, in order to clear the cache, or whatever it is that it makes it run slower.
1.1 Create a folder Cognos in C drive or D drive and copy all the zip files from the installation CD to that folder.
1.2  Unzip the zip files in Cognos folder ( For example, right click the zip file Cognos 8 BI Server 8.3.7z --> ZipGenius --> Extract here, to Cognos 8 BI Server 8.3)
1.3 Open the Win32 folder created under the extracted folder and run the issetup.exe file. Do this for   Cognos 8 BI Server 8.3.7z, Cognos 8 BI Modeling 8.3, Cognos 8 Business Intelligence Samples 8.3.
Step 2

Download OracleXEUniv.exe from Oracle site and install it. Create a new user “cognos” with any password (I chose "cognos" as well) and grant all privileges to it. (NOTE - Character Set of the Database should be UNICODE)
Step 3

Locate ojdbc14.jar in oraclexe\app\oracle\product\10.2.0\server\jdbc\lib and copy it to cognos\c8\webapps\p2pd\WEB-INF\lib
If classes12.jar exists in this folder, delete it or rename it.
Step 4

1.    Download Apache2.2 free from Apache page and install it.
2.    Locate the file httpd.conf file in the installation folder\Conf and add the following text at the bottom:

ScriptAlias /cognos8/cgi-bin "d:/program files/cognos/c8/cgi-bin"

Options FollowSymLinks
AllowOverride FileInfo
Order Allow,Deny
Allow from All


Alias /cognos8 "d:/program files/cognos/c8/webcontent"

Options FollowSymLinks
AllowOverride FileInfo
Order Allow,Deny
Allow from All

Replace d: with c: if necessary.
Restart Apache service.
Step 5

1.    Start Cognos Configuration.
2.    Delete whatever it is under Content Manager and create a new item called “Content Store”, of type Oracle.
3.    Edit the user and password by clicking the pen that appears when selecting the field. User “cognos”, password “cognos”.
4.    Service name is “XE”.
5.    Right click on Content Store and Test.
6.    If all’s right click the green play button to start the service.
7.    You can close Cognos Configuration now, as the service will continue to run in the background.
Step 6

Test that Cognos Connection is working by calling the link http://127.0.0.1/cognos8 or http://localhost/cognos8.
I strongly advise to right click on the Apache icon in the tray bar and select “Open Services”. From this window, set all the Cognos, Oracle and Apache services to start manually instead of automatically. Otherwise all these services will attempt to start automatically on Windows startup and this takes a lot of time.
To start the services manually you have to (in this order):
1.    Click “Start Database” from Oracle start menu
2.    Start Cognos Configuration and click the play button
3.    Start the Apache service from the tray icon

Step 7

1.    You should now import the samples.
2.    Create five users in OracleXE called gosales, gosalesdw, gosaleshr, gosalesmr and gosalesrt. The password should be the same as the user id. Make sure to grant them all the privileges.
3.    Go to cognos\c8\webcontent\samples\datasources\oracle and extract the .gz files.
4.    Under this folder run the following commands:
  imp gosales/gosales@xe file = GOSALES.dmp full=y log=log.txt
  imp gosaleshr/gosaleshr@xe file = GOSALESHR.dmp full=y log=log.txt
  imp gosalesdw/gosalesdw@xe file = GOSALESDW.dmp full=y log=log.txt
  imp gosalesmr/gosalesmr@xe file = GOSALESMR.dmp full=y log=log.txt
  imp gosalesrt/gosalesrt@xe file = GOSALESRT.dmp full=y log=log.txt

Step 8

1.    In Cognos Connection select Cognos Administration and then Configuration.
2.    Click the “New Data Source” button.
3.    Type “gosales” for name and click Next.
4.    Select “Oracle” for type and click Next.
5.    Type “xe” for connection string (small caps needed). Select User ID and Password checkboxes. Enter “gosales” for user ID and the same for password.
6.    Test the connection. In case of failure restart the Oracle database.
7.    If all goes well click Finish.
8.    Repeat the steps for gosalesdw, and the rest.

Step 9

1.    Open Framework Manager.
2.    Open project C:\Program Files\cognos\c8\webcontent\samples\Models\ great_outdoors_sales\ great_outdoors_sales.cpf
3.    If you get an error during opening try replacing localhost:80 with 127.0.0.1:80 in Cognos Configuration gateway URI.
4.    Expand Data Sources and for each data source check that the “Content Manager Datasource” and “Schema” have the same value (gosales, gosalesdw,…).
5.    Also modify the Interface (under Type) to “OR” instead of “OL”.
6.    Test each Data Source. In case of failure restart the Oracle database. Save your changes to the project file.
7.    Expand Packages and publish each package (right click -> publish packages..).
8.    Ignore the errors.
9.    Save and exit.
10.    Do the same for project C:\Program Files\cognos\c8\webcontent\samples\Models\ great_outdoors_warehouse\great_outdoors_warehouse.cpf

Step 10

1.    Copy Cognos_Samples.zip from c8\webcontent\samples\content to c8\deployment.
2.    Open Cognos Connection and select Cognos Administration -> Configuration -> Content Administration.
3.    Click New Import icon.
4.    Cognos_Samples should appear in the list. Select Next, then Next again.
5.    On the ‘Select the Public Folders Content’ page, select the checkbox to the left of the Cognos_Samples package.
6.    Select Next, Next again, then Import Now.
   

Dynamically Hiding and showing Report columns in cognos report studio by parameter selection

In order to hide or show report columns conditionly you have to use a string variable and assign the values to it then dynamically set the value of the variable according to a parameter chosen by the user.

Steps

1.Create a parameter with choices for the user to choose
2.create a string variable and add values to it same as the parameter choices
3.And write the variable expression
as
if(ParamValue('P_year'))='2009'
then
'2009'
else
'2008'
4.Then go to the properties of report column to show or hide
5.Click the render variable property value
6.choose the string variable as render varaible
7. Then select values so when variable value matches to the selected values the column  will be shown
8.Do the same for all columns to show or hide according to the parameter selected by the user

Conditional expressions in Cognos Reportstudio

 Syntax

if(?monthcode?='1')
then
(' January')
else if(?Report Period?='2')
then
(' February')
else if(?Report Period?='3')
then
(' March')
else if(?Report Period?='4')
then
(' April')
.
.
.
.
.

else if(?Report Period?='12')
then
(' December')


Case when syntax
 
case ?monthcode?
When 1 then 'Jan'
When 2 then 'Feb'
...
When 12 then 'Dec'
end

Upgrde cognos 8.3 to 8.4

I recommend doing a database backup of your content store database. Create a new schema and restore the backup to the new one and use it for the cognos8.4.and when you start 8.4 configuration, it will convert the content store to 8.4.
This avoids the need to do the export all / import all process.If you do the db backup / rename process, all your users & security settings & data sources will still exist in the new content store.
If you use export all, be sure to select all the options - data sources, users, passwords, security settings, etc., etc. Unless you do everything, you'll wind up with an installation that won't allow people into things, etc., etc.
In addition, Export All does not copy individual users' My Folders.
Also, you cannot do a partial restore of an Export All.

Configure framework manager client to communicate with cognos server installed on another machine

Here I am explaining you how to install and configure framework manager  on a client computer.The steps to perform this operation is given below

1.Install framework manager on the client machine
2.Open the cognos configuration
3.Click on the Environment in the explorer
4.Change the Gateway URI to the http://ip:80/cognos8/cgi-bin/cognos.cgi(ip=ip address of the cognos server)
5.Change the Dispatcher URI for external applications to http://ip:9300/p2pd/servlet/dispatch
6.save the settings
7.Close the cognos configuration and open the framework manager and enjoy the work

CFG-ERR-0101 Unable to register Cognos 8 service. Execution of the external process returns an error code value of '2'.

Error

CFG-ERR-0101 Unable to register Cognos 8 service. Execution of the external process returns an error code value of '2'.

Description

When I am trying to install and configure Cognos8.4 I got the above error on XP machine.My installation was successful but while starting the cognos configuration I got the above error.

Solution

The error is raised because of the prevention of registering a cognos service by Mcafee antivirus.I fixed the problem by stoping the Mcafee then configured cognos succefully then restarted Mcafee .Later i added cognos in Mcafee exception list.You can fix it by just adding cognos in the exception list

creating a stored procedure query subject in cognos8 framework manager

In order to create a stored procedure query subject in framework manager you have to create a stored procedure which returning a reference ref_cursor for the result set.Here i giving the code sample

step1
create a package with one reference cursor

create or replace package pkg_ref_cursor
as
type ref_cursor is ref cursor;
end;
/

step2
create a procedure to actually do the task and return the result set

create or replace procedure tfp.getData( p_ref_cursor in out pkg_ref_cursor.ref_cursor,text in varchar2)
as
Begin
-- some code
insert into tfp.tempTable select sysdate,text from DUAL;
-- the result set to return
open p_ref_cursor for SELECT * from TFP.tempTable;
end;
/

step3
now you can directly import this procedure in framework manager and use for creating reports
similar as a table or view

Start and stop cognos service using bat file

startcognos.bat

%ECHO OFF
echo "Starting Cognos 8"
net start "Cognos 8"

stopcognos.bat

%ECHO OFF
ECHO "Stopping Cognos 8"
net stop "Cognos 8"

Cognos Certification Dumps

Latest Cognos8 Business Intelligence Dumps for all of the tests listed below


   1.  Test BI0 -  210 - IBM Cognos 8 BI Professional
   2.  Test COG-105 - IBM Cognos 8 BI Technical Specialist
   3.  Test COG-112 - IBM Cognos 8 BI Author
   4.  Test COG-122 - IBM Cognos 8 BI Administrator
   5.  Test COG-125 - IBM Cognos 8 BI Data Warehouse Developer
   6.  Test COG-132 - IBM Cognos 8 BI Metadata Model Developer
   7.  Test COG-135 - IBM Cognos 8 BI OLAP Developer
   8.  Test COG-145 - IBM Cognos 8 BI Multidimensional Author
   9.  Test COG-180 - IBM Cognos 8 BI Professional
   10.Test COG-300 - IBM Cognos TM1 Analyst
   11.Test COG-310 - IBM Cognos TM1 Developer
   12.Test COG-400 - IBM Cognos 8 Planning Application Consultant
   13.Test COG-480 - IBM Cognos 8 Planning Professional


Please contact me for cognos dumps at   kvrajith@gmail.com
 

Supply Chain Management (SCM)

Supply chain management (SCM) is the management of a network of interconnected businesses involved in the ultimate provision of (business)|product and Service (economics) packages required by end customers (Harland, 1996). Supply Chain Management spans all movement and storage of raw materials, work-in-process inventory, and finished goods from point of origin to point of consumption (supply chain).

Another definition is provided by the APICS Dictionary when it defines SCM as the "design, planning, execution, control, and monitoring of supply chain activities with the objective of creating net value, building a competitive infrastructure, leveraging worldwide logistics, synchronizing supply with demand, and measuring performance globally

   

Enterprise Resource Planning (ERP)

Enterprise Resource Planning (ERP) is a term usually used in conjunction with ERP software or an ERP system which is intended to manage all the information and functions of a business or company from shared data stores.

An ERP system typically has modular hardware and software units and "services" that communicate on a local area network. The modular design allows a business to add or reconfigure modules (perhaps from different vendors) while preserving data integrity in one shared database that may be centralized or distributed

Some organizations — typically those with sufficient in-house IT skills to integrate multiple software products — choose to implement only portions of an ERP system and develop an external interface to other ERP or stand-alone systems for their other application needs. For example, one may choose to use human resource management system from one vendor, and perform the integration between the systems themselves.[citation needed]

This is common to retailers[citation needed], where even a mid-sized retailer will have a discrete Point-of-Sale (POS) product and financials application, then a series of specialized applications to handle business requirements such as warehouse management, staff rostering, merchandising and logistics.

Ideally, ERP delivers a single database that contains all data for the various software modules that typically address areas such as

Manufacturing
    Engineering, bills of material, scheduling, capacity, workflow management, quality control, cost management, manufacturing process, manufacturing projects, manufacturing flow
Supply chain management
    Order to cash, inventory, order entry, purchasing, product configurator, supply chain planning, supplier scheduling, inspection of goods, claim processing, commission calculation
Financials
    General ledger, cash management, accounts payable, accounts receivable, fixed assets
Project management
    Costing, billing, time and expense, performance units, activity management
Human resources
    Human resources, payroll, training, time and attendance, rostering, benefits
Customer relationship management
    Sales and marketing, commissions, service, customer contact and call center support

Data services
    various "self-service" interfaces for customers, suppliers, and/or employees
Access control
    management of user privileges for various processes

Customer Relationship Management (CRM)

Customer relationship management (CRM) are methods that companies use to interact with customers. The methods include employee training and special purpose CRM software. There is an emphasis on handling incoming customer phone calls and email, although the information collected by CRM software may also be used for promotion, and surveys such as those polling customer satisfaction.

Initiatives often fail because implementation was limited to software installation, without providing the context, support and understanding for employees to learn.[1] Tools for customer relationship management should be implemented "only after a well-devised strategy and operational plan are put in place".

Other problems occur when failing to think of sales as the output of a process that itself needs to be studied and taken into account when planning automation

SAP Products

 Customer Relationship Management (CRM)

 Enterprise Resource Planning (ERP)

 Product Lifecycle Management (PLM)

 Supplier Relationship Management (SRM)

 SAP Business Objects Suite (BOBJ)
 SAP Advanced Planner and Optimizer (APO)
 SAP Apparel and Footwear Solution (AFS)
 SAP Business Information Warehouse (BW)
 SAP Business Intelligence (BI)
 SAP Catalog Content Management (CCM)
 SAP Enterprise Buyer Professional (EBP)
 SAP Enterprise Learning
 SAP Portal (EP)
 SAP Exchange Infrastructure (XI)
 Governance, Risk and Compliance (GRC)
 Enterprise central Component (ECC)
  SAP Human Resource Management Systems (HRMS)
  SAP Internet Transaction Server (ITS)
  SAP Incentive and Commission Management (ICM)
  SAP Knowledge Warehouse (KW)
  SAP Master Data Management (MDM)
  SAP Service and Asset Management
  SAP Solutions for mobile business
  SAP Solution Composer
  SAP Strategic Enterprise Management (SEM)
  SAP Test Data Migration Server (TDMS)
  SAP Training and Event Management (TEM)
  SAP NetWeaver Application Server (Web AS)
  SAP xApps
  SAP Supply Chain Performance Management (SCPM)