Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OBIEE Ad-hoc analysis

Received Response
1
Views
1
Comments
User_170M8
User_170M8 Rank 1 - Community Starter
edited Aug 13, 2024 6:14PM in Oracle Analytics Forum

Hi,

I have a doubt in developing Ad-hoc reporting in OBIEE 11g. In our development we have five dashboards, for that we have required tables with data. Once we upload the repository in server we can able to create the dashboards. My question is whether can we able to create a ad-hoc report along with the same repository which we created for normal dashboards or do we need to create a repository again separately for ad-hoc reporting.

Earlier response would be appreciated!

Thanks in advance!

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    The repository (the RPD file) is unique for a given OBIEE instance, so you can't have 2 RPD.

    You can perfectly use the same RPD and also the same subject area / business model for your ad-hoc analysis if the data and structure are the same.

    In the RPD you can model as many business models as you want, and for each business model you can have one or many subject areas.

    So if for your ad-hoc you need something else not present now you can also take that option: extend the existing or build another model / subject area next to it.

    So no, no need of a second repository and yes, you can create ad-hoc analysis on the same repository (that's actually what everybody does and what the tool is built for...).