Drop down list of columns for Write back functionality. — 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

Drop down list of columns for Write back functionality.

Received Response
1
Views
4
Comments
Chandra kanth
Chandra kanth Rank 3 - Community Apprentice
edited Aug 13, 2024 7:03PM in Oracle Analytics Cloud and Server

Hi all,

I have a requirement where in there is comments1, comments2 columns.

Currently users entering text in those comments columns using write back functionality updating those columns in the database.

New requirement is to have a drop down for both comments1 and comments2 columns. Is this possible? Please advice how to do this.

I am using OBIEE 11g.

Regards,

Chandra kanth.

Answers

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

    First things first: OBIEE is not a data entry web application, nor an ERP system nor a CRM system. (Ref slide 31: 50 shades of #Fail - Oracle BI worst practices in real life)

    While you may be able to hack something together with loads of JS this is not something recommendable. Use a proper tool like APEX.

  • Chandra kanth
    Chandra kanth Rank 3 - Community Apprentice

    Hi Christian,

    This is client requirement which they asked us to check the possibility to incorporate.

    Regards,

    Chandra kanth.

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

    Possibility to incorporate: low / pointless / there are *actual tools* which are *designed to do what you want to do*.

    I get that client ask this and I get asked this often enough myself. Just turn the question around: "So you want your 2-seater Ferrari to transport 12 people?" "Well it's not really the point of that car but we can always cut it in pieces, stretch it, highten it, add more seats etc."

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    I agree with Christian obiee it's not  Data entry system, despite of this, you could do writeback through its action framework the possibility to do some update/insert, I also implemented write functionality and some.client wants to leverage these functions, but o

    biee has constraints just only could apply in table, etc.

    For more detail check the write back limitations section

    https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/answersconfigset.htm#BIESG1355

    Kind regards,