Below works perfectly fine in OBIEE 12c environment: FILTER("Revenue Metrics"."Revenue" USING ("Products"."Product" IN (@{Product_PV}['@']))) FILTER("Revenue Metrics"."Revenue" USING ("Products"."Product" IN (@{Product_PV}['@']{'7 Megapixel Digital Camera'}))) The only difference is first formula will always display error…

Is it a migrated environment setup from 11g generated export bundle JAR file? If your OBIEE 12c installation and configuration is done on an Windows OS then check DSN name within defined in your instanceconfig.xml file located at following location <DOMAIN_HOME>\config\fmwconfig\biconfig\OBIPS1, check what is the value…

First things first, check whether adapter created/configured for BISQLGroupProvider still exists or not after upgrade, you can check same executing below command. a) make sure your Admin Server is up and running. b) Launch wlst.cmd | wlst.sh (as per your environment) from following location <ORACLE…

Did you go through mentioned document OBIEE 11g: How To Improve the Functionality of Exporting Data from Analyses, Dashboards, and other Oracle BI Presentation Catalog Objects into Microsoft Excel with OBIEE 11.1.1.7.131017 and Later (Doc ID 1595671.1) You can also go through OBIEE 12c Infrastructure Tunning Guide as it…

Is your OBIEE 11g weblogic server up and running? Is port assigned for Weblogic Admin Server is 10443? because default port is 7001 Check if you are able to launch Weblogic Console using following URL http://localhost:10443/console Not trying to point fingers or something but doesn't look like you are not even attempting…

Same test with custom application role(BI Test) which I created works fine. Below is the content of config.xml from my environment, kept it same as yours: <sec:authentication-provider xsi:type="wls:active-directory-authenticatorType"> <sec:name>ADAuthenticator</sec:name> <sec:control-flag>SUFFICIENT</sec:control-flag>…

Works fine in my environment(OBIEE 12.2.1.2.0), check below screenshots In Console: In Enterprise Manager: In OBIEE Analytics

Which application role is assigned to Privilege named "Access to Mobile" , "Enable Local Content" and "Enable Search" Which ever Application Role is assigned to above mentioned privileges for those Application Roles check the assigned Application Policies and make sure those application roles have below mentioned Policies…

Could you post content in between below mentioned tag(Just remove Host and Port information) from your issue environment config.xml file which is present at following location <ORACLE HOME>\user_projects\<DOMAIN NAME>\config <sec:authentication-provider xsi:type="wls:active-directory-authenticatorType">…

Is only "Mobile Application" missing from Home Page or there are other options like VA,Analytsis..etc are missing too from home page? If only "Mobile Application" is missing then check on Administration-->Manage Privilege page what is the permission defined related to "Mobile Application" i.e. "Access to Mobile" If "Mobile…

Here you go https://docs.oracle.com/cd/E69221_01/ Further you can refer Oracle KM document for Oracle BI Mobile OBIEE 11g|12c: BI Mobile (iOS/Android) Latest Application Versions and Supported Compatibility (Doc ID 1986237.1)

What version of OBIEE you are facing this issue, is it OBIEE 11g? if yes then what version(along with patch level) 11.1.1.7.x or 11.1.1.9.x

Hi Ebin, Did you try to explore more on BIPLATFORM schema tables S_NQ_ACCT(Analytics Usage Tracking Table) and S_NQ_JOB(Scheduler table), to find out if a join between these two table may provide you with required information, I have not tested it myself but just a thought as I think its possible to get the information you…

You need to give 10g RPD username and password, 'wadmin' pretty much stands for 'weblogic admin' which means its an OBIEE 11g user, make use of OBIEE 10g user and password use to access RPD. From screenshot I can also see that you are trying to upgrade catalog, do you want to upgrade 10g catalog to 11g? because you din't…

Export to excel 2007+ makes use of BIP Libraries for export as it export report along with formatting present within the report henc it generally takes up more time to export than export to CSV where only data gets exported hence its faster. a) What is your exact OBIEE 12c Version is it 12.2.1.0.X , 12.2.1.1.X or…

Wa alaykumu as-salam, It would not update or edit your current 11g deployed RPD but it would upgrade 10 g RDP to 11g RPD and deploy upgraded RPD in your environment ,but that doesn't mean last copy of your RPD will be deleted it will still be at same location with same name as it is right now. But even if you have your…

Could you test if login with username as "john Doe" works and if it works then are able to get permissions related to newly created application role or not.

Could you perform a test and check what result(whether SAMACCOUNTNAME is displayed as user name) do you get when you search for AD User to assign it to an Application Role, does it give either SAMACCOUNTNAME or Empty Prinicipal Name and Display Name ?

You mean to say "Pivot View" report for which display name gets converted to "Tabla Dinámica" in spanish. What is the complete version of OBIEE that you are using? Do you face issue with all Pivot View(Tabla Dinámica) reports? are you facing report refresh issue when placed on dahboard and filtered using dashboard prompts?…

There is an easy way to do the same using upgrade assistance wizard ua.bat file from your OBIEE 11g environment. Go through below mentioned blog link under section "Upgrading the Oracle BI Repository and Catalog" http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi11115/upgrade/upgrade_to_11g.htm You can…