Skip to main content
Question

How to filter OLAP Table based on date?

  • August 23, 2021
  • 2 replies
  • 49 views
M
Level 6
Forum|alt.badge.img+7

I have a global date filter which pretty much is selection between a date period (Eg: - 01/01/2021 - 01/31/2021). This filter applies to my entire analysis when selected. However, I have an OLAP table where the columns are built upon formulas which include the use of DOMAIN_TABLE

2 replies

D
Level 0
Forum|alt.badge.img

Hello Mohamed.

I understand you are seeing different dates in your OLAP, right?

Functions are calculated before filters (Except normal agg like SUM, AVG, etc.)

 

To get functions "filter aware" you can use FILTER_TO_NULL.

https://help.celonis.cloud/help/display/CIBC/FILTER_TO_NULL

Example:

PU_SUM( TABLE , FILTER_TO_NULL( TABLE.COLUMN ) )

Thank you.

Daniel.

 

 

M
Level 6
Forum|alt.badge.img+7

Hello Mohamed.

I understand you are seeing different dates in your OLAP, right?

Functions are calculated before filters (Except normal agg like SUM, AVG, etc.)

 

To get functions "filter aware" you can use FILTER_TO_NULL.

https://help.celonis.cloud/help/display/CIBC/FILTER_TO_NULL

Example:

PU_SUM( TABLE , FILTER_TO_NULL( TABLE.COLUMN ) )

Thank you.

Daniel.

 

 

Thanks for the suggestion! I was able to sort it based on date thanks to FILTER_TO_NULL

However, since I am filtering it based on a certain column I have to apply it as a component filter

Although this works for now, I am getting a not below the OLAP table that informs me that apply a FILTER_TO_NULL within a FILTER is deprecated and that it will not receive support in the future

 

When I try to do the filter within the formula itself it goes back to displaying the null values while correctly sorting it based on date

 

Any suggestions on a strategy rework?

Community Code of ConductAccessibility statement