Performance Issues / Concerns

[Former Member]

I have to use 213 tables in the universe designer. The database schema is oracle. What kind of issues/concerns should I consider before designing the universe. I appreciate your help.

[Former Member]

Hi ,

The first thing you should consider is that do you really need this many tables in Your Universe ??

Follow the foolowing steps Before designining :

1) Have a clear scope define for Universe , i.e You are designing Universe for Sales Or Marketing or Human Resource etc .

2) Once you know the Scope and Target Audience and purpose is clear then segregate the tables based on your scope i.e define the scope of tables inside your schema

3) Clearly have all the reorting requiremnet in place

Then go for normal design procedure

Regards

Swapnil

[former_member207342]

Hi

Do following tings

1. Follow Universe Design best practices ( search Google and BOB

2. I have written few points to consider while tuning universe have a look

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

Edited by: Kuldeep Chitrakar on Feb 10, 2010 9:24 AM

[Former Member]

Thanks for the suggestions