Exported Analysis Showing Blank Values

Question

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

[Deleted User] · Answer

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.

ca$hmon3y · Answer

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] · Answer

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,