Hi there,
I work on an analysis to monitor, which sales order channel our customers use.
Therefor I need a button for each order channel, where a viewer can select all customers ordering e.g. via EDI at on click.
So the Viewer can analyse all customers with the possibility of ordering via EDI and can identify which other order channel those customers use.
At the moment, the viewer has to select via a filter order channel EDI, then select all customers and remove the EDI filter, because otherwise the viewer can see only sales order items received via EDI.
Can someone help me with the formula please?
Best regards,
Carina
Page 1 / 1
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:
To cancel the filter, youd need to put another filter expression into the variable, that doesnt exclude items per default (such as
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
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
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:
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
"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:
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)'
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.