Custom prompt based on values last 3 , last 6 , Last 9 and Last 12 months

Muhammad_Saad

Hi!

We have a requirement to create custom prompt based on values such as:

-last 3 months

-last 6 months

-Last 9 months

-Last 12 months

Above parameters work based on current date and we are using General ledger - Transactional Balances Real Time.

Thanks.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26485/custom-prompt-based-on-values-last-3-last-6-last-9-and-last-12-months

Hi @Muhammad_Saad,

Welcome to the Oracle Analytics Community!

Would prompt like following be sufficient?

If yes, then you can use the following codes to default the prompt values.

SELECT

   "General Ledger - Journals Real Time"."Time"."Fiscal Date" s_1

FROM "General Ledger - Journals Real Time"

WHERE

(("Time"."Fiscal Date" IN (CURRENT_DATE - 90)))

SELECT

   "General Ledger - Journals Real Time"."Time"."Fiscal Date" s_1

FROM "General Ledger - Journals Real Time"

WHERE

(("Time"."Fiscal Date" IN (CURRENT_DATE)))

Hope this help.

Thank you.

Bhaskar Konar

Hi @Muhammad_Saad,

Please find below the prompt for last 3 months using the above logic.

Accounting_Period_Last_3_months-PMT.catalog

Hope this help.

Thank you.