Conditional Hiding of columns in Webi report

[Former Member]

Hi Experts

We have requirement like when the user enters the Fiscal Year 2015 as prompt value and Accounting Period  May month as a prompt Value then the report should display only 13 months of data that is from May-2014 to May-2015 in the report, we have 24 months columns as measures in the report

When the user enter the Fiscal Year-2015 as prompt value and Accounting period May month as a prompt value then the report should display only 12 months of data that is from May-2014 to May-2015 and other columns measures should be hidden.

Accounting Period as a prompt from Jan to Dec that is from 01-12

Can any one provide the solution for this requirement.

Thanks & Regards

Ravi Shankar

[Former Member]

Have you got date object in report or universe?

If yes then you can easily do it on report level by implementing following logic:

1) Create a variable :

Data_show = if [date] >= relativedate([date];-12) then "show" else "hide"

2) Now using these variable you can create report level/block level filter lik

Data_show = "Show"

3) After applying same it will show you only required columns.

Thanks,

Swapnil

[Former Member]

Hi Swapnil,

We are not using date object in report.

Not supposed to use any block level filters or report level filters  in the report.