-
BIP Addin For MS Office 2016-32 bit - Install Issues
Summary BIP Addin For MS Office 2016-32 bit Content I am installing BI Publisher Template Builder for Word on my PC running Windows 10, MS Office 2016 (32 Bit), JRE 1.8.0_61(32 bit). Installation completes normal but the BI Publisher ribbon does not appear in MS Word. In Word Options, the addin "BI Publisher Template…
-
Unable to get the DLL path for the CLI Default from the NQSConfig.ini file
Summary Unable to get the DLL path for the CLI Default from the NQSConfig.ini file Content Permanently get this error. After reinstall DVD works fine some time and then got this error again. Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general…
-
Image or URL in Oracle Analytics Cloud
Good evening; Someone knows how to use images as URL or deposit on the OAC server, I need to add an image either URL or make use of this inside the server, if this is the last way, the folders inside the server should be hosted ? On the other hand, in URL of which pages allows to make an embedded use and does not show me…
-
OBIEE12.2.1.4.0 - Can we achieve this in BI Answers
Dear Experts, We are using OBIEE 12.2.1.4.0 on Linux environment. this is a brand new install with no patches applied. We are trying to meet an expectation on a report, but not sure if it can be done with BI Answers. What is required is highlighted in Yellow . Please suggest how we can achieve this . Thanks in Advance.…
-
S_NQ_JOB_PARAM
Hi Everyone, We have upgrade one of our environment, from 11.1.1.6 to 11.1.1.9. That environment had lots of try and erorr, catalog upgrade (from various source). Right now, the s_nq_job_param has duplicate records for the same Agent. We were thinking about disabling every agents, cleaning the s_nq_job_param table and…
-
How can i create this metric in rpd
I have created a table based on the view below I can get a count of ACT_CAND which is the metric I am interested in by running this script ( SELECT DISTINCT CAN_NUM, J_GROUP, PI_COMP_DT, ACT_CAND FROM V_DIST_FACT3 order by ACT_CAND,CAN_NUM, J_GROUP, PI_COMP_DT; )in the database, I wanted to know if there is anyway I can…
-
(Untitled)
Summary [deleted] Content [deleted]
-
Filter with function on image
Good day, someone has made filters with images, that is to say, that by means of an image it is pressed and the board is updated according to the selected image. I attached a link that I found on YouTube but in my case it would not be with a map image but rather with different logos of type of service.…
-
Smartview connection to MS SQL Server
Summary Is it possible to connect to MS SQL Server from Smartview? Content Hi, For the Smartview add-in for Excel that is provided by Oracle, is it possible to connect to Microsoft SQL Server from it? Can you please provide any links that talk about how to do this? Thanks for your time
-
Error Codes: OAMP2OPY:E7JI73LX A numeric value was expected
Hi All, I have two dashboard prompts. When I enter a text in numeric field I get the below error. If I check the option - limit values by all prompts on both the prompts and enter text I get the following error. Error View Display Error Error generating view. Process action error. Error Details Error Codes:…
-
List of all Direct Database Query Analyses
What would be the easiest way to find all the direct database analyses? We're getting ready to do an EBS upgrade to 12.2.8 and I need to make sure that our BI queries conform to the new 12.2 architecture. Any help is appreciated. Oracle Business Intelligence 11.1.1.7.160719
-
BIP 12c Error while login
Hello, I have freshly installed OBIEE 12c instance . Everything was working fine then i stopped and started the BI services from command files in bin folder. After service restart i'm getting this error while login to BIP Error: "Server not initialized. Please make sure the repository is ready." My Application version…
-
OBIEE 12c error for analytics and BIP
I have freshly installed OBIEE 12c instance . Everything was working fine ,While configuring BIP security i have enabled the local superuser and after that i have changed the default security model from Oracle Fusion Middleware to BI Server . After that i have restarted the BI services ,but after service restart i'm not…
-
Data visualization analysis query request can't be accepted by BI server successfully
When you explore an analysis in analytics in OBIEE 12.2, actually browser sends a post request to server with some parameter. If I send the request with header and formparam to the server using a tool like Postman or Gatling or Jmeter, those tool receive the request successfully and I can see the query of the analysis in…
-
Request URI:/em/ai/bi/instance.jspx/helppages/errorPage.jspx
I am getting subjected error while clicking on Coreapplication in OBIEE Enterprise Manager, even though I tried the below steps but still getting the same issue. Please advise... 1- Navigate to FMW_Home/user_projects/domains/bifoundation_domain/sysman/mds/partition1/oracle/sysman/mds/files/model/mdssys/cust/user/weblogic 2…
-
Drill down returns no results in Analysis
Hi There, I'm using Oracle Business Intelligence 12.2.1.0.0 and I'm having issues with results not showing when I drill down. For the home page of my dashboard, you can select the manager you want to view and this will show their performance. When you select your manager, this creates a variable with that manager's name.…
-
How to use filter function with group by
I am trying to create a metric using filter function with a group by. I am not sure whether the filter function even works with group by in OBIEE answers. I need something like this ( Filter (#ex.XYZ Fatct group by a,b,c). my expected results is a count of all cases of yyFatct grouped by a,b,c
-
Passing Multiple Filters on OBIEE 12c On Premise.
Hi All, As i have requirement to pass filters from Report A to Report B . I used navigation to implement this scenario, but it filters/pass only one column value but not multiple. I verified the column definition or formula on both Report A and Report B , Everything is same. So not found any differences. I verified the log…
-
Get all email from Agents and Jobs
Hi We have to get all email addresess from our instance of OBIEE used in Agents, Jobs. We have a lot Agents and Jobs. Very difficult to gather info about emails manualy Can i do it by SQL from repository(s) of OBIEE. What's tables i have to use?
-
Oracle BIP RTF - Calling for Template
Summary Oracle BIP RTF - Calling for Template Content Environment: Oracle Fusion Cloud R13 Scenario: We are calling Sub Template from a Base Template using the below call statement <?call:ABC SendInvoicesTo?> Note - ABC SendInvoicesTo is the Sub Template Block Name. ABC value can be derived from a Database Column.…
-
Need assistance to implement WLST SSL Connect Exception "SSLHandshakeException: General SSLEngine pr
Hi, i am having similar issue as WLST SSL Connect Exception "SSLHandshakeException: General SSLEngine problem; No available router to destination" with DemoIdentity and DemoTrust keystores (Doc ID 2320855.1). I am trying to implement solution but i didn't find JAVA_ARGS section in…
-
Unable to start server using start.sh
Hi Team, I have "Red Hat Enterprise Linux Server release 7.4 (Maipo)" enterprise edition in on premise server with weblogic 12.2.1.3 running as application server and OBIEE is installed as managed server. I have another server on aws where "Red Hat Enterprise Linux Server release 7.6 (Maipo)" enterprise edition is…
-
OBIEE AGENTS MISBEHAVING
Hi Guys, Yesterday I faced an issue. I have created bots that sends email to several people. They were working fine from 3 months. Yesterday what happens that some of the users didnt get the email. I checked the diagnostic logs on the EM. it gives the following error. [nQSError: 77006] Oracle BI Presentation Server Error:…
-
Showing data Horizontally instead of vertically
Summary Instead of rows, I need to post my data horizontally Content I am not doing a crosstab/pivot table, just simple display. I have searched the forums and am pulling my hair out. instead of ---------------------------------------------------------------------------------------- Jane Doe '0000769' Leave Accruals SK: 55…
-
OBIEE 12.2.1.4 Mobile App, "apps library is not configured correctly"
Hi guys. I am going to publish a sample mobile app in OBIEE and I get "apps library is not configured correctly" error. Could you help me to figure it out PS : please don't refer me to oracle support link. Regards
-
Essbase 11g as a data source for OBIEE 12c
Hi Everyone, We want to use Hyperion Essbase 11.1.2 as a Datasource for OBIEE 12c for creating some analytical reports on data from Essbase. Please help us with the supporting DOCs ,Best practices followed and Potential integration issues that we may encounter while integrating essbase with OBIEE 12c . Thanks Bhanu
-
10g Migrated 12c Report is not displaying count of rows.
Hi All, I facing OBIEE report format issue.We have migrated 10 > 11g > 12c. Report is not displaying count of rows on 12c Report. Could you please any one help..! 10g Report: 12c Report: Thanks in Advance. Regards, BNTB
-
OBIEE Starting Page Mobile
Hi everyone, We use 12.2.1.4.0 version of OBIEE. We want to set every user same starting page but also we want mobile app and desktop have different starting pages. For example : if user log in the desktop should see aaa dashboard but log in mobile app should see bbb dashboard. Is there any way to set this? Thx.
-
OBIEE CLONING
Hi Team, I have one OBIEE server with obiee application running on it. I am replicating this whole environment from this environment to another environment by using resync command which is copying my entire mount point from existing environment to new environment. But my question is, in my new environment, where all i have…
-
Patch Merge Question (11g)
Hi All, Quick question on a patch merge. There is a dialogue box that pops up, after hitting "compare" - 'Do you want to mark differences in the repository immediately': I haven't been able to find too much about this (what it is, what is does, etc.). Does anyone know what is best to select for this? Or, the difference…
