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

Slow Cube processing and generating very large files UDA

Started by Vhmd989, 15 Sep 2016 01:32:53 PM

Previous topic - Next topic

Vhmd989

Hello good afternoon,

I would like the help of you.

We have two IBM Cognos Business Intelligence 10.2.1 installed environments, an approval and other production.

Recently a maintenance was performed on the IBM Cognos Framework Manager project. Was included in the framework of the query a 'case when ".

After conducting this change, the process the transfemer Cube using this framework, the processing was very degraded in the production environment.

While the homologation environment processing takes about 30 minutes, production exceeds 1 hour and 30 minutes and still error occurs because the file grows so .UDA (50GB) Bursting size available in the production environment.

Some observations:

The two environments point to the same bank.
In the homologation environment does not generate the file .UDA
There are installed trasformer 10.2.1