Skip to Content

webi report based on filter

Hi

I want to show specific classes in the report when it is weekday and weekend... like on mon, tues, wed, thurs want to show only C1,C2,C3 and on weekend needs to C1,C4 only..

to achieve same I created an object in universe to identify the day and could you please help me to create the filter in webi report to achieve same

regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 15, 2017 at 05:09 PM

    try this at report level

    Create variable=if(dayname(currentdayte()) inlist ("Saturday" ;"Sunday") and ((Class) inlist ("C1";"C4"))) then "Show" elseif(dayname(currentdayte()) inlist ("Monday " ;"Tuesday ") and ((Class) inlist ("C1";"C3"))) then "Show"

    Apply filter in table and select Show

    Add comment
    10|10000 characters needed characters exceeded

    • thanks Amit for the help

      Create variable=if(dayname(currentdate()) inlist ("Saturday" ;"Sunday") and ((Class) inlist ("C1";"C4"))) then "Show" elseif(dayname(currentdate()) inlist ("Monday" ;"Tuesday") and ((Class) inlist ("C1";"C3"))) then "Show"

      Apply filter in table and select Show