Extra Pages

▼

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

at

15 comments:

  1. AnonymousMarch 12, 2009 at 3:59 PM

    Hi John,

    It's a great neat trick!

    Thanks for sharing your knowledge

    ReplyDelete
  2. RohitMarch 31, 2009 at 7:45 AM

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

    ReplyDelete
  3. John MinkjanApril 1, 2009 at 7:44 PM

    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

    ReplyDelete
  4. Mark GMay 4, 2009 at 2:45 PM

    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?

    ReplyDelete
  5. John MinkjanMay 5, 2009 at 8:23 AM

    @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

    ReplyDelete
  6. Mark GMay 5, 2009 at 1:18 PM

    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

    ReplyDelete
  7. John MinkjanMay 5, 2009 at 2:30 PM

    @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

    ReplyDelete
  8. Mark GMay 6, 2009 at 9:18 AM

    It explain everything
    Thank You

    Best regards.

    ReplyDelete
  9. JTMay 9, 2009 at 12:34 AM

    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

    ReplyDelete
  10. John MinkjanMay 19, 2009 at 1:24 PM

    @JT,

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

    ReplyDelete
  11. AnonymousMay 28, 2010 at 5:56 AM

    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.

    ReplyDelete
  12. John MinkjanJune 17, 2010 at 7:56 AM

    @anomynous

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

    ReplyDelete
  13. Hemanth GNovember 7, 2011 at 4:52 PM

    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

    ReplyDelete
  14. John MinkjanNovember 14, 2011 at 9:59 AM

    @HemanthJi

    What version of OBIEE are you using?

    regards

    John

    ReplyDelete
  15. AnonymousMarch 13, 2012 at 5:25 PM

    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

    ReplyDelete

Note: Only a member of this blog may post a comment.