System Filter doesn't work on data mart explorer over TSPS custom view

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Capacity Optimization


    COMPONENT:

    Capacity Optimization


    APPLIES TO:

    co 10.X, 11.X



    PROBLEM:

    A data mart that uses this filter ${CUST_FILTER(SYSID, and sysid = ?)} and there is a View based on template data mart explorer that uses this data mart for a table and a chart.

    Selecting a sysid to filter on, the table shows the correct information but the chart does not.


    CAUSE:

    internal defect, when a sysid is passed, it's passed as ID DRCOZ-14231 In case of "id" and "sysid" column, all charts in a datamart explorer page are filtered by @{id} custom filter


    SOLUTION:


    To fix the problem, create an identifier parameter passing from one page to the other using an alis identifier for the sysid parameter.

    This is an example of the a mart used for filtering from:

    select         md.Day,         md.sysid,         md.name,         md.platform,         md.Environ,         md.description,         md.metric,         md.shift,         md.OT_Hours,         md.Total_Hours       from         ER_V_ENT_CPU_OT_BYDAY_2071 md       where         1=1 ${CUST_FILTER(SYSID,          and md.sysid =?)}  
      
    changed in
       
    select         md.Day,         md.sysid as identifier,         md.name,         md.platform,         md.Environ,         md.description,         md.metric,         md.shift,         md.OT_Hours,         md.Total_Hours       from         ER_V_ENT_CPU_OT_BYDAY_2071 md       where         1 = 1      ${CUST_FILTER(identifier,         AND md.sysid=?)}  
      
    reapplied filter to view again and changed mapping.
      

     


    Article Number:

    000144888


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles