Skip to Content
avatar image
leo dec

webi report based on filter

Sep 15, 2017 at 03:26 PM | 39 Views

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

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    AMIT KUMAR
    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

    • leo dec
      Sep 19, 2017 at 07:03 AM

      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