Tuesday, March 10, 2009

OBIEE hidden column writeback

Sometimes you want to use a "hidden" column for a writeback procedure. Problem is if you use the conventional Hide properties of a column it's also not visible for the write back.

Workaround: use a CSS hide:

image

Enable the "Use Custom CSS Style " enter display:none. Both for the field and the header.

(Be aware the original value is still available in the source of the page!)

Till Next Time

15 comments:

Anonymous said...

Hi John,

It's a great neat trick!

Thanks for sharing your knowledge

Rohit said...

Does anybody has a CSS and can anybody tell me how to use it???
If you dont mind i need the CSS

John Minkjan said...

Hi,

There is a good example in the documentation:
http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/b31766.pdf
page 90.

regards

Mark G said...

Could you explain how to use hidden column in writeback. Writeback works at row level. How the report knows which row should be processed (insert/update). Normally when I use writeback in report - values in writebacked column is unbolded. When I change value in this row become bold. It shows to request which rows should be processed. How it works with hidden column?

John Minkjan said...

@Mark G

It works, exactly the same, only the changes are not visible fro the user, the valua is still present in the HTML. It's only intended for adding (semi-) static data, like user id

regards

Mark G said...

Yes I suppose but how do the request know which rows should be processed? (user can't write into this hidden fields) Every record will be updated?

regards

John Minkjan said...

@mark,

This doesn't work if the hidden column is the only writeback column. What would be the point of that? It needs at least one other writeback column and then OBIEE will only insert / update the new / changed columns.

Regards

Mark G said...

It explain everything
Thank You

Best regards.

JT said...

Hi John,

About use of CSS Styles, i can use CSS in tables but not in Column Heading, can u say me how i can use css here?, i wanna do good style to my new project. And i can not find much examples of styles.

Ty

Pd. Sorry about my poor english

John Minkjan said...

@JT,

Why don't you edit/overrule the .ColumnHdg class from the views.css file?

Anonymous said...

Hi,

Is there a way to conditionally hide a column header based on the column's value?
I was able to hide the column value thru conditional formatting by setting CSS to {display:none} but the column header still shows.

Thanks in advance.

John Minkjan said...

@anomynous

Not that I'm aware of unless you want to do it with some custom javascript.

Hemanth G said...

Is there to hide the column values from the corresponding graph as well? The CSS style customization works fine for the table view but the row (conditional formatting) still displays on the charted graph

John Minkjan said...

@HemanthJi

What version of OBIEE are you using?

regards

John

Anonymous said...

How about doing this in a pivot table, it works very good is the report is a table view but not if it is a pivot table view