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
