1 Reply Latest reply: Nov 15, 2012 2:21 AM by 872653 RSS

    Analysis requirement OBIEE 11.1.1.6.2 BP1

    872653
      Hi,

      I have a requirement to create an analysis to achieve the following.

      1.     Compare a Company sale with other companies’ sales (one or more). e.g. Let’s say Oracle’s sale is 2000 and Other Companies (Microsoft and SAP together) sale is 5000.
      2.     Compare a Company sale with the Industry sales. e.g. Let’s say Oracle’s sale is 2000 and the industry (Database Industry) is 50000.

      I need to show this information in the same analysis and I have a Company Dimension, Industry Dimension and a Sales Fact.

      I will have two prompts in the Dashboard one for to choose Company 1 and another one to choose multiple companies and/or the Industry. Since both companies are coming from the same dimension how to apply different filters? Also when I filter by Industry it should only filter values of the comparison measure (it should not filter the Sales measure of Company 1).

      Hope I explained it understandable, if not please let me know. Hope this image give you more clear vision.

      http://imageshack.us/f/715/oracle2prompts.png/

      Thanks in advance.