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 methods.

Getting ready

To get started with Essbase Studio, click on the Start menu and navigate to Programs | Oracle EPM System | Essbase | Essbase Studio. The login menu will pop up. Enter your server, username, and password, and click on the Login...