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

Exported Analysis Showing Blank Values

Received Response
258
Views
5
Comments
ca$hmon3y
ca$hmon3y Rank 3 - Community Apprentice
edited Aug 13, 2024 5:18PM in Oracle Analytics Cloud and Server

Hi All,

I have created a dashboard with many analyses. One of the analyses has 3400+ rows when certain filters are applied, but the analysis works great in OBIEE nevertheless. When the analysis is exported to Excel, some of the values (around 10) are blank in the SUPPLIER column. These values are not blank when viewing the report in OBIEE.

What's strange is that the rows that are experiencing blank values has changed from day to day. One day it was 7 rows with a blank value for SUPPLIER, and the next it was 10 completely different rows with a blank value for SUPPLIER.

This seems like some sort of technical glitch. Any ideas?

Product: Oracle Business Intelligence 11.1.1.9.0

Browser: Internet Explorer 11.1098.17763.0

Answers

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

    Report? So you're using BIP reports on your dashboard? You're not using analyses?

  • ca$hmon3y
    ca$hmon3y Rank 3 - Community Apprentice

    Sorry, used the incorrect term. It is an analysis.

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

    Are you using value suppression for repeated values? Are you exporting formatted analyses with charts etc or raw data format like CSV? What are your instanceconfig settings?

    etc. etc. etc,

  • ca$hmon3y
    ca$hmon3y Rank 3 - Community Apprentice

    Interesting... I changed the setting on Repeated Values from Suppressed to Repeat. That seems to have solved the problem for now, not sure why the analysis would only be affected during the process of exporting.

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

    You still haven't said what your are exporting to where. Formatted export and data export obviously behave differently.

    This tool has about 50'000 knobs you can twist and things you can do. That's it's strength. If those 60'000 possibilities aren't fully understood then obviously an advantage turns into a disadvantage.