When viewing Cubes and reports columns show as Unknown value.
IT Analytics 7.6
SQL server 2012
Windows server 2012R2
N/A Analysis service will assign Unknown columns when it's unable to match a dimension member.
Once cubes process once they go into an Update state. If a column returns as Unknown once it will stay Unknown when processing as Update. To resolve you can manually process the dimensions as Process FULL.
Log into sql management studio and connect with the Analysis service and Expand the database folder / IT Analytics / Cubes.
Right-click the patch cube and choose process
Right-click in the Object list window and choose Add Related Dimensions
By default all of the dimensions should be highlighted if not highlight them all and right-click, choose Process Full. This will set the cubes to overwrite all derived data held once you select ok the cube will process, this can take a few hours in large environments.
Subscribing will provide email updates when this Article is updated. Login is required.