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.
