Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
PBCS: Add form with year actual

I have the "Year" dimension with these values:
2015
Q1
January
February
March
Q2
April
May
June
....to Q4 December
2015
Q1
January
February
March
Q2
April
May
June
....to Q4 December
I create a form with the "Products" dimension in the rows and "Year" dimension in the columns.
I want that, when I access at form, the year always be the actual year:
If I access today: The year should be 2016
If I access 15/02/2017: The year should be 2017
How can I setup this form to see the actual year?
Best Answer
-
Have a look at this - https://docs.oracle.com/cloud/latest/pbcs_common/PFUSA/selecting_substitution_variables_as_members.htm#PFUSA-f_member_se…
Use substitution variables for year (eg: set CurYear with Value 2016, next year you need to change to 2017 etc...)
HTH,
Dayalan P.
Answers
-
Have a look at this - https://docs.oracle.com/cloud/latest/pbcs_common/PFUSA/selecting_substitution_variables_as_members.htm#PFUSA-f_member_se…
Use substitution variables for year (eg: set CurYear with Value 2016, next year you need to change to 2017 etc...)
HTH,
Dayalan P.
-
Thanks for you response.