When using the UTC time option in Analysis Center reports generates unexpected values in the returned data values (NETIQKB72438)

When using the UTC time option in Analysis Center reports generates unexpected values in the returned data values

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 and double click on Cubes => vAMGeneric.

5. Go to Measures => vFact and option click on MetricCount(i.e. right click) and select 'Properties'

6. Look for AggregateFunction and then change the attribute property to 'Count' and then save the changes.

7. BIDS will then ask for reprocessing the vFact of the OLAP database which should be allowed to update the OLAP database schema to resolve the issue.

 

This issue is caused by an incorrect measure definition for MetricCount in the database schema of the vAMGenericUTC cube of AC_OLAP.

Formerly known as NETIQKB72438