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