Skip to Content
0
Former Member
Aug 17, 2011 at 10:54 AM

COPA Data Modelling in BI 7.0 - What is best practice?

30 Views

Hi,

Our datasource of COPA contains approx 200 fields. We have created a single write optimized DSO to get all those 200 fields.

Considering the effects on Database or performance of report , what is the best practice?

a) create a single standard DSO and get all 200 fields with data into it and write a report on top of it?

b) partition the fields and data into multiple write optimized DSO or Standard DSO?

Please advice.