Reports on DMR Package/Cubes

[AnilKumarV]

Hi, I need advise on learing how to create report studio reports using DMR Package or cubes. Please show me the way to find books or links to understand about DMR reporting.

Thanks & Regards,
Anil

[tjohnson3050]

Dimensional reporting is a discipline all it's own.  The first thing you need to do is forget everything you know about relational reporting and SQL.  Reporting with dimensional data sources (DMR / Cubes) requires learning a different language (MDX).  IBM offers a separate three day class on dimensional reporting.  I would recommend taking that class if you can. 

Here are couple links to get you started:

Dimensional Style Reporting:
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc%2Fc_cr_rptstd_dimensional_reporting_style.html


Dimensional Functions:
http://www.ibm.com/developerworks/data/library/cognos/page82.html


IBM Cognos Course for Dimensional Reporting:
http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_description&courseCode=I5161