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!

Cube Data shows #Missing upon selecting Ad-hoc analysis option

User_E9OMMDec 5 2018 — edited Dec 6 2018

Below is the structure of outline and data file.

47510945_565773130538292_353567626271653888_n.png

We were able to load data into the cube with the help of a rules file.

But when we try to see the data in excel by checking ad-hoc analysis option, we see #missing initially.

pastedImage_2.png

Only after we expand all dimensions, we can see the data.

pastedImage_3.png

What could be the problem ?

We just want to see the number/value (not #missing) initially when we create ad hoc analysis.

here -->

pastedImage_5.png

Comments