I have a structure that you can see here.
enter image description here
When I proccess particular dimensions, all the data is correctly visible in Browser, e.g. for DimTime.
enter image description here
But this is not working for DimLocation. In this hierarchy I can see only data from one column, OnStreetName, while Borough and Zip_Code have only NULL values.
DimLocation hierarchy
DimLocationBrowser.
Also when I proccess a whole cube, in the cube browser for every single column there is “no rows found”, even for this ones that were visible in dimension browser.
Cube Browser
I’ve tried multiple cmbinations of hierarchies since I’m not sure how it should look like – whether the hierarchy should contain primarykeys or not, etc. So maybe there is a problem.
I tried to use some calculations, but only NumberOfAccidents is visible in a cube browser and it genter image description hereives vakue NULL.