You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is OLAP available on Oracle ADW?

in Autonomous Database 4 comments

Exploring a migration from SQL Server to ADW and need to know if OLAP or similar functionality is available

Content (required):

Hello, We're exploring a migration from SQL Server to ADW. Currently we allow business analytics super users to use microsoft excel to connect via SSAS OLAP cubes for quick data analysis. Is OLAP available in ADW? If not, is there something similar to olap available via ADW? We saw the "business model" functionality, but that seems to just create a db view. since it's a large data set, pre-processing of the cube dimensions and aggregations is useful, and i'm not sure that the business model feature does everything that OLAP can.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!