@ashraf817 I tried creating a similar calculation using the formula below and it worked fine. case when "HCM - Workforce Core"."Age Band"."Name" = '21 - 29' then "HCM - Workforce Core"."Facts - Workforce Headcount"."Headcount" when "HCM - Workforce Core"."Age Band"."Name" = '30 - 39' then "HCM - Workforce Core"."Facts -…

@Lauriane Massin Whitaker Please check this video

@Lauriane Massin Whitaker You copy/paste it in a file and upload.

@MayM Can you please check if this forum discussion helps you?

@Lauriane Massin Whitaker Please enable developer options as mentioned in , run the workbook and upload the execution log.

@Lauriane Massin Whitaker It would require log analysis. I would suggest you to create a SR for this issue.

@Molly P CASE WHEN can be used to create calculation in "My Calculations" of workbook as well.

@Narayanan Subramaniam-Oracle Thank you. We will analyze and get back to you. Can you please mark this as answered to close this thread?

@Narayanan Subramaniam-Oracle I would suggest you to log a SR with the diagnostic dump attached. This helps to analyze the logs to investigate this issue further.

@Narayanan Subramaniam-Oracle Please make sure that all the deployments in the Weblogic console is active. We will have to bi_server1 logs to investigate further on this issue.

@Conor Murnane I suggest you to create a SR for this issue as it helps to review the configuration. Please collect the information mentioned in the article below and upload it in the SR. What Information To Provide To Oracle Support For Troubleshooting Private Access Channel(PAC) Issues in Oracle Analytics Cloud(OAC) (Doc…

@Vaigu_27 If the approach helped you achieve the requirement, please accept my answer. I am afraid if there is any other approach.

@Vaigu_27 In Classic analytics / OTBI, you can create a UNION ALL report. Each query in the UNION ALL will correspond to each type of measures such as MTD, QTD and YTD and have a dummy column to identify the type of measure as shown below: Final output looks like this:

@Vaigu_27 1. Create a custom table with fiscal period column and corresponding custom date column containing the first date of the fiscal period. 2. Extend the prebuilt time dimension using this custom table. 3. Create a filter based on this custom date column and bind a parameter. 4. Create an expression filter using…

@Vaigu_27 1. Build a custom table with fiscal period column and corresponding custom date column that contains 1st day of the period. 2. Extend the prebuilt time dimension in "Financials - GL Balance Sheet" subject area using this custom table. 3. Use this custom date column in the filter 4. Bind it with a parameter 5.…

@Vaigu_27 Instead of using dashboard filters and parameter, if you simply the expression filter below, does it help? "Financials - GL Balance Sheet"."Time"."Fiscal Date" between TIMESTAMPADD(SQL_TSI_MONTH,-11,CURRENT_DATE) AND CURRENT_DATE

@Vaigu_27 Please try using 'Dashboard Filters' visual in DV and bind a parameter with the dashboard filter and use the parameter in the expression filter as follows: "PC4"."Posted Date"."Date"<=TIMESTAMPADD(SQL_TSI_MONTH, -12, @parameter("Latest Date")(CURRENT_DATE))

@Vaigu_27 Thanks for sharing the screenshot. I got your requirement. This feature is not yet available in DV. Please upvote the idea below:

@Vaigu_27 Yes, we can create a dummy calculation with an expression ' ' in DV Workbook.

@Vaigu_27 You can try creating a calculation with an expression ' ' to get a empty row / column. Regards, Bala.