search cancel

IT Analytic Cubes and reports show Unknown column

book

Article ID: 164080

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

When viewing Cubes and reports columns show as Unknown value.

No error.

Environment

IT Analytics 7.6
SQL server 2012
Windows server 2012R2

Cause

N/A
Analysis service will assign Unknown columns when it's unable to match a dimension member.

Resolution

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.

  1. Log into sql management studio and connect with the Analysis service and Expand the database folder / IT Analytics / Cubes.
  2. Right-click the patch cube and choose process
  3. Right-click in the Object list window and choose Add Related Dimensions
  4. 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.