Reporting DB- difference between views with _OlapView and _UserVie

[BoggyBoy]

In the reporting db there are views that end with _UserView and _OlapView.
the columns look the same. for example we have MSP_EpmAssignment_UserView
and MSP_EpmAssignment_OlapView - with virtually identical columns. Can
anyone tell me the reason for 2 views that are virtually identical? Thanks.

 

[Jonathan Sofer [MVP]]

The OLAP view is for use by the Cube Build Service. The USER view is more
user friendly for reporting off of custom fields. For each custom field you
created, the User view creates a column by that custom field name for easy
reporting.

Hope that helps,

Jonathan Sofer