If you are unable to create a new account, please email support@bspsoftware.com

 

Cognos Planning Limitations, whats are the limitations? Whats a large model?

Started by MC, 14 Jan 2011 01:41:50 PM

Previous topic - Next topic

MC

Hi All

We are currently running into problems which I believe are due to the size of the applications within analyst and the complexities we have but I was hoping that you guys might be able to give me a rough idea of what is considered the limits of planning.

I know IBM have released a document stating...

Number of cubes:  20
Number of Dlinks:   40
Total number of cells in an application: 2,500,000
Largest Cube: 1,250,000
Total Number of d-list items in application: 5000
Largest dimension: 3000

with the warning "Exceeding these numbers may not be a problem for your application, but could slow down the end user, and a redesign of the model in Cognos Planning Analyst could help"

Our current model is

20 Cubes
27 Dlinks
Cells per application e.list slice: 23 000 000
Largest cube 10 000 000
Total Dlist items: 5200
Largest Dimension 2500


What are the limits that you have found in your experience of Cognos Planning? And what are the problems that are incurred by exceeding the limits?

Thanks



ericlfg

MC,

Please see my other post to your other message regarding your GTP errors.  The specifications you've quoted regarding the sizing is for Cognos 10, everything released prior to 10 is much smaller.  As in my other post, I've seen only one other application run successfully at 44 million cells / slice.  I've seen many applications running well at 20 million.  Regardless, I understand that business requirements sometimes need larger models -- but splitting things up and using more administrative functions (admin links) is generally the best practice.

There is no 'limit' that I can give you, it's completely dependent on the design and configuration of the model and the various areas in the CAC that can define the applications structure.

From looking at your application, I would expect that if you are not cutting things down with No Data Access tables and cut down models you wouldn't be able to reconcile.

Cheers

jviegasbi4all

Hi,

Maybe this question is not out of scope regarding planning limitations (if so, I'm sorry for not doing a new post).

I'm close to the end of a planning implementation and facing some problems with some administration links using A-tables.

Is there any known limitation for:

a) using two a-tables to link two diferent dimensions between source and target d-cubes;
b) limitation regarding the a-table lenght. I'm facing more problems with an a-table with 1075 linked elements through SQL scrypt to a view.

Thanks in advance for the time taken.

Jorge Viegas