Hello experts!
If I make a Query which reads all characteristics(say 10) and all key figures (say 3) so that there is no aggregation, what would be the best Object to take? ODS or InfoCube? Why?
I think InfoCube is excellent for navigation and aggregation but ODS is for data in detail ok. But what if I have 9 million records and performance is poor? Is the only way to build secondary indices? On which fields if all should be selective?
What is best practise in this case?
Best Regards,
Peter