COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: sap on 12 Sep 2008 05:15:14 AM

Title: Associate a measure
Post by: sap on 12 Sep 2008 05:15:14 AM
Hi
i want know under what cirumstances we associate a meassure to (dimension or level????)
as i know by defalut all measures which are in measure pane are associte with dimensions and levels by deafault..
why we need to associate a measure !!!!! whats benfit of doing it...
please explain i am confused ???

thanks to all
Title: Re: Associate a measure
Post by: vijayab on 23 Sep 2008 04:56:02 AM
hi sap,

Its like the primary and foreign key .
e.g. u r taking ur dimensions from Table1 and measures from Table2,
then to fetch data from table1 and Table2 u need to hav one common key in between them .
that is nothing bt the SCOPE between the dimensions,levels and measures.


hope it will help u:))
regards,
vj