Wednesday, March 25, 2009

Dissecting Paint Repository - II


In the last article, I had talked about dissecting Paint Repository.  Let me now give you some insights on how to use the Calculation Wizard to create new columns that compare two existing columns.

In the Paint repository, we have two columns "Dollars" and "Month Ago Dollars".  Using the calculation wizard, we can create the following four calculated columns based on the expression templates provided by OBIEE

  • Change
    CurrentX - ComparisonX
  • Index
    1.0 * CurrentX / ComparisonX
  • Percent Change
    100.0 * (CurrentX - ComparisonX) / ComparisonX
  • Percent
    100.0 * (CurrentX / ComparisonX)
CurrentX        -> Column using which Calculation wizard was invoked
ComparisonX -> Column chosen in the wizard for comparison

Here, if we want to calculate "% Chg Month Ago Dollars" i.e change in Dollars from its Month Ago value, we can use the calculation wizard as shown below.

Right click "Dollars" column and select "Calculation Wizard"



Click Next and choose "Month Ago Dollars" as shown below



Click Next and choose the comparison column that we would like to create. We can choose all four and the wizard will create 4 new columns with the code in it to do the comparison.


Click Next and Finish. A new column called "% Chg Month Ago Dollars" will be created as we chose only Percent Change above. See the code that the calculation wizard has created for the new calculated column.


41 comments:

  1. Hi.
    It's nice to see another OBIEE blog.
    Just keep posting.
    Regards,
    Goran
    http://108obiee.blogspot.com/

    ReplyDelete
  2. hi!~~leave you a message to say hello, and thanks for your share!........................................

    ReplyDelete
  3. 一個人就像一個分數,他的實際才能是分子,他對自己的評價是分母。分母越大,則分數的價值越小。..................................................

    ReplyDelete
  4. 馬丁路德:「即使知道明天世界即將毀滅,我仍願在今天種下一棵小樹。」............................................................

    ReplyDelete
  5. 認識自己,是發現妳的真性格、掌握妳的命運、創照你前程的根源。............................................................

    ReplyDelete
  6. 不論做什麼事,相信自己,別讓別人的一句話,把你擊倒。..................................................

    ReplyDelete
  7. 獨居時,要反省自己的過錯;在社會大眾之間,則要忘卻別人的過失。..................................................

    ReplyDelete
  8. Nice information. Our institute Is the Leading online institute in

    Hyderabad, India to provide OBIEE online trainings with the real

    time experts and certified professionals. alot

    Obiee Online Training.

    ReplyDelete