Universe Design Best Practices for Oracle

[Former Member]

Hello All,

We recently moved from XIR2 on MS SQL 2005 to XI 3.1 on Oracle. This has been a difficult move for us as my team is new to oracle. I'm currently working on several performance issues between BOBJ and Oracle and am looking for documentation on best practices for universe design with oracle. I've foudn tidbits here and there regrading using parameters joing_by_sql and boundary_weight_table, wondering if there are other options out there that might help. We have queries taking 45+ minutes to run and that is totally unacceptable.

thanks

Andrea

[former_member207342]

I am not sure if you are looking for Optimization or anything else. sorry for that following link might help you considering Oracle as DB.

Link:[Universe Optimization 1|http://www.bidwtoday.com/business-objects/universe-designer/business-objects-universe-optimization/]

Link:[Universe Optimization 2|http://forums.sdn.sap.com/post!reply.jspa?messageID=8721932]

--Kuldeep

[Former Member]

thanks - the second link doesn't go anywhere - it brings me to a reply to message page??