I exported barfile from 12.2.1.2 sucessfully with the below command ('C:\Oracle\Middleware\Oracle_Home\user_projects\domains\OA','ssi','C:\Barcreate\Workbar','C:\Barcreate\Exportbar', '' , '', '', true, 'Admin123') Is this the exact command you executed to export and create your BAR file?

Try running the browser F12 developer tool to see if there is an exception related to CSP. If so, try setting the CSP (Content Security Policy) config? - https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2273854_1.htm…

Can you try using another browser as well as trying to clear your browser cache.

I would consider using an Oracle Database feature called Oracle Data Redaction that is part of Oracle Advanced Security that is licensed separately. https://docs.oracle.com/cd/E11882_01/network.112/e40393/redaction.htm#ASOAG594

Is the analysis a direct database request?

Did you install OBIEE into an existing Fusion Middleware home? In other words, did you install just the OBIEE binaries without WebLogic? https://docs.oracle.com/cd/E28280_01/bi.1111/e10539/c1_overview.htm#BIEIG2017

Try refreshing your user GUIDs - https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-E2ABAAA2-FFA2-453F-9C42-4F00807B4708.htm#BIMIG-GUID-E2ABAAA2-FFA2-453F-9C42-4F00807B4708

Can you allocate more resources to the server and see if you still get these negative numbers? Have you tried to get to the root cause of what is triggering this? Do you have some very large analyses/exports that are running on your system?

First question before any others is why are you trying to do this? If User A ran a job, why would you want to change it to User B?

Hi @Harshith Could you maybe explain what your issue is with some images/screenshots of what you're actually trying to achieve? I don't quite understand what your issue is.

What version of OBIEE? Have you checked your log files for the exact SQL generated by the BI Server? Does the SQL run when you run it directly on the DB ie in SQL Developer/ TOAD/ SQL*Plus etc? There error indicates that it is not exactly an OBIEE issue but an issue propagated from the Oracle data source hence the…

11g is quite old and Oracle will most definitely suggest that you upgrade before they'll even ask for log files... You haven't mentioned what analysis is being executed when you see these large temp files. How large is the analysis that causes the large temp files? Is this some sort of data dump used by the end user in…

One option would be to have 2 columns defined in your repository. one with data one with masked data In your analysis, you can use a CASE statement in the column formula to identify which user is running the analysis and then select which presentation column to display. I would suggest that the users are derived from…

My suggestion would be to implement this logic in the transactional system and your ETL will simply pull across the pre-calculated field.

The most recent version of OBIEE is 12.2.1.4 - https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/default-4441820.html

It's a column that has been added in 12c. It is the total temp space used by a query during its execution.

Have you compared the SQL generated by the BI server in 11g with the SQL in 12c? Any differences?

DO you have an Order date dimension in you repository? With a date dimension (as well as a logical dimension with a hierarchy), you can add all date attributes (quarter, month, year, week etc) you require to enable the type of analysis you need to perform.

You should be able to do this by accessing your catalog in offline mode

You’ll need to creat a Windows Service that executes the start.cmd file located in the bitools directory Oracle Support Document 2077764.1 (How To Start OBIEE 12c Automatically When The Server Reboots Or Starts) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2077764.1