[AccessD] OLAP Cubes

They ARE all they appear to be, but you must understand one thing: they must
be created beforehand. That can take a while. On the other hand, once they
have been created, updating them with new data is relatively trivial. They
pre-compute all their results, which is why everything is instantaneous, but
for sure they WOW the managerial types.

I'm no expert, but my rule of thumb so far is, create a dimension for every
foreign key, plus the date dimension of course. The latter automatically
divides the data into units such as year, quarter, month and week.

Have fun!
Arthur


On 5/21/07, Keith Williamson <Kwilliamson at rtkl.com> wrote:
>
> Anybody do anything with OLAP Cubes?  I was at a conference this past
> weekend, and saw a demonstration of one.  WOW!!!  Very fast, and
> appeared easy to use.  I use an Access database to store static
> month-end financial summaries, and additional information, to enable us
> to print our month-end reports (linked to our SQL-based application.)
> If these OLAP cubes are all they appear to be.....it will greatly
> decrease my processing speed for the financial statements.
>
> Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com
>
> RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
> 21231-3305
>
> 410-537-6098 direct | 410-276-4182 fax | www.rtkl.com
>
> --------------------------------------------------------------------------------
> The information contained in this communication is confidential, may be
> privileged and is intended for the exclusive use of the above named
> addressee(s). If you are not the intended recipient(s), you are expressly
> prohibited from copying, distributing, disseminating, or in any other way
> using any of the information contained within this communication. If you
> have received this communication in error, please contact the sender by
> telephone at (410) 537-6000 or by response via e-mail and permanently delete
> the original email and any copies.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>