ForeExecResult ForeExec(ForeId tFore, ForeExecArg tArg)
tFore. Moniker of the development environment object that contains implementation of the executed method.
tArg. Operation execution parameters.
The ForeExec operation executes methods implemented in Fore units.
To execute the operation, in the tFore field specify moniker of the unit, assembly that contains implementation of the executed method. The moniker can be obtained on executing the GetObjects operation. In the tArg.methodName field specify name of the method to be executed, and in the tArg.args field specify values of the method input parameters. Method implementation should be located in the global namespace.
Method signature must contain simple types parameters and return a simple type value. If the method returns a value, this value is available in the operation execution result.
If the executed method contains parameters with the Object type, string views of any object's monikers must be sent as values of these parameters. On executing the operation by the moniker the appropriate repository object is obtained and sent to the executed method. To work with this object, cast it to the interface that describes its structure. For example, on passing repository connection moniker, the parameter in method will be of the IMetabase type, on passing express report moniker the parameter in method will be of the IEaxAnalyzer type, and so on.
If a moniker of the binary object saved on the server using the PutBin operation is sent, such object in the executed method can be cast to the IBinary interface.
When the ForeExec operation is running, the time of changing units/assemblies is not checked, that is why the current object version will be loaded to assembly cache from the repository on the first method execution. If method code changes in the future, its repeated execution using the ForeExec operation will result in the execution of the old method version, which already exists in the assembly cache. To use the actual method version, restart BI server.
When developing the web application, from which various methods are supposed to be run, use the following recommendations:
Use ForeExec to execute the code, which makes simple calculations or operations that are not time and resource intensive.
If the code executes resource-intensive operations (report calculation, loading or transformation of large data sets, and so on), it is recommended to think about using a scheduled tasks container, that is, to create a unit execution task and use operations for working with scheduled tasks container to control the task.
When selecting BI server configuration, take into account possible resource-intensive operations that must have been executed in parallel by means of ForeExec. The number of processor cores (physical and logical) must be not less than the number of possible resource intensive operations running in one stream.
Due to possible use of the ForeExec operation for executing the code, to which the particular user must not have access, it is available to disable executing of the operation:
Create the Disallow parameter with the 1 value in the BI server settings file settings.xml. Operation execution is enabled or disabled by BI server.
Create the foreExec parameter with the False value in the web server settings file PP.xml. Operation is enabled or disabled by web server. In this case to disable operation, the p_h parameter with the 1 value is automatically created in the request title.
NOTE. For details about location of parameters see description of the appropriate configuration files.
Create the p_h or p-h parameter with the 1 value in the title of the request that executes the ForeExec operation. The parameter is created by means of resources of the programming language that is used for development according to the application logic. For example, the code developed with JavaScript will be the following:
<html>
<body>
<script language="javascript" type="text/javascript">
<!--...Previous application code...-->
<!--...-->
<!--Function for sending JSON request-->
function PostRequest(url, request) {
<!--...-->
var xhr = new XMLHttpRequest();
<!--...-->
xhr.setRequestHeader('p-h', '1');
<!--...-->
xhr.send(JSON.stringify(request));
<!--...-->
}
</script>
</body>
</html>
Various methods of using the operation are given in the following examples:
Example name |
See also: