Bonjour,
For ages, I've been precalculating Agregations on Multidimension axes. The Data Bases which I called DataBases for Viewing had records of many Precalculated Levels of agregations.
Depending on the User will, I Extracted the closest Physical levels and had not much agregation to do on line. Zooming was an other access of less agregated lines.
The elegant OLAP definition of Axes in the Masters seem to reject the idea of precalculated levels and seems to do the Agregation on Line.
What did I miss, what should I read ?
Focusely and Cordially

This message has been edited. Last edited by: Kerry,

Bonjour,
Sorry not to give an example out of the File CAR, or to ask a question about How to get a Month out of a Date Format.
OLAP is a way of treating Hierararchies ( Not only one Dimension )
Let's say *Geography : Region State City Stores.
Let's say I've precalculated Agregation Results at several levels.
The Physical Level of agregation on this Axe is indicated in a Field named 'NIVAGR_GEO' which will contain
'4-Store' For Store ,
'2-State' For State , The fields STORE and CITY will contain All Stars
'1-Region' For region , The fields STORE, CITY and STATE will Contain All Stars.

The Agregation Level of City has not been Physically PreCalsulated since There are not so many Stores in a City ( Let's suppose)

Of course All 4 levels of Agregations may be desired by the user Demand for 3-City will be treated by Filtering on '4-store' and Dynamically agregating at the City Level.

In Fact I am completely in line with the Elegant WITHIN approach + a level of Precalculated level I've to Work ( Have to filter on).

This out of Age approach was compatible with quick Response time.
Times they are a changing and even Excel gets over the 6n nnn Max Lines Limit.

But Time Out is, also, a reality.

I Wanted advised ideas and experiences about this classical problem ( How to bring my 90's solutions at the 3rd Millenium level )

Cordialement et Focusement

Hi Baillecl,

I checked with out technicals and we were not sure what exactly you are looking for, so the best channel for assistance would be to open a case with Customer Support Services, so that we can find out if you are hitting the limits and/or getting time outs. To open a case, you may either call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry