Using Office Pivot-Table with Oracle Express [message #92960] |
Wed, 05 June 2002 00:47 |
Boris
Messages: 5 Registered: February 2001
|
Junior Member |
|
|
1) How can I convert Microsoft cube files into a format readable by
Oracle Express (can Express import them?) I'm currently using MDX
queries to create cube files from a relational database (Oracle), and
am thinking of setting up a similar system with Oracle Express. No
warehouses or data marts.
2) Is it possible to access the resulting Express cube files with the
Office ActiveX pivot-table control through a webpage?
Essentially, I would be replacing the current system (where the
pivot-table accesses .cub files refreshed by periodic queries to an
Oracle relational database) with Oracle Express ROLAP that would be
accessible through the same pivot-table interface.
Boris
|
|
|
|