OLAP Cubes
 

I am still relatively new to OLAP and just trying to get a better
understanding. If I have created an OLAP cube from my Access Database and it
is pulling into a PivotTable in Excel, is it possible to "pass" values back
to the Database without any additional programming or is just a one-way feed?

Secondly, does the information have to come back in a pivottable? I am
trying to create some reports and I seem to be very restricted with
pivottables.

Hi Steven,

Pivot tables are one-way. You can use VBA to pass data back to your access
db. If yo want to know more about that, check out Ole Erlandsen's site.
http://www.erlandsendata.no/english/...php?t=envbadac

If you want to try something different to pivot tables, look at
http://www.microsoft.com/office/solu...n/default.mspx

Ed Ferrero
http://edferrero.m6.net/

I am still relatively new to OLAP and just trying to get a better
understanding. If I have created an OLAP cube from my Access Database and
it
is pulling into a PivotTable in Excel, is it possible to "pass" values
back
to the Database without any additional programming or is just a one-way
feed?

Secondly, does the information have to come back in a pivottable? I am
trying to create some reports and I seem to be very restricted with
pivottables.