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. I love readding, and thanks for your artical. ........................................

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

    ReplyDelete
  4. 很用心的部落格 祝你人氣百分百 期待您的新文章.................................................................

    ReplyDelete
  5. 河水永遠是相同的,可是每一剎那又都是新的。......................................................................

    ReplyDelete
  6. 一時的錯誤不算什麼,錯而不改才是一生中永遠且最大的錯誤............................................................

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

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

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

    ReplyDelete
  10. 你快d upday個blog啦~我等左好耐啦/_愛死呀ling之fans上 ............................................................

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

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

    ReplyDelete
  13. 若有人問你成功時會不會記得他 試問若你失敗時他會不會記得你......................................................................

    ReplyDelete
  14. 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