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

Problems Editing Reports with 100 columns in OBIEE

Received Response
92
Views
16
Comments
Phantasm
Phantasm Rank 3 - Community Apprentice
edited Aug 13, 2024 5:50PM in Oracle Analytics Cloud and Server

Hi - We have some reports where the number of columns are very high 100 or 100+. While building these reports we are facing a problem saving or editing these reports. Could anyone suggest how this can be resolved.

Pls note we had to add these many columns as the user wants these many field on the report. Its a simple tabular report with no report level calculations.

OBIEE Version:

OBIEE 12.2.1.2.0

Thanks

«1

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Phantasm wrote: we are facing a problem saving or editing these reports. Could anyone suggest how this can be resolved.

    So what's your issue? Should we guess?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi @Phantasm,

    Aren't you working with Rahul? Error while saving an OBIEE report with 100+ columns

    PS: "wrong tool for the wrong job" seems to match sadly ...

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    The user wants a data dump ... satisfy that requirement straight from the database OR use BI Publisher to query the data straight to excel

  • Joel
    Joel Rank 8 - Analytics Strategist

    Not more to add to this but maybe you're using the wrong tool. OBIEE is more of an analytical tool as opposed to a data extraction tool.

  • Adam Wickes
    Adam Wickes Rank 6 - Analytics Lead

    Yep... BIP is the winner here. Simple to use.

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

    @Phantasm You have not responded to a single answer you've gotten in here. Have you simply abandoned this thread?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Maybe the pseudonym is appropriate, he briefly haunts a forum and then vanishes leaving only the impression that something un-natural was here...

    I for one find 100 column reports used as data dumps scary!

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

    Typical "leech" behaviour

  • Lee Gledhill
    Lee Gledhill Rank 4 - Community Specialist

    When creating a large report I find that it runs a lot smoother if you hide the report output by clicking on "Display Results" Icon within the view editor screen (Third from the Right)

  • Adam Wickes
    Adam Wickes Rank 6 - Analytics Lead 
    48a4e11a-ed4e-48a0-88ec-f44e5180aaef wrote:When creating a large report I find that it runs a lot smoother if you hide the report output by clicking on "Display Results" Icon within the view editor screen (Third from the Right)

    If he's having issues building the report, how do you think his users are going to go viewing it.
    It's a bad solution. No amount of band-aids or workarounds will fix that.