In TSCO, I am unable to materialize SQL datamarts to use it in a Custom View having a roll period Macro filter

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:

    TrueSight Capacity Optimization 10.7



    PROBLEM:

    Customer cannot use Filter macros when he creates a custom datamart in TSCO. The web UI allows the user to create and materialize the Datamart but this ends up with a strange string with it is materialized.

    User-added image 


    CAUSE:

    Defect QM002294608


    SOLUTION:

    The solution proposed for queries that contain a roll period macro, is to create 2 datamart: One materialized (without any macros) and one not materialized (since it contains macros). 

    (1) The user shouldn't include macros on the query that has to be materialized, this one requires to select the second option (see screenshot below) which is to materialize the query.

    (2) The query that does not require to be materialized will contain the macros but this query should use the option "Always see fresh data" to prevent it to be materialized:

    User-added image

    Defect QM002294608  has been logged to fix this, it's basically to prevent the materialization option to appear on the wizard when a SQL query contains a macro. This kind of SQL should not be materialized and this option allows the user to do it, the defect on the UI shows the option available, in order to create the queries having macros the option is to select "Show fresh data" setting.

    Fix will be available in CHF 10.7.00.00.C00016 to be released on June 5th 2017


    Article Number:

    000136880


    Article Type:

    Solutions to a Product Problem



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