Question#1: which RPD is deployed on your server (instance2)? Should be "OracleBIApps11DGT" ...

ok ... for v406 I had to download and implement ... I have v506 and I'll poke around. I also have asked some friends at oracle as well ... so hopefully we get this going!

Did you download the plugin separately from Oracle and deploy it? It doesn't come pre-configured in the VM by default.

I just built this in SampleApp v406 (OBIEE 11.1.1.7.x) ... I made no special adjustments and I see the raw value and the % in the mouse over display. What version are you running?

Use of information drives your data model design ... perhaps you need a data structure that provides for the use of your information. The data base can do much better with your data than the BI server which is better than the Presentation server - you want your BI system to perform (IOW: you want to to serve up the answers…

You need an initblock to fill in a flag for a user with a default if they don't have that requirement, then you need another initblock to evaluate that flag, and then fill in the row-wise variable with either the limited list or the full list.

What about using EVALUATE(LAG(%),....) SQL Server Supports that LAG() functionality https://msdn.microsoft.com/en-us/library/hh231256.aspx

Please consult the BIApps Certification documentation ... https://www.oracle.com/technetwork/middleware/bi/documentation/biapps-11-1-1-10-2-3093800.xlsx That version of apps supports EBS 12.0 - 12.2.7 ... http://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-11-1-1-9-0-2541437.xls shows BIApps 11.1.1.9 being…

No idea what version of the Apps you are running, no idea of the version of the source you are running, no idea of any customization you have done, no idea if whomever is running your ETL/ELT has maintained a lineage All I can tell you is now you have to dig from the source through to presentation layer. If there are two…

"so base the filter of the second report off the results of the first" Here's an example: https://orbiscascade.org/file_viewer.php?id=4409 Effectively you are getting to: report2.Supplier is in report1.Supplier If you have suppliers that might be in report2 and not in report1 - then use a presentation variable for your…

Prompt filters the report with the same subject area ... so base the filter of the second report off the results of the first -- the assumption is that the Supplier Values are identical between the two subject areas.

It's all in the documentation ...

https://docs.oracle.com/applications/biapps102/configref/GUID-3B2DB99B-497B-4736-8197-87C4BB38F004.htm#IT_253

Open the BI Publisher data model for your report ... icon looks like:

You'll need to go through the ETL mappings to see if externals are being brought over (if at all). I can't recall off the top of my head for HR Apps ... If they aren't coming over, follow Oracle's prescribed customization approach so you don't run into upgrade/patch issues in the future. I happened to have 11.1.1.8.1 docs…

Yes ... Provide for managing users/groups ... FMW Enterprise Manager for assigning them to Application Roles

Completely up to the HR system you are using ....

WLS - either holds the users/groups OR retrieves them from a Provider FMW EM - controls Application Roles; where a group (preferably over a user; from WLS) is made a member of the role <-- this is where OBIEE Roles 'integrate' with WLS OBIEE RPD - controls the business logic and querying of underlying data sources; you can…

https://blogs.oracle.com/xmlpublisher/running-bip-reports-in-biee-with-prompts

You may need to seek a third party connector ... or dump the SQL database to files and import into an upgraded version or different database.