nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to access Global Filter value from Section Filter

Meme 0101

We need an "As of Date" global filter, then on the sections such as Termination/Turnover section which would need termination counts for Current Year, instead of below against the Current Date (NQ_SESSION.CURRENT_GREGORIAN_YEAR), we need something like if the blobal filter year is not null then VALUEOF(GLOBAL_FILTER.YEAR). How can we do that?

"HCM - Workforce Core"."Time"."Year" = VALUEOF(NQ_SESSION.CURRENT_GREGORIAN_YEAR)

Find more posts tagged with

Accepted answers

All comments

Bret Grinslade - Oracle Analytics-Oracle

That could work.

Say your year for the filter is 2024 (the session variable above). Then if you look at table such as "Termination date" you can filter it like this YEAR(Termination Date) = 2024. This would return just terminations in the year 2024.

I am not sure what you mean by global in this context. A report or dashboard? A specific viz?

Meme 0101

Say we have the "As of Date" on the top filter bar(Workbook/Global variable?), which is DATE instead of YEAR, we pin this filter to all the canvases in the workbook, this "As of Date" works great against our first 2 canvases to pull all different counts/analysis "As of Date", except on the third canvas which we we have visualizations with visualization filter (visualizations/section filter?) for Termination/Turnover , which we pull Current years termination counts by below visualization filter , by default is working fine (CURRENT YEAR against CURRENT DATE), but when we "As of Date" on the top filter bar to past date for example 07/01/2022, we would like the this visualization filter pull Termination count/analysis against year 2022 instead of current year of 2024, we need something like if the "As of Date" on the top filter bar is not null then VALUEOF(GLOBAL_FILTER.YEAR). How can we do that?

"HCM - Workforce Core"."Time"."Year" = VALUEOF(NQ_SESSION.CURRENT_GREGORIAN_YEAR)

Bret Grinslade - Oracle Analytics-Oracle

If you want a different year -- you will need to have the viz ignore the workbook level filter and then add a new filter either to the canvas or at the viz level. Depending on the goal you could use extract year in a calculation to make it easier for a user to pick different years. Here are list of things you could use by adding to add to My Calcs or just using the Year column directly in an additional filter.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/functions.html#GUID-4CBCE8D4-CF17-43BD-AAEF-C5D614A8040A

More information on filters here:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/filter-your-data.html#GUID-483DE5F5-9D92-43F3-B486-407898223F31

Meme 0101

Thank you for quick response ... not really simply want a different year, we want the YEAR of the "As of Date" filter on the top filter bar(Workbook/Global variable?)

[Deleted User]

I may be misunderstanding your request here but if you have "As Of Date" as a column of type "Date" then the engine will anyways extract all the possible time components from the column and propose them to you for use as filters or anything you want as you can see in this example:

Meme 0101

for example if I select AsOfDate = 01/01/2022 in Workbook filter, I want this selected data is be available in my Virilization filter of "Current Year", so that the current year is 2022 against "AsOfDate = 01/01/2022"

GayathriAnand-Oracle

You can bind the As of data filter to a parameter and use this parameter in the Expression filter used in the visual. Is this what you are looking for ? Please check Binding Parameters to Filters in Oracle Analytics

Thanks

Gayathri

Meme 0101

Thank you very much Gayathri for your help .... Now I can pass the selected value from Workbook Filter to Visualization filter through parameter. But realized only one day's data coming into workbook because of that Workbook AsOfDate Filter, then the below becomes the new issue now :-)

Meme 0101

still take the same example, "As of Date" on the top filter bar to past date of 07/01/2022, even though this visualization filter can pull Termination count/analysis against year 2022 accordingly, but only one day's data is available to the whole workbook and we actually want the termination count for year of 2022.

Meme 0101

The below can calculate the past 12 month's termination count, but we want the termination count of the year of the AsOfDate parameter, do you have an idea how to do that? Wish we could pass dynamic formula instead of constant as "-13, 1" to this PERIODROLLING function?