Moving calculated item

Question

Hi I am using OBIEE 12c (12.2.1.2.0)

I would like to know is there a way to move calculated item, for example i vreate calculated item that is sum of two columns, and OBIEE puts that calculated item on the end.

Can i somehow drag it in between columns??

BR, Matija

Robert Angel · Answer

How do you create the calculated item?

If we are talking using a formula, then yes, just use the layout editor to drag your column to its new place., preview and save.

If we are tallking a pivot table 'layer' then no, they are displayed last, but any reason you cannot create the equivalent using a formula as described above?

Joel Acha · Answer

Not quite but Save Column As functionality has been available since 11.1.1.9 - This allows you to create a column formula and save it to your catalog and therefore making it available to other dashboards/analyses etc.

https://www.rittmanmead.com/blog/2016/01/my-favorite-obiee-12c-feature-that-almost-no-one-is-talking-about/