steps for bulding a cube based on reports

[shyera]

Can any one explain the steps for building a cube from cognos reports.

Can a report be based of multiple tables or should they be seggregated on based on one report for one table?

Please list the best practices for the faster cubebuild.

Thanks
Shyera

[dhavcog]

Hi shreya,

currently , i am doing the same thing,, i was building cube from iqd,, now i am using source report to get all dimension and facts,

i am creating only one report with multiple queires,, thats helps managing data source,,,

multiple dimension and facts,, but make sure you do right relationship between them.

forwarding you link for one of the nice doc i have came accross to,,,

http://www.ibm.com/developerworks/data/library/cognos/modeling/transformer/page512.html