Managed Reporting Internal Variables

There are several variables related to Managed Reporting processing that you can pass to the Server. This may be useful for controlling processing flow or for display purposes in the report output. You can do this by configuring the <SET> variable (pass) commands in the Administration Console. Useful variables include:

IBIMR_folder. The folder where the processed report is stored.
IBIMR_fullpath. The complete path for a procedure, including file name and extension.
IBIMR_user. The user ID processing the report request.
IBIMR_domain. The domain HREF where the report being processed is stored.
MR_FULL_FEXNAME. The description given to the report by the developer. This description is visible to users. When the report is run from the text editor or InfoAssist, the variable is not populated.
MR_ITEM_HANDLE. The file name (also known as the IBFS name) assigned to the report when it was created. When the report is run from the text editor or the Report canvas in App Studio, the variable is set to ADHOCRQ.

Example: Using Managed Reporting Internal Variables

Sign in as an administrator.
In the Administration Console, on the Configuration tab, click Custom Settings, then type the following code to the end of the file:
```
<SET> IBIMR_folder (pass)
<SET> IBIMR_fullpath (pass)
<SET> IBIMR_user (pass)
<SET> IBIMR_domain (pass)
<SET> MR_FULL_FEXNAME (pass)
<SET> MR_ITEM_HANDLE (pass)
```
Note: Do not write over the existing lines in Custom Settings. The file must begin with the <VER> line.
Click Save.
Sign in to Managed Reporting and use the text editor to create a standard report called test2 in the default workspace.

Enter the following code and save the report:

-TYPE IBIMR_folder is &IBIMR_folder
-TYPE IBIMR_fullpath is &IBIMR_fullpath
-TYPE IBIMR_user is &IBIMR_user
-TYPE IBIMR_domain is &IBIMR_domain
-TYPE MR_FULL_FEXNAME is &MR_FULL_FEXNAME
-TYPE MR_ITEM_HANDLE is &MR_ITEM_HANDLE

Right-click the saved report and select Properties from the shortcut menu, then deselect the Prompt for Parameters option.
Change the description to Test 2 Description.
Save your changes and run the report.

The following output appears:

IBIMR_folder is Sales
IBIMR_fullpath is IBFS:/WFC/Repository/Retail/Sales/variables.fex
IBIMR_user is admin
IBIMR_domain is Retail/
MR_FULL_FEXNAME is variablesTitle
MR_ITEM_HANDLE is variables

When the report is run from the text editor, the following output appears:

IBIMR_folder is Sales
IBIMR_fullpath is IBFS:/WFC/Repository/Retail/Sales/*
IBIMR_user is admin 
IBIMR_domain is Retail/
MR_FULL_FEXNAME is
MR_ITEM_HANDLE is ADHOCRQ