Skip to Content
0
Former Member
Sep 10, 2007 at 02:08 PM

Dimension tables and BPS performance

24 Views

Hi gurus!

I have read a few guides about BPS performance here in SDN but haven't found any guidelines how to implement transactional infocubes in an effective way when it comes to performance.

Should I configure the dimensions so that all variable characteristics in layout selections and characteristics in key columns of layouts are in a same dimension? I suppose this would decrease the number of sql joins in running a layout, but then again would increase the size of a dimension table. Which is more important in achieving a good performance in general?

Thankful for experienced advice

Sari Kolsi