Could you check if this behavior still observed if Hierarchy for Logical Dimension Table doesn't exits, I mean to say trying to set "Sort Order Column" before Dimension Hierarchy creation , just wanted to check if hierarchy isn't there then still the restriction of column for sort order column selection exists. Hope I…

Does user (MERVE) has privilege to Catalog Task "Properties" whcih allows you to set ownership of the item? also if parent folder owner is changed using Catalog Task "Properties"-->"Set Ownership of this item" and "Set Ownership of this item and all subitems" even in that case underlying object owner would change. Why…

Yes looks like your Advanced Logging for Java Host is enabled and may be you are performing report export which are significant in size because of which response file is written in tmp directory, Please see the document link shared before it clearly states the same OBIEE 11g|12c: How To Enable JavaHost Logging to Capture…

What are the file types(extensions) that exists within Java Host tmp directory? What is the log level set for Java Host in EM, is it default or finest? Also check if any additional logging for Excel and PDF export is enabled for Java Host causing generation of huge files. OBIEE 11g|12c: How To Enable JavaHost Logging to…

Great News!! Yes you can import sample app bar file within the setup following below steps: a) Launch WLST Scripting Tool be executing below command from following location <ORACLE_HOME>\oracle_common\common\bin ./wlst.sh b) Once your within WLST Scripting Tool environment then execute below command importServiceInstance(…

I suppose this is what has happened till now. You tried and install OBIEE 12c first time with ORACLE_HOME=/app/Oracle/Middleware/Oracle_Home DOMAIN_HOME=/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi But since this configuration failed due to missing locale you left the domain(bi) as is and then proceeded with…

My previous response took sometime Now since only obis1 is down then check NQSServer(BI Server Component) logs Log: obis1,obis1-diagnostics.log Location: <obiee_home>/user_projects/domains/bi/servers/obis1/logs Still need answer to What do you mean when you say "We were able to complete installation without sampleapp", do…

What do you mean when you say "We were able to complete installation without sampleapp", do you mean you performed clean slate installation? Correction in your update from screenshot it doesn't look like deployments are down but instead what you are referring to is you BIEE Services or Components, which are down. What is…

If RCU schemas are already in place then please re-verify your database details in OBIEE 12c Configuration Assistance I highly doubt you would be making such a silly mistake , but its good to check. IF database details are correct then could you also check Prefix as DEV (all caps), although I don't think it should be an…

The isolation level(It's related to database) setting controls the default transaction locking behavior for all statements issued by a connection. More on same in below product document link under section "Table 7-4 Connection Pool Properties in the General Tab: Common Properties"…

What is exact version for your OBIEE 11g, is it 11.1.1.7.(X) or 11.1.1.9.(X) wher (X) denotes bundle patch version in the format YY/MM/DD

Have you tried nesting Case(IF) function in OBIEE, try the same you should be able to get your required output

What method have you used in report to remove decimal? Column formatting? Could you chnage your column formula as following example REPLACE(CAST("PI"."DEC" AS CHAR),'.0000','') and then for your Dashboard Prompt ,In Prompt For Column put the same formula as above, you can change the Label to display column name instead of…

Below link is for System Requirement for Oracle Fussion Middleware Products Oracle® Fusion Middleware System Requirements and Specifications For OBIEE 12c instllation on IBM AIX you will have to consider below points: * AIX OS version needs to be 7.1(Update Level 1+) or 7.2(Update Level 0+) , * OBIEE 12c is only 64 bit OS…

The method you are currently using is not a supported approach as you have already mentiond its time consuming as all your changes would be overwritten with next Patch installation in your environment and you would need to do all the changes from scratch, best method is documented approach of custom style and skin OBIEE11g…

When you use the cast function to transform a character data type as a date, you might face issue as reported because date format that you have to give in a formula column depends on the configuration. Give below blog a read for more information on same: https://gerardnico.com/wiki/dat/obiee/obis/cast_as_date

Steps are pretty straight forward and same for all the platforms, the thing you need to take first step:) Here the document with installation and configuration steps. OBIEE 12.2.1.0.0 Installing Oracle Business Intelligence https://docs.oracle.com/middleware/1221/core/BIEIG/toc.htm OBIEE 12.2.1.1.0…

Hello LonaD, What's your OBIEE 12c Version? For OBIEE 12.2.1.1 and higher, the Windows Service is created by default at the time of installation the service is named Oracle Business Intelligence [bi] ,it runs start.cmd in the background which allows you to logoff and keep components running and log for the service is…

Hi Anilesh, Location1: <OBIEE_HOME>/bi/bin this is the one for standard single server installations.(This is the one you should be using for your configuration) Location2: <OBIEE_HOME>/oracle_common/common/bin this one is for enterprise deployments this is far more comprensive than the single server installation and allows…

Hello Pavani, Did you check your hierarchy in RPD, this looks to be an issue with your hierarchy, please check below KM document explaining the same. Getting An Error While Adding A New View To The Analysis, Error: "Logical drill graph level- .... does not exist " (Doc ID 1946146.1) OBIEE 11g: Reports fail with Logical…