COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: MrO on 05 Jan 2006 06:45:16 AM

Title: [Solved] Use D-CUBE (Enterprise planner) as source
Post by: MrO on 05 Jan 2006 06:45:16 AM
Hello all,

Is it possible to use a Enterprise planner D-CUBE in CRN (or Porwerplay)? If so, how?


Thanks a bunch!
Title: Re: Use D-CUBE (Enterprise planner) as source
Post by: MrO on 06 Jan 2006 03:39:31 AM
up
Title: Re: Use D-CUBE (Enterprise planner) as source
Post by: nrh on 08 Jan 2006 06:34:58 PM
Yes it is possible but in my experience the performanace is terrible. There is an option to publish to star-schema from one of the menus.

We have found that the best way to achieve this is to export to csv, then use DTS to take the data into a SQL server database and then to build an FM model on the db.

Rgds,

nrh.
Title: Re: Use D-CUBE (Enterprise planner) as source
Post by: MrO on 09 Jan 2006 08:59:36 AM
This helps, thank you.