This content has been marked as final. Show 2 replies
(1). As long as Tableau can work against Oracle database and can generate sql SELECT statements, then it can also work Oracle OLAP data. When you create a dimension or a cube, olap engine automatically generates CUBE_TABLE views, which can be queried just like regular sql views. The naming convention for those views are
If you have created any AW, then you should see these sql views in your schema.
(2). I doubt there is any utility to "import cube definitions from Microsoft SSAS in XMLA into Oracle database using Analytic Workspace Manager".
It is a one time task to create AW and all its objects (using AWM), which does not take much time - assuming your source sql tables/views which will "map" to dimensions and cubes are ready.
Keep in mind that many operations that you do in MSAS are "pushed" into relational logic in source views (of cubes and dimensions) when working with Oracle OLAP.
That is why you see relatively less functionality in AWM compared to MSAS development environment.
I am also interested in merging OLAP option with Tableau desktop using native drivers. Unfortunately, I did not have time to study this question in detail. Try to look these options:
Will be great to see some updates from you