Is OLAP available on Oracle ADW?
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.
0