Hi,
We are in the processing of evaluating BWA for one our BW project.
One of our DSO is going to have 1.8TB of data(7 years of data).
Many important queries are going to access that DSO. Definitely we are going to have performance problem. We understand partitioning option is also not available for DSO/ODS.
Since the present version of BWA/BW will not support DSO, is it good advice to convert the DSO into a Cube/Cubes with Line Item Dimensions?. So that BWA can be used . Please advise about this and suggest about any other options. Thanks.
Thanks.
Raj.