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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic cube performance really slow

Started by zgeorge, 18 Apr 2019 07:33:23 AM

Previous topic - Next topic

zgeorge

Hello Cognos Dynamic Cube masters!

We have created dimensions in our dynamic cube designer that are built to allow for drill downs in specific reports. We have noticed some really slow performance when using these dimensions and have come across the error messages in the image attached. Can anyone provide some insight on what I need to do to fix these performance issues based on the error messages?

bus_pass_man

I think you'll find that those are warnings, not errors. 

The messages are trying to identify situations which could be problematic but are not deterministically so.

Without knowing your data warehouse, the validity of the design of your dynamic cubes (such as the design of the problematic dimensions and your aggregates setup), the performance problems you're having, the scenarios in which the problems, and mundane things such as what sort of hardware you're trying to use, all I can say is download the dynamic cubes redbook and, possibly, the dynamic query redbook and work your way through the troubleshooting sections and also to read the text of the messages and try to understand whether they are valid or the design trade-offs that you need to accept.

'Fact acct sls drill' sound like an odd name for a dimension, especially the fact part.  The fact that you have a level in it  called internal distribution channel, another level in it called product type, and another called plan core business unit suggests that something is particularly odd with that dimension.  Those sound like levels from completely different dimensions rather than levels of a single dimension.