Which of the following techniques can be used to improve performance of PowerCubes in Cognos 8 BI?
A. Run the cube through the pcoptimizer utility that is shipped with Cognos 8 BI.
B. Enable the Allow dynamic usage of dimension information governor in Framework Manager.
C. Edit the EnablePCOptimizer entry in the Cognos.ini file so that its value=1, and then rebuild the cube.
D. Ensure that the Pass-through SQL setting is enabled on all regular dimensions in the Framework Manager model.
Answer:A
Which of the following techniques can be used to improve performance of PowerCubes in Cognos 8 BI?
A. Run the cube through the pcoptimizer utility that is shipped with Cognos 8 BI. B. Enable the Allow dynamic usage of dimension information governor in Framework Manager. C. Edit the EnablePCOptimizer entry in the Cognos.ini file so that its value=1, and then rebuild the cube. D. Ensure that the Pass-through SQL setting is enabled on all regular dimensions in the Framework Manager model.