Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: philelmousse on 08 Dec 2010 09:29:13 AM

Title: need advices to deal with my project
Post by: philelmousse on 08 Dec 2010 09:29:13 AM
Hi, i have to developp a new cognos project. To goal is to provide some complexe reports and basis report "on demand" to the users. The source database will be an MSSQLSERVER. There will be about 200'000 records and 7 dimensions.
So, should I create a model in framework manager or not ?
Sould i create cube with transformer and developp the reports with report studio ?

I'll take all your advices.

Thanks
Title: Re: need advices to deal with my project
Post by: philelmousse on 13 Dec 2010 09:57:58 AM
wow nobody can give some advices ?  ???
Title: Re: need advices to deal with my project
Post by: jive on 13 Dec 2010 02:34:42 PM
Hi Phil,

I think the decision to build or not a cube, should be based on the complexity of the report and also on the "on demand" report, also where you pick your data should be consider.
If you build a cube each week and the user need report for yesterday data, you will have to rebuild the cube on each demand and build the report after that. If you work with Framework manager, directly connect to a database and then FM model is well design you don't have to do that, you will be ready for different demand even the complex one. Personally, I prefer to work with Framework Manager most of the time.
:-X

Title: Re: need advices to deal with my project
Post by: philelmousse on 14 Dec 2010 04:59:29 AM
ok thanks so there isnt advantage to build a cube ?
Title: Re: need advices to deal with my project
Post by: jive on 14 Dec 2010 09:22:02 AM
There is some advantage to build cube,
1-portability
2-your information are fix in time if you do incremental cube.

But even if you build a cube you will have to do a package in FrameWork manager anyway. So if it's really small, 200k line like you said I don't see any advantage to do a cube. Most important if you have to create user report on demand the cube, like said it's not the best.
Title: Re: need advices to deal with my project
Post by: philelmousse on 21 Dec 2010 09:28:18 AM
My users really wants use PowerPlay so I need a cube. What kind of framework model should I developp ?
Title: Re: need advices to deal with my project
Post by: jive on 22 Dec 2010 10:17:42 AM
If your user want to used powerplay studio, you will have to define FrameWork with each cube. This is what we do here. Take a cube open it with framework, do a presentation layer. Publish the package and let the user work with Powerplay studio or analyst studio. In a cube your dimension are already define by the model used in transformer so the Framework part is more easy to do.

sorry to answer late I was out of town and go back again out of town for a month.
Bye
Text only | Text with Images