O'Reilly logo

Oracle Essbase 11 Development Cookbook by Jose R. Ruiz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting up joins in a minischema

When you create a minischema, if there are any joins in the data source they will be visible in the minischema diagram. In the TBC minischema, in the recipe Building your minischema, there are no visible recursive (parent-child) relationships. Any user-defined tables that you define in the data source will also not have any relationships assigned to them. These relationships will impact the queries that Essbase Studio generates. If you do not understand the relationships in your data source, then you will most likely not build a cube that truly defines how the business functions. Defining relationships between tables can be done manually by adding joins or by using inspection. In this recipe, we will practice both ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required