Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Dimensions only Subject Area and Analysis

Received Response
11
Views
1
Comments
ManishHathi
ManishHathi Rank 3 - Community Apprentice
edited Aug 13, 2024 5:24PM in Oracle Analytics Cloud and Server

Hello,

We have a legacy Discoverer Business Area that allows users to browse Product data (attributes, descriptions and such). There is a team of users that only deal with reviewing, maintaining Product data (we have thousands of products active at any given point). In that particular use-case these users don't necessarily need any "fact" to review, all they want to do is review product attributes (200+).

In Discoverer we had a database view (well, a bunch of views) that allowed these users to query product data, export to excel if needed etc.

How would I create a Dimensions only Subject Area for these users so that they can continue doing the same  type of queries from OBIEE 11g?

Thanks,

Manish

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    You build a model with a fact table

    As you don't care about it, just take the same product table and define a count measure on the product id, because you need to have a fact logical table or your model will not be valid. In the subject area you will just add all the other tables and leave that one out.

    If you have a table which is a kind of central tables with others joined on top of that one, define this one as the source of the measure and set it as implicit fact column in the subject area to let OBIEE be able to perform the dimensional only requests in the best way.

    The fact isn't optional: the business model must be a star schema, it requires a fact. So just keep it simple and use the key central table you have.