Home » Fusion Middleware & Colab Suite » Business Intelligence » Comparing Columns (OBIEE)
Comparing Columns [message #352826] Thu, 09 October 2008 15:45 Go to next message
obiee_newbie
Messages: 2
Registered: October 2008
Junior Member
Hi,

I want to create a column wherein I would like to get the variance between 2 years.
Current data:
            2001     2002   2003
Amount1       10        5     15
Amount2       5         2     10       
Amount3       5         3     5


This is what I want
              2001  Var(02vs01)   2002  Var03vs02)    2003
Amount1        10     -50%          5       200%      15
Amount2        5      -60%          2       400%      10       
Amount3        5      -40%          3       67%        5

thank you in advance for your help.

[EDITED by LF: added [pre] tags to preserve formatting]

[Updated on: Fri, 10 October 2008 06:10] by Moderator

Report message to a moderator

Re: Comparing Columns [message #355610 is a reply to message #352826] Sun, 26 October 2008 06:21 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
What did you try so far?
Re: Comparing Columns [message #357915 is a reply to message #352826] Fri, 07 November 2008 03:43 Go to previous messageGo to next message
aksamdar
Messages: 1
Registered: November 2008
Location: Abu Dhabi, UAE
Junior Member
You need to create time series measures for that. read this OBE

http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/bi_admin/biadmin.html#t11

Re: Comparing Columns [message #358829 is a reply to message #357915] Wed, 12 November 2008 10:24 Go to previous messageGo to next message
obiee_newbie
Messages: 2
Registered: October 2008
Junior Member
Please refer to the link below. I did the "quick fix" in the meantime.

http://forums.oracle.com/forums/thread.jspa?threadID=719481&messageID=2827930#2827930
Re: Comparing Columns [message #410559 is a reply to message #358829] Sun, 28 June 2009 18:57 Go to previous message
monica365
Messages: 6
Registered: November 2008
Location: Argentina
Junior Member

Select Pivot table view. Click on Year column in Pivot table view and select "Add New Item". Then, enter the formula: ('2002' - '2001') * 100 and put as Heading 'Var(02vs01)'.
Previous Topic: Create Avg and "Grand" Avg in Answers as You would a Sum Total
Next Topic: Validation Prompts
Goto Forum:
  


Current Time: Thu Mar 28 15:35:59 CDT 2024