CODEWITHSUNDEEP
oracle-databaseplsqloracle-data-integrator
M_Gh
M_Gh

Reputation: 1142

Does cube of ODI support OLAP operations like dicing, drilling, pivoting

I am a newbie in ODI. I have installed ODI 12c and created a data cube in it. After mapping the data cube, it is just added into the Oracle database like a simple table. I am wondering how the cube helps us to run queries very fast and in low time. I have searched a lot and found that OLAP cube's Operations are Dicing, Drilling, Pivoting, ...

Would you please guide me on how to drill, dice, and pivot on the cube which is created in ODI?

Any help is really appreciated.

Upvotes: 0

Views: 144

Answers (1)

F.Lazarescu
F.Lazarescu

Reputation: 1385

ODI it's a tool that integrates data. The operation of Dicing, Drilling, Pivoting and so on, are operations that are made on a reporting tool such as Oracle OLAP.

You can't do that in ODI. You could see in this page all the details rearding ODI Cubes.

EDIT 1, based on comment:

Due to the fact that when you create a Cube, you need to specify a datastore and dimensions(and also when create a dimension you need to specify a datastore) it means that a Cube have a phisical table behind.

Please read here about dimensions and then about Cubes.

Very sort extraction from the links:

  • A cube is a set of measures grouped together that have similar dimensionality. The axes of the cube contain dimension values and the body of the cube contains measure values.
  • A dimension is a structure that organizes data. For example, a products dimension organizes data about products including product information, product categories and its sub-categories. A dimension consists of a set of levels and a set of hierarchies defined over these levels.

Hope that this answer helps you, Florin!

Upvotes: 1

Related Questions