I have an InfoCube that has a significant performance problem due to a very large (degenerative) dimension. I am working in a 7.0 SPS 13 environment. I want to reconfigure the InfoCube dimensions without having to reload the InfoCube from the source system. Please provide a step by step process for completing this task. In addition, this InfoCube receives it's dataload from an DSO. This DSO is huge, and is very slow when utilizing the report to report interface. So, I believe I should partition the DSO and I believe the only option is a "physical" partition? I wonder if there is a "logical" partition method similar to what is available for an InfoCube?
Thank you so much for your help.