i got this questiom
I want to know about perfomance... what is better?
Lets think this scenario: if I have a query which want to compare data 2009 and 2010 (lets imagine they have more and less same records (forget about aggregate)
which is the best way?
a) MB : Infocube 2008 + Infocube 2009 + Infocube 2010
b) MB: Infocube 2008 + Infocube (2009+2010) //
the option b) its best way to select to database? because its just doing one select .. else a) two selects.
so, which would be the best approach a) or b) and why?