[AccessD] OLAP Cubes

Do you know if you can join separate databases (SQL and Access) in the
cube datastream?  Is there really any limitation on how complex the sql
statement is?  My financial statements are based on a couple complex,
nested queries (joining both my access tables and the application sql
tables).

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


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, May 21, 2007 4:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com