Order to Cash - Formula for selection of customers ordering via a defined order channel

You could use the Button component to set a variable and then use that variable to apply e.g. a sheet filter. AFAIK, it is not possible to set selections (filters you can see in the top) directly from buttons, but sheet filters are a nice workaround. When clicking the button you could write the following to your variable: FILTER "VBAK"."BSARK" = 'EDI'. To cancel the filter, youd need to put another filter expression into the variable, that doesnt exclude items per default (such as FILTER ISNULL("VBAP"."_CASE_KEY")=0;)

Hello Carina, for our Automated Order Entry Analysis we just are implementing an OLAP Table with a similar purpose. We wanted to see the shared distribution of each Sales Orgs Order Entry types like "EDI, CRM, manual etc.) The table (only draft so far) will look like this: AOE102596 2.24 KB For your purpose Sales Org of course could be replaced by CustomerNr. If you are interested in how we implemented it, let me know This is not the real solution for your question, but maybe a nice idea. BR, Marcel

Hi Marcel, thanks for your answer. I have implemented an OLAP Table like yours. We have a lot of EDI Customers ordering a high quote manual or via Customer Portal. I like to give our CELONIS viewers the opportunity to click on a button and then he only sees all customers ordered via EDI but also the quote of other order channels the customer used. At the moment the viewer has to select all EDI customers manual I also tried to implement the table dimension Customer the way that only customers ordered vie EDI using a case when statement and the process start = e.g. EDI. But unfortunately it didnt work. Do you have an other idea? Best regards, Carina

maximilian.hoffmann: "VBAK"."BSARK" = 'EDI' . Hi Maximilian, unfortunately we dont have this in our CELONIS implementation. I have to write a formula using activities like Create Sales Order Item (EDI) to identifiy the Order Channel. Best Regards, Carina

Hi Carina, above code was more of an example rather than the final solution. If you want to go via the activity, you could simply use the process equals function in the filter like so: FILTER PROCESS EQUALS 'Create Sales Order Item (EDI)'