We're having a bizarre problem with Analysis results in 12c which is: at seemingly random times, columns will be empty in the Results tab. I can't put up a picture due to corporate data protection concerns, but to help visualize, if the request criteria is:
Customer, YearMonth, Location, Revenue
Then the results may be:
| Customer | YearMonth | Location | Revenue |
|---|
| Acme | 201701 | | 1000 |
| Foo | 201701 | | 2000 |
| Bar | 201702 | | 3000 |
More details:
- The physical SQL is correct, and returns data in the suspect column
- The suspect column changes if the analysis changes; in the above example it's Location, but if I add Product to the analysis maybe it's Customer that goes blank and Location shows up
- It is not always the same ordinal position that is blank - it may be the 1st column or the 10th (so far at least, it's never been a measure though)
- The suspect column does not change if filters are added/removed or if columns are rearranged
- Session log shows no errors or unexpected post-processing of query results
- It is not a problem with column formatting (i.e. white text on a white background); the cells are actually empty
- Export to Excel has empty cells, export to CSV has two consecutive commas where the data would be
- Tested with both IE and Chrome, on multiple different client machines
- Tested using Skyrios and FusionFX
- This is an 11g -> 12c upgrade, however I'm using a fresh (empty) 12c RPD as a starting point, with only a tiny test model
- The chosen view does not matter - Table, Pivot Table, Chart - the column will be empty in all of them
Needless to say this is a deal-killer for this upgrade. Now that I've solved my (self-inflicted) problem with uploading RPDs - needed to get that fresh, empty 12c RPD loaded up - I've got to solve this issue or we're dead in the water. An SR to Oracle is guaranteed, but if you've ever dealt with Oracle support...well...you know.
Any suggestions are appreciated.