Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Excel export issue in OBIEE 12.2.1.4.0
While exporting Obiee analysis to excel, data in the excel column got split with null value after every 300 rows. In my analysis, suppress option is enable in column properties and also, it is looking fine in CSV export as well at the presentation view of analysis.
For e.g. In the analysis, let us suppose there are two columns(column1 and column2) having 301 rows with only one value in column 1 and corresponding different values in column2. So, I have enable suppress option in column1 by going to column properties.
| Column1 | Column2 |
| 100 | 0.1 |
| 0.2 | |
| | | |
| | | |
| 1.2 |
(1-301 rows)
When i am exporting this analysis to excel, column1 value get split with null value on 301 row(PFB table) although value is shown in the presentation view as well as in the CSV export.
| Row No | Column1 | Column2 |
| 1 | 100 | 0.1 |
| 2 | 0.2 | |
| | | | | |
| 300 | | | |
| -------------------- | ------------------ | -------------------------- |
| 301 | 1.2 |
Can anyone help me to understand if there is anything which needs to be changed on my end or it is showing as per product design.
Answers
-
3612780 wrote:While exporting Obiee report to excel,
If you say "report" that means you're using BI Publisher which is a different technology.
Also: please provide pertinent information as outlined in the FAQ:
"12c" means nothing since there were more than 30 versions of "12c" over the last 4 years and software isn't the Pyramids. Software changes over time.
0 -
I have updated the post as per your suggestion. Hope it is fine now!
0