I would like to show an OLAP table with the top 3 deviations of the conformance check for a certain dimension

Question

I have created an OLAP table with a dropdown button where I can select dimension and I have linked the outcome of the conformance check by using: READABLE (<%= conformance %>). I put a filter on it so that it doesn't include "Conforms".

However, it now lists all deviations and I am only interested in the top 3. How do I limit it to only show the top 3 deviations per result?

stephane.multo · Answer

Hi Joren,Here are a couple ideas:You might have checked this already, but just in case here is the Help Page article on Confirmance PQL syntaxes, with several examples which might help: https://help.celonis.cloud/help/display/CIBC/CONFORMANCEIf this doesn't suffice, you might be able to achieve your top 3 vision with filters based on PU_Functions (to calculate the # occurrences per violation) and Window functions (to detect top 3 vs not top 3, perhaps using INDEX_ORDER).

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN