Presenting time depending attribute values

    Presenting time depending attribute values

    Dear community,


    In a report I am using a dynarange to generate a list, in the subset the DFILTER function is used to select the elements to show in the list.

    Now my question,

    I know that I can expand the dynarange in the report, in order to show attributes values of the selected elements. No problem here.
    My problem is that some of the attributes are time depended and depending on the selected period, they can change, f.ex. customer status or project status.


    Example

    Period 2017-10
    Customer ID actual status in period Attribute status
    1 New Old
    2 Old Old
    3 New New

    Period 2017-11
    Customer ID actual status in period Attribute status
    1 Old Old
    2 Old Old
    3 New New

    where the status of the customer changes from period 2017-10 to period 2017-11.

    Is there a smart way to show the actual status in the period, since the status in the attribute is overwriten ? We are think of creating a mearure, where thge ETL writes the actual status, in this way I can use the Palo.Data function.

    Best regards

    Sven