Available group value for SEP cubes is 'None'

book

Article ID: 196639

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

When using the Group field in views within the ITA Console, the only available values listed for this field are 'None'.

Cause

The underlying database view vIT_Analytics_SEP_GroupDim selects records from the IDENTITY_MAP table in the SEPM database with a 'DELETED' value of NULL. Records with a 'DELETED' value of 0 are not selected.

Environment

Release : 2.9.0

Component :

Resolution

This issue is resolved in IT Analytics version 2.9.1. Upgrading is the recommended solution.

Alternatively, this issue can be resolved by altering the openquery statement in the view vITAnalytics_SEP_GroupDim to select records that have a 'DELETED' value of either NULL or 0.

To make this change, follow this procedure:

  1. Open SQL Server Management Studio (SSMS)
  2. In the Connect to Server window, select the Server type 'Database Engine' and provide the name or IP address of your IT Analytics database host (and instance name, if not the default instance) as the Server name
  3. Connect using the Authentication method enabled during the installation of IT Analytics
  4. Expand the Databases folder under the host name in the Object Explorer pane
  5. Locate and expand the IT Analytics database (the default name is 'ITAnalytics')
  6. Expand the Views folder
  7. Locate the view dbo.vITAnalytics_SEP_GroupDim
  8. Right-click this view, select Script View as : ALTER To : New Query Editor Window
  9. In the query editor window, edit line 24 by replacing this:
    AND DELETED IS NULL')
    with this:
    AND (DELETED IS NULL OR DELETED = 0)')
  10. Execute the ALTER statement by pressing the function key F5, clicking the Execute button in the SSMS toolbar, or selecting Execute from the Query menu