Home » Fusion Middleware & Colab Suite » Business Intelligence » New calculated item positioning (OBIEE 10g)
New calculated item positioning [message #549031] Tue, 27 March 2012 11:02 Go to next message
Messages: 5
Registered: March 2012
Junior Member
Hi guys!

Suppose I have a pivot table in whichI have only one column consisting of a multiple CASE function and then I build a New Calculated Item on this column.

Is there a way ( I even tried to modify the XML in the advanced session but with no success..) to display the pivot table with the new calculated item in between the CASE?

The attached image gives you the idea of what I'd like to accomplish..

Thanks a lot!!
  • Attachment: Im.jpg
    (Size: 44.03KB, Downloaded 393 times)
Re: New calculated item positioning [message #562993 is a reply to message #549031] Tue, 07 August 2012 12:22 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
That is not possible. Only option is two create two calculations with case when in it, each dealing with a subset of the options.
Previous Topic: BI Publisher Basic Coding Assistance
Next Topic: TopN analysis not displaying column in rank order for main report
Goto Forum:

Current Time: Sun Aug 09 19:25:17 CDT 2020