Okay so user is from Active Directory, you need to make sure user added is with correct Principal Name, are you using CN or SAMACCOUNTNAME for active directory configuration with FMW security? what AD attribute(CN or SAMACCOUNTNAME ) you use as username to login into analytics application? The issue you are facing seems to…

then just remove WHERE condition from the query and first check if you are checking in correct database and if any of BIEE Schema exists in the database which you are checking. Select * from dba_users; Is DEV was the PREFIX used to create BIEE RCU schemas?

We still stand by the fact that Windows 7 is not a supported OS for OBIEE 12c setup even for a standalone use,it would be better(recommended) you move to a supported OS or setup SampleApplite VM BUT Just out of curiosity, did you check you AdminServer.log and AdminServer-diagnostics.log to verify the actual errors and see…

Probably permissions are not getting applied and reflecting immediately,could you try login into OBIEE Application as Administrative User, Go to "Administration" page and click on "Reload file and metadata" and then login as new user with new application role and test the acess to report and dashboard. OR Just restart BIEE…

Did you get the output expected, following the mentioned step? If yes then close the thread marking all the Helpful and Correct answers.

Yeah that's always better follow the product guide and please close this thread.

Haven't tried it but I think you can migrate directly from OBIEE 11g 32 bit to OBIEE 12c 64 bit as migration jar file just bundles togather OBIEE artifacts(RPD,Catalog and Security) along with configuration files(instanceconfig.xml,NQSConfig.INI etc..) and it doesn't bundle any of the library files from one system to…

How many combination of Country and Currency we are talking about? If it is as less as 4 as mentioned in example then you can go for below approach. Step 1 :For Country Column Prompt define a Presentation Variable for prompt selected value to be stored in the defined presentation variable. STEP 2: For Currency Column…

By console , I meant command console like Command Prompt(cmd) in Windows and Putty etc in Unix Could you redo Step 2 with below settings Step.2 Open in Administration Tool OracleBIApps_BI0005.rpd and use MERGE -- Patch Repository Merge.where: Original Master Repository: OracleBIApps_BI0005.rpd Modified Repository:…

If BI Server cache has been disable in your environment and still reports are hitting cache then did you check if cache is still getting seeded when a non cached report is run? After disabling cache did you purge already seeded cache, because I am not sure but I dont think by just disabling cache it also ensures CACHE HIT…

What is your OBIEE 12c exact version is it 12.2.1.0.X, 12.2.1.1.X or 12.2.1.2.X, X is either base version of a particular release or patch level. To sync application roles within RPD with EM try and follow below steps: Open RPD in Online mode, then Go to > Manage > Identity and then Action > Click on Synchronize…

I think correction is needed in your statement as OBIEE 11.1.1.9.6 doesn't come along with OBIA 11.1.1.9.x infact it was not even released when OBIA 11.1.1.9.x was released, 11.1.1.9.6 is the OBIEE version which comes with OBIA 11.1.1.10.2 Regarding your issue try following below steps and test if you are able to achieve…

Just to add When your environment is up and running and if you directly change value for a parameter in cofiguration files like instanceconfig.xml,NQSConfig.INI etc, for parameter which are defined to be controlled by Enterprise Manager then upon server and services restart value is rolled back to previously set value as…

How is LOGLEVEL set right now, do you any specific setting for LOGLEVEL as off now? You can set LOGLEVEL for all the users by setting LOGLEVEL session variable to '0' using an Init Block and query as simple as Select '0' from dual; and assign the output of this query to LOGLEVEL session variable,setting log level through…

I think you are facing issue as described in below mentioned blog, but there is no reason mentioned for such a behavior: Conditional formatting on OBIEE reports - Red Stack Tech On the report Criteria tab for the columns not getting effected by conditional formatting, Edit the Column Properties-->Navigated to the Column…

Does this help to proceed further: In below mentioned link under section "2.2.3.5 Installing Multiple Products in the Same Domain" https://docs.oracle.com/middleware/12212/lcm/BIEIG/GUID-16F78BFD-4095-45EE-9C3B-DB49AD5CBAAD.htm#ASINS355

This is looks to be correct behavior as CSV format is plain text and It is not supposed to preserve formatting If you need formatted output, use Excel 2007+ export.

Go for BAR file approach, export service insatance from Production and then Import service instance in test environment. Give below blog a read http://www.redstk.com/welcome-to-obiee12c-using-bi-application-archive-bar-files/ Just a request read it understand it clarify your doubts first and then proceed with the steps to…

Yes as pointed by Christian Berg Windows 7 is not a supported OS for OBIEE 12c, so do as recommended. But just going by error message posted it looks like Lock or Permission issue, see the error from your posted error message. [Couldn't open file…

Adding to Christian Berg's comments, which log did you check? you need to check bi_server1.log and bi_server1-diagnostics.log when facing issues related to VA packaged with OBIEE 12c,location for logs is <DOMAIN_HOME>\servers\bi_server1\logs Suggest you to review below mentioned OBIEE 12c KM Document which might help in…