Destroyed Hierarchy??

[joannetheodore]

I have loaded some data into a cube (payroll details)

If I set the view to show every person within the company, I can see that the figures have uploaded successfully, but if I change the view ie to view the individual payroll details, for one department only, I am getting a "no values available" message... I know the data is in there...

What do I need to do to rectify this?

[Martin Ryan]

Hi Joanne,

If your cube is small enough I find the best way to find where data is located is to stack the two dimensions side by side on the left (row headers) and with each dimension choose only the N level elements (open the subset, click the all button, click the filter by level button, select level 0). Then turn zero supression on for the view and you'll see where all the data is held by person and by department.

HTH,
Martin