I am developing the tool to generate statistics information for infocubes and odsobjects, I want to know the best approach to be followed from among the two methods:
1 method: Gather statistics for all infocubes odsobjects and store in a transparent table, and display it according to the user selection whether
Infocube Options: fact, fact&dim , aggregates, indexes.
ODS options: active table, all tables, indexes.
2 method: Gather statistics based on user selection for the options provided, and then display the report.
So which is the most efficient method, i prefer the first one, any help or suggestion will be of great help.