|
Usually, it is recommended that all reporting occur off of InfoCubes, as performance will be better. It is still necessary at times to look at line item details, but you're going to have performance issues, as you've identified.
There are many architectural considerations to your question as you may want to look at how you've modeled your data and how you have rolled up InfoProviders from a level of ODS objects to InfoCubes and again up to MultiCubes. With the right data architecture, you can push most reporting to a cube level and use jump targets or report-report-interfacing to access line item data is a controlled manner when required.
|