OBIEE 12.2.1.2 Write back with drop down box — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12.2.1.2 Write back with drop down box

Received Response
91
Views
11
Comments
3310714
3310714 Rank 6 - Analytics Lead
edited Aug 13, 2024 5:47PM in Oracle Analytics Cloud and Server

Hi,

Was anyone able to create a drop down list for the write back column?  So instead of a free-form text box, I want to give the user a list of values to select from.  I found some articles online, but the JQuery code didn't work in 12c.  The code I found online is below.  Instead of a drop down, my analysis just displays the code. 

'<select id="user_comment" onchange=obipswb.Grid.Change(event)>

<option value="No Comment">Select Comment</option>

<option value="Good">Good</option>

<option value="Bad">Bad</option>

</select>'

pastedImage_0.png

«1

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Do yourself a favour, drop the dead donkey and use Apex for this, it has the kind of fully formed functionality you are looking for.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Perfectly said by Robert (beaten by 1minute) and always lovely to see slides from my "Worst Practices" presentation actually implemented in real life again.

    OBI is an analytical platform and not a software development kit for data entry webpages.

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Are you following this; -

    http://ids-sol.co.uk/2017/10/24/obiee-writeback-with-dropdown-field/

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Oh come on don't encourage such ridiculous ""requirements""

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Sorry!

    I was just curious!

    I agree writeback is not fit for purpose.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Good morning Christian.

    What do you think it would take to stake the writeback 'vampire', there seems to be an inordinate amount of interest in it recently!

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    'Vampire'?

    A vampire has the appearance of life but is really dead, and if you go to close then it sucks your vitality - yes - perfect fit for writeback!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Robert Angel wrote:there seems to be an inordinate amount of interest in it recently!

    The usual ebb/tide cycle. Some "new consultants" get a "requirement document" and as usual jumps immediately to fulfilling every letter, dotted "i" and every crossed "t" rather than thinking about what's in front of him/her.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Amen to that.

    I believe that as a developer / architect the worst thing I can do is deliver exactly what they ask for...

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Exactly. The most important part of a consultant's work is to *counsel* clients on what makes sense.