OraFAQ Forum: Business Intelligence

Home » Fusion Middleware & Colab Suite » Business Intelligence » Comparing Columns (OBIEE)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Comparing Columns [message #352826]

Thu, 09 October 2008 15:45

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

skooman
Messages: 912
Registered: March 2005
Location: Netherlands

Senior Member

What did you try so far?

Report message to a moderator

Re: Comparing Columns [message #357915 is a reply to message #352826]

Fri, 07 November 2008 03:43

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

Report message to a moderator

Re: Comparing Columns [message #358829 is a reply to message #357915]

Wed, 12 November 2008 10:24

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

Report message to a moderator

Re: Comparing Columns [message #410559 is a reply to message #358829]

Sun, 28 June 2009 18:57

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)'.

Report message to a moderator

Previous Topic:	Create Avg and "Grand" Avg in Answers as You would a Sum Total
Next Topic:	Validation Prompts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 15:25:29 CDT 2013

Total time taken to generate the page: 0.42768 seconds