Below is the structure of outline and data file.

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.

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

What could be the problem ?
We just want to see the number/value (not #missing) initially when we create ad hoc analysis.
here -->
