5 Replies Latest reply on Jan 4, 2012 7:12 AM by MuRam

    Seperate Subject area for Dashboard Prompts

    user8680861
      Hi,
      Is there any way by which we can create seperate subject areas for OBIEE dashboard prompt only??

      Thanks
        • 1. Re: Seperate Subject area for Dashboard Prompts
          MuRam
          Hi,
          Instead you can create a separate folder as prompt in the presentation layer and place all the columns inside that folder.

          Hope this helps you.

          Regards
          MuRam
          • 2. Re: Seperate Subject area for Dashboard Prompts
            Dhar
            Hi,

            Yes we can create separate subject areas for dashboard prompt's alone. Here is a case

            Say we need to create a constraint enabled prompt in our dashboard. So we bring in two dimension columns into the prompt.

            When we run the prompt, the queries across these two dimensions go through a fact table (Because the only way two different dimensions can be joined is through a fact . This fact table is chosen by BI Server intelligently at run time and that can be set through Implicit Fact column also though). In this case there is a chance that some of the dimension rows might get skipped in the constrained prompt as all of the records might not be present in the fact table.

            To mitigate this issue, we might want to create a separate subject area for dashboard prompts alone (using some fact less fact or by having a surrogate key in the 2nd dimension table etc).

            Hope I am clear :)

            Thank you,
            Dhar
            • 3. Re: Seperate Subject area for Dashboard Prompts
              user8680861
              The Question is not about seperate folder in the catalog,Its about the Prompt Performance.
              Thanks anyways!
              • 4. Re: Seperate Subject area for Dashboard Prompts
                user8680861
                Hi Dhar,

                You r perfectly clear..bang on.This is what i was looking out for.
                But do u also have the steps handy for the process??It would be great if you can share some links regarding the same.

                Thanks
                • 5. Re: Seperate Subject area for Dashboard Prompts
                  MuRam
                  Hi,

                  You can make a dummy fact table and join with the dimension in the physical layer as 1=1.
                  And make a separate subject area for these dimensions and dummy fact tables.
                  And you can use them in the answers.

                  You can also refer

                  http://www.rittmanmead.com/2009/08/oracle-bi-ee-10-1-3-4-1-reporting-on-non-transactional-dimension-values-equivalence-of-outer-joins/

                  Regards
                  MuRam