Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Bangkok Asset Management

Description (Required):

Require OAC Enhancement Oracle DV support Workbook Filter define to Report Variable.

Because I have report with this condition.

1.) If Workbook Filter "Dim - Calendar"."Period" is not selected any value.

Then Measurement show Data only current month (example current month is 2023-Feb).

2.) If Workbook Filter "Dim - Calendar"."Period" is select some value example 2023-Jan.

Then Measurement show Data on Period 2023-Jan.

In this case I need to create My Calculation with formula logic

Check Report Variable from Workbook Filter "Dim - Calendar"."Period".

1.) If Report Variable IS NULL Then use Function FILTER(Measurement USING "Dim - Calendar"."Period" = CONCAT(CONCAT(YEAR(CURRENT_DATE-1),'-'),MONTH(CURRENT_DATE-1)).

2.) If Report Variable IS NOT NULL Then Measurement.

Use Case and Business Need (Required):

Enhancement Request / Service Request:

Enhancement Request