Need help with a time filter

Jaintanya
Jaintanya
in Modeling

Can someone please help me implement the given scenario. I have implemented it but there are certain loopholes that I am having trouble fixing.

Scenario1 : I have a module with version list on rows , 4 line items(1,2,3,4) on columns and Time range FY15 on columns after line items. For LI 1,2,3 I only want to see years and for LI 4 only months. I created a filter module with FY15 on columns , LI 1,2,3 with format as timescale year and LI 4 with timescale month. I clubbed these 4 boolean selections in my filter module in another line item 'Final filter' and used it to filter my main module. It is working except that when I select year only for LI 1 , I still see year for LI 2, 3.

The image is what I am aiming to achieve.

image.png

this is my filter setup

image.png

Best Answer

  • devrathahuja
    devrathahuja
    edited February 19 Answer ✓

    Hi @Jaintanya ,
    You can achieve this by using LIS (Line item subset) to filter the line items.

    Create a LIS with the line items in your target module (Module you want to filter)

    Create a filter module with this LIS & time dimension.

    image.png

    You can then specify what summary do you want for which line item (Alternatively this can also be with the year dimension so you chose FY24 for line item 1, FY25 for line item 2 & so on, if required)

    The final filter will be as follows-

    image.png

    Time settings by month.years only line item is to tick the years only in the month time dimension.

    You can then apply this to the output module by referring to the LIS module-

    image.png


    Output will be as follows-

    image.png


    In my case it is the entire timescale, but as suggested above you can either restrict the time range or add the time dimension to filter selection.

    Hope this helps :)

Answers

Categories