PPS Time Intelligence Filter with LinkMember

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  November 12, 2014 at 6:03 am

  #397634

  I have a PerformancePoint Service 2010 "start date" filter that is of Time Intelligence type. On my dashboard I link/connect it to my "Sales Order by Create Date" report and everything is fine (create date is default date dimension for sales order).

  On that same dashboard, I want to link/connect this start date filter to my "Sales Order by Schedule Date" report. Schedule date is a role playing dimension of the date dimension. I can use the LinkMember() function in the Connection Formula (as described in URL below[/I]) if the filter is a MDX filter, but it doesn't seem to work when the filter is a time intelligence filter.

  http://bennyaustin.wordpress.com/2013/02/04/performancepoint-using-connection-formula-to-pass-filter-values-to-report-having-role-playing-dimension/

  How do I use the LinkMember() function in the Connection Formula with a Time Intelligence filter?

  Thanks,

  Rob

  (edit: to clarify version of PPS)