Tuesday, December 10, 2013

Qlikview Basic Tutorial - Load Inline - Free Training Part- 3 of 40

Sunday, August 25, 2013

Cognos 10 Course Details

Cognos 10 Course Detailed Description

Whats new Cognos 10 BI
Overview of Business Intelligence

• What is Business Intelligence
• Why is BI Important and where can we use it
• Components of BI
• Business Intelligence Roadmap


Overview of Data Warehousing
• What is Data Warehouse, Why do we need it
• Data Warehouse Architecture and its components
• Define Star Schema - Fact and Dimensions
• Understand OLTP and OLAP Systems


Overview of Cognos 10 BI and Architecture
• Introduce Cognos 10 BI
• Whats new Cognos 10 BI
• Examine the different studios in Cognos 8 BI
• Identify the different data sources within the studios
• Highlight key cap abilities of Cognos 8 BI
• Understand Cognos Multi Layered architecture


Cognos 10 Installations and Configuration
• Installing Cognos 10
• Install Framework Manager
• Install Cognos BI Application
• Setting up the Environment
• Configuring Cognos 10
• Setting up Samples in Cognos 10
• Uninstalling Cognos 10


Cognos 10 BI Administration
• Create and Modify a Data Source
• Create Database backups
• Understand Roles, Users and Groups
• Specify Permission Settings


Cognos 10 Connection Administration
• What is Cognos Connection
• Examine Cognos Connection UI elements , Create a URL, Login, Logoff
• Entry Properties: General Properties, Permissions, Report, Query, Analysis, Job, Agent and Page Properties
• Navigation- Public and Private Folder
• Open reports with Report Name, Go to Links, Run Reports from a View
• Run Reports- Prompt Pages, Printing a report and Open in Excel
• View the run history of a report and Historical Reports
• Closing and Creating Quick links to Reports , My Folder Shortcut and Browser Bookmark
• Personalize Cognos Connection
• Backups- Export of Cognos, Content Store or select items for Backups
• Restore an exported Backup
• Create and Customize a Page and share a single page with Multiple Users


Cognos 10 Query Studio
• Introduction to Query Studio
• Create Reports (List, Grouped List, Crosstab, Charts)
• Changing the Appearance of Reports (Format)
• Sorting and Grouping
• Filters and Prompts
• Subtotals and Calculations
• Run and Manage Reports
• Drill Through reports


Cognos 10 Analysis Studio
• Introduction to Analysis Studio
• Creating a Basic Analysis
• Working with data in Crosstab
• Exploring Data
• Limiting Data
• Calculating Data
• Sharing Data


Cognos 10 Report Studio
• Introduction to Report Studio
• Report Studio User Interface
• Creating, Save and Run Reports
• Report Templates
• Managing Reports
• Types of Reports
• Active Reports
• List Reports
• Crosstab Reports
• Charts
• Formatting a Report
• Report Layout Guidelines
• Fonts, Styles, Header, Footer and Borders
• Insert objects
• Swap Columns and Rows
• Working with Data
• Filters, Parameters and Prompts
• Sorting and Grouping
• Subtotals and Calculations
• Working with Queries
• Working with Reports
• Managing changes in the Package
• Conditional Formatting
• Drill-through Reports
• Drill-up/Drill-down Reports
• Master-Detail Reports
• Scheduling Reports


Cognos 10 Framework Manager
• Introduction to Framework Manager
• Framework Manager Basics
• User Interface, Navigation, Objects
• Planning the project and data model. Framework Manager Workflow
• Naming Conventions for objects in a project
• Designing Project
• Create project
• Importing Metadata from one and more sources
• Exporting Metadata
• Data Sources
• Working with Data Source Connections
• Create and Modify Data Sources
• Improve Performance by setting Query Processing Type
• Preparing Relational Meta data for use in Reports
• Verifying Relationships
• Working with Dimensions
• Working with Query Subjects- Data, Model and Stored Procedure Query Subject
• Working with Query Items- Set Usage and Aggregate Property
• Making Metadata Available to Report Authors
• Verify Model
• Set Governors
• Improving Performance
• Create or Modify Package
• Controlling access to Metadata
• Explore Package
• Publish Package
• Guideline for Modeling Metadata
• Best Practices , Presentation and Database layers
• Merge Metadata
• Perform Calculations and Filters
IBM Cognos 10 Business Insight Advanced:
Highlight Report Data
  • understand query item properties
  • use formatting to improve the visual effectiveness of a report
  • use conditional styles to highlight query items on a report
Integrate External Data
  • use external data in reports
  • map query subjects from an enterprise report to external data
Analyze Your Data
  • name four data analysis processes
  • implement a report for each process
Use Report Development Processes to Design Effective Reports
  • discuss phases of report development for business authors
  • discuss elements of effective reports
Extend Business Insight Advanced Reports with Report Studio
  • identify Business Insight Advanced reports that can benefit from Report Studio capabilities
  • create a report in Report Studio and open it in Business Insight Advanced
  • create a report in Business Insight Advanced and extend it in Report Studio
Cognos 10 Business Insight:
  • Introduction.
  • Getting your bearings in Cognos 10.
  • Create your first dashboard page.
  • Meet all the new visualization objects.
  • Understand the difference between Business Insight and Connection.
  • Assemble your own interactive dashboards.
  • Reuse Cognos standard reports and lift them to a higher level of usability with Business Insight.
  • Be familiar with all the new visualization techniques that Cognos
·         Build a dynamic dashboard and make it reusable for other users




Thursday, August 15, 2013

Qlikview Online Training | Qlikview Training in Mumbai

Qlikview LIVE Project Implementation.

Experience Counts!!!


Qlikview Online Training / Qlikview Training Institute in Mumbai.
Please contact.
New batches starting on 16th August 2013.

Thanks and Regards,
Bharati DW Consultancy
cell: +1-562-646-6746 / +91-8082112148 

Qlikview ONLINE TRAINING | Qlikview TRAINING IN MUMBAI

Tuesday, August 13, 2013

Qlikview Tutorial - Star Schema Model Part-2-of-40

Qlikview Tutorial - Star Schema Model Part-2-of-40

In this video, we will create Star Schema in Qlikview

1- We have a Star Schema, with a Fact table and 3 Dimension Tables.
The goal to get the Star Schema model, create joins & make it available to crate reports.
Let's take a look at the model in SalesDatabase.
Customer Dimension, Product Dimension, Calendar Dimension & Sales Fact

2- Open Qlikview
3- Click on Edit Script Icon
3- On the lower left side, an option to select multiple data sources is provided.
4- Connect to the database using an ODBC connection. Use OLEDB for MDB.
5- Once the connection is set, the qlikview puts the connection string in the script.
6- Click on the "Select" button to pull the required tables.
7- Click on Reload.
8- Click on the Table viewer (Ctrl + T). 
Please note that Qlikview uses the column names to JOIN / identify relationships.

9- For joining two tables with different columns uses aliases. 
You can specify alias name "as [<column_name>]" e.g: "as [Time]"
Modify the script to add aliases.

10- Press reload & click on OK.
Go back to table viewer & you can see the joins getting created.

11- Add a List Object and display data by Product Category, Country, Year, Sales Amount & Quantity.

SO THATS IT....

Qlikview Training 
by
Bharati DW Consultancy 
cell: +1-562-646-6746 / +91-8082112148
email:  info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com 
website: http://bharaticonsultancy.in/


Monday, August 5, 2013

Qlikview Online Training - Create Basic Dashboard Part-1-of-40

Qlikview Online Training
by
Bharati DW Consultancy
cell: +1-562-646-6746 / +91-8082112148
email:  info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com
website: http://bharaticonsultancy.in/


Qlikview Training - Create Basic Dashboard Part-1-of-40

In this video, we will create a basic dashboard in Qlikview

1- Open Qlikview
2- Click on Edit Script Icon
3- Load the SalesData.csv File
4- Please note the LOAD scrupt to get the data.
5- Click on Reload.
6- Right click the white space in the sheet.
7- Add a new list object.
8- Display Country wise Sales.
9- Again Add a Chart Object and display data by Product Category.
10 - Right click on the List Object --> Properties --> General Tab
11- On the right side set the Fast Change option.
12- You can add multiple objects and create a dashboard.

SO THATS IT....



Tuesday, July 9, 2013

Cognos Online Training | Cognos Training in Mumbai

Cognos LIVE Project Implementation.

Experience Counts!!!

IBM Cognos  BI Series 10, Cognos TM1 , Cognos Planning, Training in Mumbai.
Please contact.
New batches starting on 15th July 2013.

Thanks and Regards,
Bharati DW Consultancy
cell: +1-562-646-6746 / +91-8082112148 

COGNOS 10 ONLINE TRAINING | COGNOS 10 TRAINING IN MUMBAI

Thursday, April 25, 2013

Creating a Cognos Transformer cube from DMR

For Details: Visit:  http://www.bharaticonsultancy.in
   
http://bharatidwconsultancy.blogspot.com

Creating a Cognos Transformer cube from DMR.
Often in our projects, due to slow performance of the DMR, at times we face a situation to convert the DMR into a physical Transformer cube. Here is a simple method to achieve this functionality.
STEPS:
1- Open a Cognos Powerplay Transformer model.
2- Right click the Dimension Map and Insert Dimension from a Package.
3- Browse to already published DMR Package.
4- Select all the Regular Dimensions and Measure Dimension and bring it in the Cube.
5- You can see a datasource is created for Each Regular and Measure Dimension.
6- Now we need to create cube.
7- Right click Cube Tab Area. Insert Powercube; Give a name DMR-2-Cube. It is stored as .mdc. Set a path.
8- Right click again the powercube and create powercube.
9- The cube is generated successfully. Publish this cube onto Cognos Portal.


SO THATS IT.....

Wednesday, April 24, 2013

Cognos Powerplay Transformer - Automate cubes generation refresh script - P-16-of-30


Cognos Powerplay Transformer - Automate cubes generation refresh script - Part-16-of-30


For Details: Visit: http://www.bharaticonsultancy.in 
http://bharatidwconsultancy.blogspot.com 


Automating a Cognos Transformer cube generation process.

Often in our projects, we want to automate the cube to refresh process.
Let's understand the cube automation script.

STEPS:
1- Open a Cognos Powerplay Transformer model.
2- Validate the model.
3- Goto the the transformer installation location and locate the bin directory. 
4- Launch the command prompt and execute the following command
cogtr -n "C:\Documents and Settings\admin\My Documents\Transformer\Models\bdcs_cube.pyj"
syntax: cogtr -n <model name>

5- You can see the cube getting generated.
6- Now we need to create a windows batch file to schedule / automate  the cube refresh process.

7- Open the notepad and create a batch file with the following commands.

cd "C:\Program Files\cognos\c8 Trnsfmr\bin"
cogtr -n "C:\Documents and Settings\admin\My Documents\Transformer\Models\bdcs_cube.pyj"

8- Now to automate it, you can use windows scheduler. 
9- You can see at the pre-set time the cube gets refreshed.

Please note that this will work only for Window server based Cognos Installation. For Unix / Linux the process is a bit different.

SO THATS IT..... 


Monday, April 22, 2013

Creating Calculations Cognos Powerplay Transformer Cubes

For Details: Visit:  http://www.bharaticonsultancy.in
   http://bharatidwconsultancy.blogspot.com
P7- Creating Calculations Cognos Powerplay Transformer Cubes
Creating Calculated Measures and Category Counts.

STEPS:
1- Open the Cognos Powerplay Transformer
2- Right click the Measures Area, and click on New Measure
3- Set a name as Sales Cost
4- Click on the Type Tab and select Calculation.
5- Sales cost = Sales Quantity * Sales Amount
6- Click on OK. Sales Cost appears in the measure list.
7- Again Create a new Measure
8- Set a name as Product Count. Click on the Type Tabe and Click on Category Count.
9- Select the dimension and Level for which you need the count.
10- Now we need to create cube.
11- Right click Cube Tab Area. Insert Powercube; Give a name. It is stored as .mdc. Set a path.
12- Right click again the powercube and create powercube.
13- The cube is generated successfully.

SO THATS IT....

Friday, April 19, 2013

Creating a Cognos Partition / Cube Group

For Details: Visit:  http://www.bharaticonsultancy.in
   
http://bharatidwconsultancy.blogspot.com

Creating a Cognos Partition / Cube Group:
How often we find that the cubes get bigger and we need to find some way to get the cubes to trim down for performance.
This can be done through Partition / cube groups.

Let's see how to partition the cube. It can be time based partition or the cube groups.

STEPS:
1- Open a Cognos Powerplay Transformer model.

2- Right click the Powercubes area, click on Insert Powercube.
3- Mention PowerCube name as MyCubeGroup. Click on Cube Group tab.

4- You can enable time based partitioning or select any other dimension.
5- Let's enable time based partioning.
6- You can set the levels of partition.
7- You can notice mulitple cubes for Year.

8- Now, lets partition the cubes based on Country. This can also be used to secure the cube data based on various country users.
9- From the cube group select the country dimension.
10- Generate the cube and you will notice multiple mdc files, one for each country.

SO THATS IT.....

Monday, April 15, 2013

Creating a Cognos Time Dimension - Date and Week Level

For Details: Visit:  http://www.bharaticonsultancy.in
   
http://bharatidwconsultancy.blogspot.com

Creating a Cognos Time Dimension - Date and Week Level:
This is second part of creating Time Dimensions. Please watch the previous video to create a Time Dimension.

1- Open a Cognos Powerplay Transformer model.
2- Right click the Time Dimension and click on Insert Level.
3- Set Name as Week. Select the source as Date and Check the Unique Level selection box.
4- Click on the "Time" Tab. Select the Date Function as Week. You can see the Time Level Ranking automatically Set to 40.
By Default Cognos sets Time Level Ranking for
Year --> 10,
Quarter -->20
Month -->30
Week --> 40 and
Date --> 50


5- Click on OK and you can see the week level getting created.
6- Similarly Create another level for Date
7- Generate Categories and see Time Heirarchy.
8- Clicking on Show Diagram, now you will find the Year --> Quarter --> Month --> Week-->
Date Levels.

SO THATS IT.....






Thursday, April 11, 2013

Creating a Cognos Time Dimension

For Details: Visit:  http://www.bharaticonsultancy.in
   http://bharatidwconsultancy.blogspot.com

Creating a Cognos Time Dimension:
1- Open a Cognos Powerplay Transformer model.
2- Right click the Dimension Map- area, and click on Insert Dimension.
3- Give a name to this Dimension and then select the Dimension type as Time.
4- Click on the "Time" Tab. Select the date column, on which this dimension will be based on.
5- Click on OK and You can see a Time Dimension getting created.
6- Generate Categories and see Time Heirarchy.
7- Clicking on Show Diagram, you will find the Year --> Quarter --> Month Levels.
8- Watch out in the Next video - steps to create Week and Date levels.

SO THATS IT.....



Monday, April 8, 2013

Creating Dimensions Cognos Powerplay Transformer Cubes (using Flat File)

http://www.bharaticonsultancy.in
http://bharatidwconsultancy.blogspot.com



Creating Dimensions Cognos Powerplay Transformer Cubes (using Flat File):
Using Single Flat File:
1- Open the Cognos Powerplay Transformer. Create a New Model.
2- Right click the datasource tab- area, and click on New Datasource.
3- Select source as flat file SalesData.csv
4- Now, create the dimensions & levels. There are multiple ways to create a dimension.
5- Lets create Customer Geo Dimension: Right click the dimension map. Insert Dimension.
6- Give a name to the dimension: Customer Geo Dimension: Drag and drop Country & City
7- Right click the Dimension area and Insert Level. Set source as Cust_id.
8- Next we need to set Label.
9- Click : select label as Customer Name. Source as Customer Code.
10- Now create Product Dimension --> Product Category -- Product Type -- Product
11- Set Product Code as Source and Product Name as Label for PRODUCT LEVEL.
12- Drag Sales Amount and Sales Quantity in the Measures Section.
13- Now we need to create cube.
14- Right click Cube Tab Area. Insert Powercube; Give a name. It is stored as .mdc. Set a path.
15- Right click again the powercube and create powercube.
16- The cube is generated successfully.

SO THATS IT....

Friday, April 5, 2013

Create First Cognos Powerplay Transformer Cubes - Tutorial

http://www.bharaticonsultancy.in
http://bharatidwconsultancy.blogspot.com


Create First Cognos Powerplay Transformer Cubes - Tutorial:

Cognos Transformer is a tool to create Cognos Multidimensional cubes (MOLAP) model; Also, known as Cognos powerplay cubes.
This tool creates a metadata model file with .mdl extension, which generates a physical cube with .mdc extension.


Transformer cubes store data in .mdc file.

Lets create our first Cognos Powerplay Transformer cube.

High level Steps:
Create a Datasource.
Create Dimensions.
Add Levels to Dimensions.
Add Facts.
Inserting a PowerCube.
Create the Powercube: (Inserting data in the cube)
Publishing the cube on Cognos Server.
Accessing the Cube on Cognos Server.


Pre-requisite: You should have Cognos Transformer client installed on your machine and connected to the Cognos server.
We will create our first cube using a .csv file. Keep this file handy.

Detailed Steps:Create a Datasource:
1- Open the Cognos Transformer Client.
2- Click on Create a new model.
3- Give a name of model, MyModel. Click Next.
4- Give a name for the datasource. From the datasource type, select Delimited field text with column titles.
5- Click Next; click Browse and navigate to the .csv file and click next.
6- Uncheck Run Autodesign and click finish.
7- You have successfuly created a datsource.


Create Dimensions:
8- A Dimension consists of one or multiple Hierarchy and a Hierarchy comprises of one or more Levels.
9- Lets create a dimension. Right Click on Dimension Map on top and select Insert Dimension.
10- Give a name to the dimension, Customer Geography Dimension.
11- Keep everything default for now and click on Ok.
12- Similarly, Insert Product Dimension.


Add Levels to Dimensions:
13- Open the datasource and drag and drop Country, City and Customer Name in the Customer Geography Dimension.
14- In the Product Dimension, drag and drop Product Category, Product Type and Product Name.

Please note: This is basic cube, please see further videos; we will use Customer Code and Name both in the Customer level; similarly for Product.

Add Facts.
15- A cube contains atleast a Fact.
16- From the datasource, drag and drop Sales Amount and Sales Quantity into the Facts Area, next to the Datasource.


Inserting a PowerCube:
17- Right click the Powercubes area, click on Insert Powercube.
18- Mention PowerCube name as MyCube.
19- Keep everything default for now and click on Ok.


Create the Powercube: (Inserting data in the cube)
20- Right click on the powercube.
21- Click on Create Selected PowerCube.
22- Cube is successfuly created.


Publishing the cube on Cognos Server:
23- Right the cube and select Publish Powercube as datasource and package.
Keep all default values. We will see the details in the later videos.
Please note, there are other methods of creating a Cube datasource and package; Look at video: Publishing a Cognos Transformer cube / Cognos Powercube.

24- Enter your credentials to connect to the Cognos Server.
25- Click on Ok.


Accessing the Cube on Cognos Server:
26- Logon to the Cognos Portal.
27- Goto Launch and select Analysis Studio.
28- Click on the Package for MyCube.
29- Click on Blank Analysis.
30- Drag and Drop Customer Geography Dimension on the Rows and Product Dimension on the Columns.
31- Drag and Drop Sales Amount in the Intersection of Crosstab.
32- Check the drill up and drill functionality.


So thats it....


Monday, April 1, 2013

Cognos Transformer Self Paced Free Tutorial

1 Basic Cognos Powerplay Transformer Cubes - Tutorial 1-of-30
 
http://www.youtube.com/watch?v=d_rUNLJAUTU

2 Creating Dimensions Cognos Powerplay Transformer Cubes - Tutorial 2-of-30
 
http://www.youtube.com/watch?v=UOZT-IVWjf4

3 Cognos Powerplay Transformer Cubes - Time Dimension - Fundamental Tutorial - P3-of-30
 
http://www.youtube.com/watch?v=Ex82pQ6Mqic

4 Cognos Powerplay Transformer Cubes - Time Dimension - Date - Week - Fundamental Tutorial - P4-of-30
 
http://www.youtube.com/watch?v=vZDEFKLbQME

5 Cognos Transformer Performance Tuning - Time Based Partition - Cube Groups Security - P5-of-30
 
http://www.youtube.com/watch?v=VXdVWBYD1vU

15 Cognos Powerplay Transformer Cubes - Converting DMR Package to Cubes - Tutorial 15-of-30
 
http://www.youtube.com/watch?v=UWvuFv-p9rg


16 Cognos Powerplay Transformer - Automate cubes generation refresh script - P-16-of-30
http://www.youtube.com/watch?v=kqpeavbzxAc


Sunday, March 31, 2013

Cognos Powerplay Transformer Free Training Videos


http://www.bharaticonsultancy.in
http://bharatidwconsultancy.blogspot.com




1 Basic Cognos Powerplay Transformer Cubes - Tutorial 1-of-30
 
http://www.youtube.com/watch?v=d_rUNLJAUTU

2 Creating Dimensions Cognos Powerplay Transformer Cubes - Tutorial 2-of-30
 
http://www.youtube.com/watch?v=UOZT-IVWjf4

3 Cognos Powerplay Transformer Cubes - Time Dimension - Fundamental Tutorial - P3-of-30
 
http://www.youtube.com/watch?v=Ex82pQ6Mqic

4 Cognos Powerplay Transformer Cubes - Time Dimension - Date - Week - Fundamental Tutorial - P4-of-30
 
http://www.youtube.com/watch?v=vZDEFKLbQME

5 Cognos Transformer Performance Tuning - Time Based Partition - Cube Groups Security - P5-of-30
 
http://www.youtube.com/watch?v=VXdVWBYD1vU

15 Cognos Powerplay Transformer Cubes - Converting DMR Package to Cubes - Tutorial 15-of-30
 
http://www.youtube.com/watch?v=UWvuFv-p9rg

Recovering the Cognos Framework Manager Project File cpf file from existing Package

For Details: Visit:  http://www.bharaticonsultancy.in
  http://bharatidwconsultancy.blogspot.com

Recovering the Cognos Framework Manager Project File cpf file from existing Package - P30-of-30
How often in our projects do we loose the cpf file and we have the package on the cognos server.
Here is a simple step to recover the cognos cpf file.

Steps :
1. Create a new file
<Cognos_Installed_location>/configuration/CQEConfig.xml:

<?xml version="1.0" encoding="UTF-8" ?>
<configuration company="Cognos" version="0.1" rendition="cer2">

<component name="CQE">
<section name="General Options">
<entry name="KeepModelXML" value="1" />
</section>
</component>
</configuration>


2. Restart the Cognos server.
3. There is a package known as Sales Order in Public Folder; we dont have cpf file for this.
4. Open Cognos Report Studio and create a new report on the same package.
5. Run the report.
6. A new xml file will be created under <Cognos_Installed_location>/data/cqe/RTModels 7. 7. Rename this file as model.xml
8. Open Framework Manager and create a new empty project.
9. Close Framework Manager.
10. Locate this Framework Manager project and replace the model.xml with our xml from RTModels.
11. Open the project and your cpf is generated; have fun.

SO THATS IT...

Cognos 10 Administrator - Running a Report via Trigger

For Details: Visit:  www.bharaticonsultancy.in
http://www.bharaticonsultancy.in
http://bharatidwconsultancy.blogspot.com


Cognos 10 Administrator - Running a Report via Trigger:
A report can be scheduled based on Daily, Monthly, Weekly, Yearly timeframe or can be event based.
For event based, we use Trigger.
Also, We can also specify the formats in which the reports are to be scheduled.
        

Steps:
1- Click the Scheduling option available in front of every Report --> Sales Report.


2- Specify the run criteria / output format / save method   
For details, watch the video --> Scheduling a Report.


3- Click on the Trigger tab and set a trigger name: bdcs_trigger.
this is the name of the trigger and the command will use this trigger to run the report.
You can have multiple reports with a same trigger name.


4- Now, We need to find the trigger.bat file which is available under
<Cognos_Installation>\webapps\utilities\trigger


5- Open the command line prompt & write the following command
trigger.bat <server_url> <trigger_name>;

trigger.bat "http://<computer_name>/p2pd/servlet/dispatch" bdcs_trigger;

6- You will get a message
Trigger: bdcs_trigger fired successfully


7- You can see the report which are currently running in the Current Activities
8- Future schedules in the upcoming activities.

9- Lets see the output of the report.

SO THATS IT....



New Videos for Cognos 10 Training


29 Cognos 10 Training - Running a Report via Trigger- Tutorial Part 29 of 30
 http://www.youtube.com/watch?v=yhV8Q5SeTSU
30 Cognos 10 Training - Advanced - Recover Framework cpf file from Package -Tutorial Part 30-of-30
 http://www.youtube.com/watch?v=uGxGI8D-hOQ

Friday, March 22, 2013

IBM COGNOS 10 SELF PACED LEARNING TUTORIAL VIDEOS

IBM COGNOS 10 SELF PACED LEARNING TUTORIAL

1 Cognos 10 Training - Report Studio Basics - Part 1 of 30

2 Cognos 10 Training - Creating Prompts  - Part 2 of 30

3 Cognos 10 Training - Creating Cascading Prompts  - Part 3 of 30

4 Cognos 10 Training - Drill Thru Definition  - Part 4 of 30

5 Cognos 10 Training - Master Detail Report  - Part 5 of 30

6 Cognos 10 Training - Advanced RS - Creating Joins  - Part 6 of 30

7 Advanced RS - Creating Unions - Intersect  - Part 7 of 30

8 Cognos 10 Training - Creating Dashboards  - Part 8 of 30

9 Cognos 10 Training - Conditional Formating-Boolean  - Part 9 of 30

10 Cognos 10 Training - Conditional Formating-String   - Part 10 of 30

11 Cognos 10 Training - Report Scheduling  - Part 11 of 30

12 Cognos 10 Training - Advanced RS - Dynamic Grouping  - Part 12 of 30

13 Cognos 10 Training - Creating Datasource  - Part 13 of 30

14 Cognos 10 Training - FM Project RMR  - Part 14 of 30

15 Cognos 10 Training - FM Data Level Security  - Part 15 of 30

16 Cognos 10 Training - Advanced FM - Using Scripts  - Part 16 of 30

17 Cognos 10 Training - FM Dimensional Model - DMR  - Part  17 of 30

18 Cognos 10 Training - Calculations - Filters FM  - Part 18 of 30

19 Cognos 10 Training - Administration Deployment  - Part 19 of 30

20 Cognos 10 Training - Creating Security Groups  - Part 20 of 30

21 Cognos 10 Training - Restoring Sample SQL Database  - Part 21 of 30

22 Active Reports - Data Toggle Button Bar  - Part 22 of 30

23 Active Reports - Data Tab Control Filter & Select  - Part 23 of 30

24 Cognos 10 Training - Business Insight & Advanced - Part 24 of 30

25 Cognos 10 Training - FM Advanced Prompts &Session Parameters P-25 of 30

26 Cognos 10 Training - FM Advanced Parameter Maps Part 26 of 30

27 Cognos 10 Training- Javascript Default Date Prompt Part 27 of 30

28 Cognos 10 Training - Performance Tuning Prompt Page Part 28 of 30
    http://www.youtube.com/watch?v=FY-oGgv6BMU

29 Cognos 10 Training - Running a Report via Trigger- Tutorial Part 29 of 30
 http://www.youtube.com/watch?v=yhV8Q5SeTSU
30 Cognos 10 Training - Advanced - Recover Framework cpf file from Package -Tutorial Part 30-of-30
 http://www.youtube.com/watch?v=uGxGI8D-hOQ

Sunday, March 10, 2013

Cognos Powerplay Transformer Cubes - Time Dimension - Date - Week - Fundamental Tutorial - Part-4-of-30


For Details: Visit: htt://www.bharaticonsultancy.in
http://bharatidwconsultancy.blogspot.com


Creating a Cognos Time Dimension - Date and Week Level:

This is second part of creating Time Dimensions. Please watch the previous video to create a Time Dimension.


1- Open a Cognos Powerplay Transformer model.
2- Right click the Time Dimension and click on Insert Level.
3- Set Name as Week. Select the source as Date and Check the Unique Level selection box.
4- Click on the "Time" Tab. Select the Date Function as Week. You can see the Time Level Ranking automatically Set to 40.

By Default Cognos sets Time Level Ranking for
Year --> 10,
Quarter -->20
Month -->30
Week --> 40 and
Date --> 50

5- Click on OK and you can see the week level getting created.
6- Similarly Create another level for Date
7- Generate Categories and see Time Heirarchy.
8- Clicking on Show Diagram, now you will find the Year --> Quarter --> Month --> Week--> Date Levels.


SO THATS IT.....





Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.
IBM Cognos Powercube Basic free Tutorial for Beginners,
IBM Cognos Powerplay Self Paced Learning Tutorial for Beginners, 
Cognos Powerplay Transformer Cubes basic fundamentals , IBM Cognos Powerplay Certification, IBM Cognos Powerplay Online Free Tutorial for Beginners, 

Visit blog for detailed steps.
http://bharatidwconsultancy.blogspot.com/

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

CONTACT for remaining videos in HD

Bharati DW Consultancy 
cell: +91-8082112148
email:  info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com 
website: http://bharaticonsultancy.in/

Cognos Powerplay Free Online Basic Self Paced Tutorial - Transformer Cubes


Create First Cognos Powerplay Transformer Cubes - self paced free online Tutorial:

Cognos Transformer is a tool to create Cognos Multidimensional cubes (MOLAP) model; Also, known as Cognos powerplay cubes.
This tool creates a metadata model file with .mdl extension, which generates a physical cube with .mdc extension.

Transformer cubes store data in .mdc file.

Lets create our first Cognos Powerplay Transformer cube.

High level Steps:
Create a Datasource.
Create Dimensions.
Add Levels to Dimensions.
Add Facts.
Inserting a PowerCube.
Create the Powercube: (Inserting data in the cube)
Publishing the cube on Cognos Server.
Accessing the Cube on Cognos Server.


Pre-requisite: You should have Cognos Transformer client installed on your machine and connected to the Cognos server.
We will create our first cube using a .csv file. Keep this file handy.

Detailed Steps:
Create a Datasource:
1- Open the Cognos Transformer Client.
2- Click on Create a new model.
3- Give a name of model, MyModel. Click Next.
4- Give a name for the datasource. From the datasource type, select Delimited field text with column titles.
5- Click Next; click Browse and navigate to the .csv file and click next.
6- Uncheck Run Autodesign and click finish.
7- You have successfuly created a datsource.

Create Dimensions:
8- A Dimension consists of one or multiple Hierarchy and a Hierarchy comprises of one or more Levels.
9- Lets create a dimension. Right Click on Dimension Map on top and select Insert Dimension.
10- Give a name to the dimension, Customer Geography Dimension.
11- Keep everything default for now and click on Ok.
12- Similarly, Insert Product Dimension.

Add Levels to Dimensions:
13- Open the datasource and drag and drop Country, City and Customer Name in the Customer Geography Dimension.
14- In the Product Dimension, drag and drop Product Category, Product Type and Product Name.

Please note: This is basic cube, please see further videos; we will use Customer Code and Name both in the Customer level; similarly for Product.


Add Facts.
15- A cube contains atleast a Fact.
16- From the datasource, drag and drop Sales Amount and Sales Quantity into the Facts Area, next to the Datasource.

Inserting a PowerCube:
17- Right click the Powercubes area, click on Insert Powercube.
18- Mention PowerCube name as MyCube.
19- Keep everything default for now and click on Ok.

Create the Powercube: (Inserting data in the cube)
20- Right click on the powercube.
21- Click on Create Selected PowerCube.
22- Cube is successfuly created.

Publishing the cube on Cognos Server:
23- Right the cube and select Publish Powercube as datasource and package.
Keep all default values. We will see the details in the later videos.
Please note, there are other methods of creating a Cube datasource and package; Look at video: Publishing a Cognos Transformer cube / Cognos Powercube.

24- Enter your credentials to connect to the Cognos Server.
25- Click on Ok.

Accessing the Cube on Cognos Server:
26- Logon to the Cognos Portal.
27- Goto Launch and select Analysis Studio.
28- Click on the Package for MyCube.
29- Click on Blank Analysis.
30- Drag and Drop Customer Geography Dimension on the Rows and Product Dimension on the Columns.
31- Drag and Drop Sales Amount in the Intersection of Crosstab.
32- Check the drill up and drill functionality.

So thats it....


Cognos Cubes - Creating Time Dimension Part-3 of 30


For Details: Visit: htt://www.bharaticonsultancy.in
http://bharatidwconsultancy.blogspot.com


Creating a Cognos Time Dimension:

1- Open a Cognos Powerplay Transformer model.
2- Right click the Dimension Map- area, and click on Insert Dimension.
3- Give a name to this Dimension and then select the Dimension type as Time.
4- Click on the "Time" Tab. Select the date column, on which this dimension will be based on.
5- Click on OK and You can see a Time Dimension getting created.
6- Generate Categories and see Time Heirarchy.
7- Clicking on Show Diagram, you will find the Year --> Quarter --> Month Levels.
8- Watch out in the Next video - steps to create Week and Date levels.

SO THATS IT.....



Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.
IBM Cognos Powercube Basic free Tutorial for Beginners,
IBM Cognos Powerplay Self Paced Learning Tutorial for Beginners, 
Cognos Powerplay Transformer Cubes basic fundamentals , IBM Cognos Powerplay Certification, IBM Cognos Powerplay Online Free Tutorial for Beginners, 

Visit blog for detailed steps.
http://bharatidwconsultancy.blogspot.com/

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

CONTACT for remaining videos in HD

Bharati DW Consultancy 
cell: +91-8082112148
email:  info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com 
website: http://bharaticonsultancy.in/

Creating Dimensions Cognos Powerplay Transformer Cubes (using Flat File): Part-2 of 30


Creating Dimensions Cognos Powerplay Transformer Cubes (using Flat File):

Using Single Flat File:
1- Open the Cognos Powerplay Transformer. Create a New Model.
2- Right click the datasource tab- area, and click on New Datasource.
3- Select source as flat file SalesData.csv
4- Now, create the dimensions & levels. There are multiple ways to create a dimension.
5- Lets create Customer Geo Dimension: Right click the dimension map. Insert Dimension.
6- Give a name to the dimension: Customer Geo Dimension: Drag and drop Country & City
7- Right click the Dimension area and Insert Level. Set source as Cust_id.
8- Next we need to set Label.
9- Click : select label as Customer Name. Source as Customer Code.
10- Now create Product Dimension --> Product Category -- Product Type -- Product
11- Set Product Code as Source and Product Name as Label for PRODUCT LEVEL.
12- Drag Sales Amount and Sales Quantity in the Measures Section.
13- Now we need to create cube.
14- Right click Cube Tab Area. Insert Powercube; Give a name. It is stored as .mdc. Set a path.
15- Right click again the powercube and create powercube.
16- The cube is generated successfully.

SO THATS IT....





Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.
IBM Cognos Powercube Basic free Tutorial for Beginners,
IBM Cognos Powerplay Self Paced Learning Tutorial for Beginners,
Cognos Powerplay Transformer Cubes basic fundamentals , IBM Cognos Powerplay Certification, IBM Cognos Powerplay Online Free Tutorial for Beginners,

Visit blog for detailed steps.
http://bharatidwconsultancy.blogspot.com/

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

CONTACT for remaining videos in HD

Bharati DW Consultancy
cell: +91-8082112148
email:  info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com
website: http://bharaticonsultancy.in/