Jedox reports can be embedded in external web applications. It is also possible for the external web application to set values for @variables in the Jedox report.
URL with passing variables
To find the URL of a report on a server, right-click on a report (user preview), select Properties, and open the Link tab. If this report has the variables “year”, “region”, and “product”, and all of them are not private, then you can pass variables with the URL as follows:
Calling commands from external sources
Note: For security reasons, restrict the postmessages to be only accepted from specific, trusted origin environments.
|spreadhseet.postmessage.enabled||Boolean. Allows sending a postMessage to a container with a Jedox Report.|
String. A comma-separated list of allowed origin URLs for postmessage commands.
<iframe id="jedox" width="80%" height="80%" src=https://to.mydomain.com/ui/lnk/?_=eJxNkD9vg0AMxb8K8oxg6cScpZUitcrKc...>
document.getElementById('jedox').contentWindow.postMessage( [ ['svar', 'Year', 2018] ], 'from.mydomain.com');
This sample script, running on a page on
from.mydomain.com, would set the value of the session variable
2018 (send postMessage to an element with the ID “jedox”).