Bad Data You'll Cry

A song about bad data, BI  or both?

Cognos Framework Manager

Tutorial on Cognos Framework Manager

I am new to Cognos 10.  The last time I used Cognos was more than 10 years ago.  I found the following videos tutorials on Cognos Framework Manager and they were very helpfull. Many thanks to the video owners for sharing.

This video tutorial convers the following topics:

1. Create data sources
2. Create project in Framword Manager
3. Create data modle - DMR
4. Create Calculaticve fields
5. Create packages

The following 5 videoes are tutorials on Cognos Frameword Manager.

1. This video tutorial covers the following topics:

1. Creat data sources
2. Creat data models

2. This video tutorial covers the following topics:

1. Creat Projects
2. Creat data sources
3. Import data structure (meta data)
4. Creat Cognos objects
5. Also covers base concepts of dimension and facts

3.This video tutorial covers the following topics.

1. Object Type
2. - Namespace
3. - Query Object
4. Also covers base concepts of dimension and facts

4.This video tutorial covers the following topics.

1. Relational data model (DMR)
2. Measures
3. Also covers base concepts of dimension and facts

5.This video tutorial covers the following topics.

1. Drill down
2. Define hierarchivies

6.This video tutorial covers the following topics.

1. How Cognos stores data
2. Cognos object type
3. Create namespace
4. XML for Cognos model
5. .cpf file

GET FIRST AND LAST DAY OF A MONTH IN BASH SHELL

GET FIRST AND LAST DAY OF A MONTH IN BASH SHELL

Linux system comes with a date commend. The man page has all the details. The following shows how to get the first date and last day of a month using the date commends in bash shell.

First Day, current month:
# date -d "-0 month -$(($(date +%d)-1)) days"

First Day, last month:
# date -d "-1 month -$(($(date +%d)-1)) days"

Last Day, current month:
# date -d "-$(date +%d) days +1 month"

Last Day, last month:
# date -d "-$(date +%d) days -0 month"

Last Day, month before last month:
# date -d "-$(date +%d) days -1 month"

%d = day of month.