System Filter doesn't work on data mart explorer of TrueSight Capacity Optimization (TSCO) over TrueSight Presentation Server (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:

    TSCO 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 datamart 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 to
       
     
      
    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=?)}
      
    Re-applied filter to view again and changed mapping.
      

     


    Article Number:

    000241037


    Article Type:

    Solutions to a Product Problem



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