Thursday, June 13, 2013

[OBIEE 11g] Add Custom Calculated Item - UseFul Option


 



Add Custom Calculated Item - Useful option





Look at the Years. 



Look at the Years and Amount Sold. 



There is no Amount for the Year 2002 but client wants zero to be displayed for that year.

Now this is where the option Add custom Calculated Item comes handy.
This enables us to display zero and that too at front end level.


Right click on Year 2001 and follow the steps as shown below - Click on Add Custom Calculated Item





Label is 2002 and value is 0.






Table and graph -










No comments:

Post a Comment