Print Page - Measures

Title: Measures
Post by: jaganlalrm on 29 May 2013 05:59:04 AM

hi

what is mean measures ?

and how to measures in fact tables.

how we find measures from the table

thanks in advance

Jaganlal.R.M

Title: Re: Measures
Post by: blom0344 on 29 May 2013 06:04:40 AM

A measure is basically - mostly - a numeric value that can be used in aggregations and calculations.
The number of cars sold would be an example. Truly this is really the basics of the basics. Would some training not be in order? Perhaps just reading the FM documentation would answer most of these basic question directly ;)

Title: Re: Measures
Post by: jaganlalrm on 29 May 2013 06:28:39 AM

Thanks

Using measures in fact table in creating Star schema. Its correct

We can using ID or foreign key as measures.

Title: Re: Measures
Post by: Lynn on 29 May 2013 08:04:35 AM

I would also suggest "The Data Warehouse Toolkit" by Ralph Kimball to gain some understanding.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: jaganlalrm on 29 May 2013 05:59:04 AM