Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data missing in random columns in Analyses (12c 12.2.1.2)

JustTheFactsApr 20 2017 — edited Jan 29 2019

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:

CustomerYearMonthLocationRevenue
Acme2017011000
Foo2017012000
Bar2017023000

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.

This post has been answered by JustTheFacts on May 3 2017
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.