In 11g, when you dragged an amount to an axis, you may recall that the numbers would show up exactly as the raw number. There is also a more intuitive abbreviation of the measures that are placed on a graph. In the Results tab, there is a New Calculated Measure icon that brings you immediately to the Edit Formula screen where you can name your new measure and define its formula. In 12c, you can add only the needed columns to your Criteria, then go straight to Results.
While this worked, most new users often wondered why they were “bringing in two revenue columns,” for example. In 10g or 11g, you needed to add a “whatever” column to the query, and then go in Edit Formula to define the calculation for your new column. OBIEE 12c provides a more intuitive way to create calculated columns than previous versions. You do this by entering your formula in edit formula and choosing to “Save Column as” for future use. OBIEE 12c gives you this clean and simple method for storing and reusing your most wanted columns. I would start many reports based on these Master reports because they had my pre-built formulas however, this was not a clean method for others to follow. Trying to simplify my life, I ended up inventing “my own method” of saving complex calculations by saving different analyses that I named as “Master - Calculation” containing the columns that I reused often. I remember creating many financial calculations that had to be reused often, and until now there was no easy way to retrieve the column formulas. If you’ve built a lot of logic in a column’s formula, and would like to reuse the logic in future reports, you will appreciate the opportunity of saving columns. This feature is very well described here, so I will give a high level overview: 12c gives you a very easy way to save a complex formula into the catalog. Pretty sleek solution to simplify your formulas. In the same spot where you specify how the data is displayed, you can check the x100 box, which in turn will automatically multiply your results from that column by 100. In 12c, you can create your percent calculation without multiplying it by 100, then set your % data formatting in the Column Properties. If you’ve created lots of percent variance columns, it's probably second nature that you will create your formula and then multiply by 100. Here, I’ll share with you some of the new features within Answers: Percent Calculation In general, I was pleasantly surprised with the UI, the speed, and the intuitiveness that came along with OBIEE 12c.
How to create new treemap chart in obiee software#
As with most new software releases, I expected to find issues that needed to be worked out.
With a sleek interface and many new functionalities, 12c brings some very useful features that users will appreciate. Now, I've personally had the chance to play with it for a few weeks, mostly in Answers and some with the RPD, and wanted to share my experience. Mark Rittman, for example, posted a good one here. Several blogs have already been written about new functionality in OBIEE 12c.