Is WriteBack in Pivot table possible? — Oracle Analytics

Oracle Analytics Cloud and Server

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

Is WriteBack in Pivot table possible?

Received Response
32
Views
4
Comments
Sagar Tippe
Sagar Tippe Rank 4 - Community Specialist

Hi Team,

I have a requirement to enable WriteBack functionality in one of the Pivot table. I know WriteBack in Pivot is not possible like in Table view, already gone through an article Configuring and Managing Analyses and Dashboards.

Indeed, I thought of a converting my Pivot view to a Table view and then do this WriteBack activity on top of it but is not possible to convert this pivot to table view because of some functional limitations of the report. Please suggest me some alternatives to achieve the same.

Thanks in advance.

@Sagar Tippe

Answers

  • John_K
    John_K Rank 5 - Community Champion

    Write-back in OBIEE is torturous at best and suicidal at worst. Not sure why it's even a feature because I've yet to meet anyone where it does everything they want it to as standard.

    Have you thought about having an APEX application that handles the writeback, and then call it from the OBIEE analytic with values passed in? You can use things like jQuery_UI to make it display as a nice popup etc.

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

    Short: No.

    Longer: No. Don't even try. Use APEX. It's free.

  • Sagar Tippe
    Sagar Tippe Rank 4 - Community Specialist

    Thanks mates.. On a way to Apex for the first time.. will keep you posted whether I get it or not..

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

    https://apex.world

    ^--- You're welcome