Hi everyone,
There were cell limitations in Cognos Planning 8.4.x, are those still applicable to 10.1.1? Is there any guidance/recommendations available in terms of size of the model? There are very few best practice documents available on IBM site for 10.1.1.
Some parameters to compare against recommendations:
No of Cubes
No of D-links
Total no of cells in the App (per E.list slice)
Largest cube (# of cells)
Total no of D-List Items in App
Largest dimension
E.List (# of items)
Regards,
You can start in the Cognos Knowledge Center Library:
Here is a starting point with limitations for DCubes: http://www-01.ibm.com/support/knowledgecenter/SSWGNW_10.1.0/com.ibm.swg.im.cognos.cp_a.10.1.0.doc/cp_a_id7731WP0162.html%23WP0162
Thanks Danno! The link refers primarily to Dcubes and is certainly a good starting point.
But, I might framed the question incorrectly. So, allow me to rephrase.
We have an application with "Total no of cells in the App (per e.list slice)" parameter at 15 million cells. Additionally, largest cube (number of cells) is also at 14 million cells. Is it something to worry about even when we are on Cognos Planning 10.1.1 (FP2) ?
Regards
In all honesty it depends on the overall size of the application. I have one cube that is that large but the application itself is not that big so the effect is minimal. In the past I did have larger applications with all cubes in that range and they behaved very poorly and I did a redesign where we made three smaller apps based on organizational units. The number of users, the server configuration and the overall Cognos tier design has an impact. So like almost all things IT: it depends and will require load testing :)
There is no real solid answer for this other than be aware that it can be an issue. I personally try not to develop apps with larger foot prints and the version you are on "should" be fine provided your system is properly resourced.