Focal Point
[SOLVED]Full Fex Path in RMLDB

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4297070386

July 11, 2016, 04:39 PM
John C
[SOLVED]Full Fex Path in RMLDB
I'm looking for the full path name for a .fex executed in our BI Portal. Using the SMWFAPPPATH field in the RMLDB.MAS only provides the top 2 directories of the fex that was executed. Example - The SalesbyMonth.fex is executed from the /Sales/Sales_Reports/Content/SalesMonthly directory in our BI Portal, but the SMWFAPPPATH field in RMLDB.mas only contains the following information - /Sales/Sales/Reports. I'm looking for a variable that would contain the /Content/SalesMonthly directory information.

WebFocus 8.1.05
Windows, All outputs

This message has been edited. Last edited by: <Emily McAllister>,


8.0.8, Windows, HTML
July 13, 2016, 10:22 AM
Tamra
quote:
SMWFAPPPATH

John,

The following variables exist, will this help?

IBIMR_folder
IBIMR_fullpath
IBIMR_user is admin
IBIMR_domain
MR_FULL_FEXNAME
MR_ITEM_HANDLE

This can be found in the WebFOCUS Security and Administration 8.1.05

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

Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator - Information Builders Inc.


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
July 18, 2016, 03:01 PM
John C
Tamra,

I can't see these variables when I run the "-? &" command from a separate fex. Can you provide an example of how I would print these variables?

Thanks, John
July 27, 2016, 07:50 AM
John C
I found the column in the RMLDB.MAS synonym that contains the full path - it's called SMWFBASEDIR


8.0.8, Windows, HTML