Oracle Analytics and AI

ManishHathi

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

Gianni Ceresa

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.