I try to add a data service link to a OneDrive folder automatically searching for the PO number.
SO I've did the following:
Created normal variable "PO": "EKPO"."EBELN"
Added data service link to an OLAP table with: OneDrive Link...414D1&view=7&q=<=%PO%> (so added the variable add the end to search for that
problem: Opens OneDrice and searches for "EKPO"."EBELN" as text but not the Purchase Order number
When I use a static variable then it is searching for a Purchase Order number, but not the right one, it is a static one.
How is it possible to search for the Purchase Order number for that line in the OLAP table?
Thx and br
Daniel
Best answer by daniel.diers12
Hi Daniel,
now I understand your issue... variables here do not work in the same way. What you would need to do is use the col.. variable. Col1, col2, col3 indicates in which column in your OLAP table the Purchase Order Number stands. I am not sure if it considers hidden columns as well but I would recommend just trying it out. So what you essentially need to do is: 414D1&view=7&q=<=%col1%> --> this would mean that your PO number stands in column 1 of your table. If it stands in column 3 then you would need to use col3.
Thx @kevin.flesc , now it works, but for the local variable it is indeed <%=col7%>, so % and = switched.
&view=7&q=<%=col7%>
Now it is searching for the PO-number from column 7 on the OneDrive, great :-)
After a short view of your problem I see that you are referring to the variable as <=%PO%>, there is a small type, it actually should be <%=PO%>, the equals sign should go after the percentage.
To avoid such small typos in the future, I always recommend using the functionality of the PQL editor to use the prebuilt snippets which always provide you with the correct syntax.
Thanks all for your answers, but problem is still there. The typo was just here in celopeers, not in Celonis, there it is correct. But problem is still there, instead of searching the PO-number (e.g. 4212345678) it searches for "EKPO"."EBELN".
now I understand your issue... variables here do not work in the same way. What you would need to do is use the col.. variable. Col1, col2, col3 indicates in which column in your OLAP table the Purchase Order Number stands. I am not sure if it considers hidden columns as well but I would recommend just trying it out. So what you essentially need to do is: 414D1&view=7&q=<=%col1%> --> this would mean that your PO number stands in column 1 of your table. If it stands in column 3 then you would need to use col3.
It also says it in the description once you enable the functionality. The behavior it has currently is correct because you are adding <%=PO%> to your URL and the variable PO is EKPO.EBELN --> correct behavior.
now I understand your issue... variables here do not work in the same way. What you would need to do is use the col.. variable. Col1, col2, col3 indicates in which column in your OLAP table the Purchase Order Number stands. I am not sure if it considers hidden columns as well but I would recommend just trying it out. So what you essentially need to do is: 414D1&view=7&q=<=%col1%> --> this would mean that your PO number stands in column 1 of your table. If it stands in column 3 then you would need to use col3.
Thx @kevin.flesc , now it works, but for the local variable it is indeed <%=col7%>, so % and = switched.
&view=7&q=<%=col7%>
Now it is searching for the PO-number from column 7 on the OneDrive, great :-)
