Question:
Hi Pls explain me the best way of aggregate design so that all queries can use it.
Answer:
there is a aggregate wizard ...
it calculates the best aggregates via usage of the queries (statistic cubes) ...
this should help
Answer:
actually it proposes many aggregates.so i am confused which one to use.
pls provide more details on this.
Answer:
there are some know how documents in the marketplace regarding aggregate building ...
the "wizard" is very intuitive ... so just try and get some expericences ...
you can't destroy anything