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:
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:
Hi John,
It's a great neat trick!
Thanks for sharing your knowledge
Does anybody has a CSS and can anybody tell me how to use it???
If you dont mind i need the CSS
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
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?
@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
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
@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
It explain everything
Thank You
Best regards.
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
@JT,
Why don't you edit/overrule the .ColumnHdg class from the views.css file?
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.
@anomynous
Not that I'm aware of unless you want to do it with some custom javascript.
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
@HemanthJi
What version of OBIEE are you using?
regards
John
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
Post a Comment