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