Adding Site Filters to DMS Reports with Sitecore 6.5

DMS does not have a Site Filter for multi site enviornments in the latest version of Sitecore 6.5 but I found adding one is quite easy so here is a little tutorial.

Step 1 Create a Filter

  • Browse to /sitecore/system/Marketing Center/Analytics Filters/Report Filters.
  • Insert a new ‘Filter’ named Site.
  • Set the Type to ‘Sitecore.Analytics.Reports.Filters.ValueListFilter, Sitecore.Analytics’
  • Set the ColumnName to ‘MultiSite’

Step 2 Add Filter Values

Select your new new ‘Site’ Filter and insert two new ‘Predefined Filter Values’ name them ‘website’ and ‘site2’ and set their values accordingly.

Step 3  Add the Filters to each Report

  • Browse to the reports in /sitecore/system/Settings/Analytics/Reports SQL Queries.  ( for this example I used ‘Latest Visits’ )
  • Add the column [Visits].[MultiSite] to the SQL fields.
  • Add the new ‘Site’ filter to the Filter field.

Step 4 Go Test the filter on your report

  • Open the Report from the ‘Engagement Analytics’ Menu Option.
  • Test your new filter with the Filter Button up top.

About Kevin Buckley
.Net web developer with a lot of experience in CMS. Currently working at Sitecore as Solutions Engineer.

4 Responses to Adding Site Filters to DMS Reports with Sitecore 6.5

  1. David Buckell says:

    Is it possible to specify a SPROC in the Report Query that accepts parameters, and then pass these filters into the SPROC?
    I have had a go, but on selection of a filter I receive an exception:
    Report.mrt cannot be rendered : System.InvalidOperationException: The statement does not support injection.

  2. Also, Is it possible to create dynamic filters that populate the possible selection values from a .net class instead of sitecore items?
    I have tried following the OMS steps for doing this, but the functionality appears to have significantly changed

  3. Surely the use of /*|*/ is required in your SQL too

    WHERE 1=1 /*|*/

    incidentally, SPROCS are not supported with DMS report filters, a real annoyance

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: