Max # of Objects in a universe

[Former Member]

Is there a max # of objects in a cube that can be consumed by a universe (BI 4.0)? I am trying to place a universe on top of a large BW (7.3 SPS 5) cube. I am able to create the universe just fine, but when I try to refresh the structure the designer becomes non-responding.

[Henry_Banks · Accepted solution]

Hi,

If it's a long running WP in the BW side, then it is more likely the .exe of Universe Designer which is maxing out on your client. What the CPU usage and availabel RAM like at that time? You might have more luck on the BIPServer

Also, do check out BW note 1649814 for must-have SP06 BICS corrections.

Regards,

H

[Former Member]

My issue had to do more with the number of objects in the cube (4000+) than anything else. We created smaller BEx reports and everything is working correctly now.

[Former Member]

Hi,

Could you please check the connection properties of the universe connection.

In the connection pool mode if 'Disconnect after each transaction' is selected, you can try testing the issue by selecting 'Keep the connection active for ' in the connection pool mode

Let me know the results of the test

Thank you

Hyder