The dimTime dimension is joined to the wrong column in the fact table (view) for the UTC cube result

  • 7024766
  • 03-Aug-2020
  • 03-Aug-2020

Environment

Analysis Center 3.0

Situation

In Analysis Center it is possible for the dimTime dimension to be joined to the wrong column in the fact table (view) for the UTC cube resulting in UTC reports having incorrect data values being displayed.

Resolution

1. Open the SQL Server Business Intelligence Development Studio

2. Click File => Open => Analysis Service Database.

3. Choose the 'Connect to Existing' database radio button and enter the SQL Analysis Services server name (OLAP Server Name) and database name (AC_OLAP) and select 'OK'

4. Open Solution Explorer Go to  Cubes => vAMGenericUTC => Measure Groups => .

5. right click on vFactUTC and select     Script Measure Groups as => Alter to => New Query Editor Window.

6. In Query Editor Look for the value 'idMinuteKey' and change to 'idUTCMinuteKey'

7. Press Execute ( ie Ctrl+f5) 

8. Then Go to  Cubes => vAMGenericUTC => Measure Groups 

9. right click on vFactUTC and select Process , Processing Option=Process Full , Click OK 

The above will Full Process the vAMGenericUTC Cube