webi report based on filter

[former_member214617]

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

[amitrathi239 · Accepted solution]

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

[former_member214617 · Accepted solution]

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