Display TopN Revenue Every Year by Customer in Obiee11g

Display TopN Revenue Every Year by Customer in Obiee11g:

Hi All,

       I had a requirement to generate topN Constituents Revenue based on every year. In this blog i am going to explain how to display top 10 constituents revenue for 2012;2013 etc...

1. Create a new analysis with your required columns
Here i have used the following columns and the last column displays our business scenario.


2. For Revenue By TopN column goto>edit formula> and select f(..) formula button, expand aggregate icon and select TOPN function which will look like below screenshot.

3. Then select variable button >presentation variable and type COUNT as Variable Expression and Default Value as 10 like below screenshot.
4. After entering all the values the edit formula value passing pane should look like below screenshot and select ascending to this column.
5. Now we go to to create two prompts for our analysis.
6. Select the “Prompts” tab and click on the ” + ” symbol to create a new prompt, select the “Column Prompt” -> “Time”.”Year”.
7. Keep the default values and make sure these are checked: “Enable user to select multiple values”, “Enable user to type values”, “Require user input”.
8.  For the “Default selection” select “Specific Values” and use the ” + ” icon to open the “Select Values” window.
9.  In the “Select Value” window select 2013 and 2012 and move them to the “Selected” side and click the OK button.

Refer and make sure the values are correct as per below screenshot:

10. Create One More Prompt:
  •  Add one more prompt by select the ” + ” icon on the “Definition” window.
  • Select the “Variable Prompt”.
  • On the “New Prompt” window for “Prompt for” select “Presentation Variable” and on the side box enter “Count”.
  • For the “Label” enter “Number of Ranks”.
  • For the “User Input” select “Text Field”.
  • For the “Variable Data Type” select “Number”
  • Check the “Require user input” checkbox.
  • For the “Default selection” select “Specific Value” and enter “10″.
  • Then finally click the OK button.

make sure it is as below screenshot:
11. Once all done Save the analysis as TOPN Constituents Revenue By Year. 
12. The Result look like 
13. Select ok and run the analysis.



Hope it Helps!!

Thanks,
Shanmugha Bharathy G B





No comments:

Post a Comment