As you said you have worked on Cubes and ODS,Which one is better suited for reporting?

Explain and what are the drawbacks n benefits of each one Cubes are best for reporting to queries. It runs faster. In ODS we can have only simple reports. If we query based on Nonkey fields(Data fields) in ODS then, report runs slower. But in ODS we can overwrite, non key fields. But we can not overwrite in Cube. This is one of the disadvantage in Cube.

0 comments: