-
Can we bring physical query generated by BI Server into S_NQ_ACCT Table for usage tracking.
Hi All, Can we bring physical query generated by BI Server into S_NQ_ACCT Table for usage tracking.? Is there any way, Thanks, Abinash
-
Regarding scheduling OBIEE reports
When we schedule OBIEE reports via an agent, is there a way to see the SQL query getting generated?
-
Upgrade jdk1.8.0_65 to jdk1.8.0_121 in OBIEE12.2.1.0
Hi guys, We have upgraded jdk1.8.0_65 to jdk1.8.0_121 and set the JAVA_HOME and path environment variables.What are all the changes i need to take in OBIEE12c folders? I am getting errors when i am trying to run status/start/stop.cmd from command prompt. E:\OBIEE12c\user_projects\domains\bi_itrac\bitools\bin>java -version…
-
stop ManagerServer1 with command prompt using SSL Port
Hi All, We have enabled SSL+SSO on analytics and EM/Console both. I know restart of OPMN is nothing to do with the SSL, but while stopping ManagedServer1 we need to put port number in command. I'm able to stop ManagedServer1 using Non-SSL port with below command, ./stopManagedWebLogic.sh bi_server1 http://ip_address:7001…
-
OBIEE 11.1.1.9.0 Unable to reach Analytics :7001/analytics - getting 404 page not found
when iI type http://localhost:7001/em on IE browser I see the following login screen ( I enter weblogic User and the password) I am able to log in I I was able to deploy the rpd file as well using the following screen I restarted all the servers successfully after that However when I tried to go to localhost:7001/analytics…
-
OBIEE 11.1.1.7 creating wrong join
Hi All, I have come up with a very frustrating issue. I am trying to explain the situation below: I have got this fact table joined to three main dimensions (Organisation, Product and Month). The fact table is monthly partitioned. Our fact data is also identified by YEAR_MONTH (i.e. 201601) not by any specific date. The…
-
Javascript and onload in a dashboard
I am trying to fire an onload event that would run javascript to customize some CSS whenever a dashboard is run. But I can't figure out what to file to modify. I would need to add the javascript and then call the javascript function from the onload event. If you do this from the home page it's pretty simple. One way top do…
-
Embedding Oracle ADF Page in OBIEE Dashboard
Hello All, I am embedding Oracle ADF Page in OBIEE Dashboard using Embed Content Object. I am having a Test.jsf Page in ADF Application with a InputText Component and a Button. I am using Oracle ADF 12.2.1.2,Oracle Jdev 12.2.1.2 ,OBIEE 12.2.1.2 and Weblogic 12C. The issue is the ADF Page in the OBIEE Dashboard is…
-
SQL Direct REport Conditional formatting on columns - OBIEE 11.1.1.7.151020
Hi All , Am looking a way to use Conditional formatting features from analyses but the same is greyed out . Please any one could advise me about how to do it ? Thanks for your advice . Regards , Morel
-
Rounded edge table
Summary Rounded edge table Content Hi, is there a way to create rounded table in XML template. I need to display dynamic data in that table. Sample: <TEXT> <XML DATA> <TEXT> <XML DATA>
-
Bi Publisher - loop over variable NOT over XML tag
Summary Bi Publisher - loop over variable NOT over XML tag Content Hello folks, I'm having trouble producing a report using BI Publisher. Basically I have an XML with these tags: <course> <course_id>1</course_id> <start_date>2017-01-17</start_date> <end_date>2017-01-19</end_date> </course> I would like to generate N rows,…
-
Oracle BI 11 Switch Metadata Schema
Summary Oracle BI 11 Switch Metadata Schema Content Hello. We have Oracle BI 11 Publisher installed on Linux. Now Database where Metadata is stored lost. And We don't remember names of MDS and BI_Platform schemes. Please help, how can I switch OBI Publisher to the another (new) database schemes? Where (in which files) I…
-
Advanced Analytics Install Error
Summary Advanced Analytics Install Error Content Hi, When selecting 'Install Advanced Analytics' from the start menu in opens a cmd window then fail with the following error. RInstall.log Feb 01, 2017 3:23:32 PM oracle.bi.dvdesktop.birinstall.RInstall mainNoExit INFO: Timeouts: execute = 1200 secs, read = 10 secs, connect…
-
Conditional Region on RTF template
Summary Conditional Region on RTF template Content Hi, I have an RTF template and i want to put a Conditional Region around a block of text. I am using a PeopleSoft XML fie as my Data Source. I have used this function many times but these have always been for straight forward conditions like <?if:A.ACAD_PROG='MH3AA'?> If…
-
Stacked bar-area-line or multiple lines on graph
Summary Stacked bar-area-line or multiple lines on graph Content Hi i have a requirement to show stacked bar, area, multiple lines in a graph. Please let me know if this is feasible in BI Publisher. It would be very helpful if anybody can point me in the direction of how this can be done. Thanks
-
How to use FTP for outbound integration in Fusion cloud?
Summary How to use FTP for outbound integration in Fusion cloud? Content How to use FTP for outbound integration in Fusion cloud?
-
Apply/Revert/Done buttons are not visible - Write Back OBIEE 12c
Hi All, I am implementing Write Back Feature in OBI 12c. In Analysis, Table properties, when I check "Enable Write Back" Apply/Revert/Done buttons are not visible. Able to enter/edit text but not able to apply changes as buttons are unavailable. Various attempts have been made, but no luck. Any suggestion would be highly…
-
Creating HFM reports in OBIEE
Hi, We have a requirement to create HFM reports in OBIEE and have completed following tasks. * HFM 11.1.2.3 Server is installed on Window environment * OBIEE 11.1.1.9 Server is installed on Oracle Linux Environment * Installed Oracle Database 11g on Linux Environment Next steps which are going to follow are * Install HFM…
-
OBIEE Patch management and upgrades
Hi Legends Can you help me with some insight into how you are managing patches and upgrades for OBIEE. Business is more focused on stability (if its not broken don't touch it mindset) but as tech guys we strive to keep up with the versions, latest patches and latest functionality. How are you guys managing this? How can we…
-
How to run all failed BIP jobs at a time or few selected jobs
Hi All, Some times my BIP jobs got failed that I have to run report and export in scheduled format and then I have moved to FTP area, this is manuall process. But I want run all failed BIP jobs at a time. In Job Manager tool it is working fine for Agent's but how to do for BIP jobs?. Thanks, Ramesh
-
Issue with agents scheduled in OBI 12c
Hi, We have recently migrated from obi 11,1,1,7 to obi 12.2.1.0. In 11g we have the agents configured as 1 parent agent which runs daily once and checks for condition, if true then it invokes 5 child agents. With the default 12c scheduler configuration along with my organization mail settings and only with increase in file…
-
ownership of middlware
hi experts, I have installed obiee 11g as oracle user but now our company want to change that ownership to suppose abc how can i do that please Thanks
-
obiee11g accidentally remove administrator role from weblogic and now can't login to console / em.
Administrator role from weblogic was accidentally removed and now we can't login to console or em. Is there any way to restore de Administrator role for weblogic? Thanks; Nicolás
-
Open BAR file, without improting in OBI 12c
Hi I am wondering how can we open BAR file without importing in to service instance. I have gone through below oracle doc about importServiceInstance command but this command allows to import into a target service instance, which i dont want to do it before knowing whats in that BAR file. 9 Managing Metadata and Working…
-
unable to open Admin Tool in OBI 12c
Hi OBIEE 12c is installed on windows server & I was working in rpd in the online mode and all of sudden its crashed. I am unable to open Admin tool any more, it started showing up error as below. any one had this issue? any solution? please Thanks MM
-
Who writes a query?
Hi Team, Please help me to understand the OBIEE functionality. When we run any report/dashboard, who writes a actual query? Is it a bi_server1 in OPMN components or it is a Managed Server? Many thanks in advance. Sagar Tippe
-
Sending email in OBIEE 11g: Failed to open connection to SMTP server
I am trying to send an email with SSL in OBIEE11g, when running an ibot, but the agent fires an error: THE AGENT zzzz, has failed. [nQSError: 75027] Failed to open connection to SMTP Server (host mail.xxxxxxx.es; port 465). AgentID: /users/weblogic/zzzz I checked with network administrator to find if the smtp server name…
-
OBIEE 12c - Write Back Error: "An error occurred while writing to the server. Please check to make s
Hi All, Getting below error while attempting to implement Write-Back feature in OBIEE 12.2.1.0.0 "An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator" System: MS SQL server database Oracle Business…
-
Banner for ETL completion status
Hi, OBIEE 12C My client would like to have a Banner kind of representation about the ETL completion for 'today' while he logged in to the OBIEE . I can put one table and log my ETL status for each step and use that Data for this purpose. #1 Can we put this notification irrespective of a Dashboard? just somewhere in a login…
-
BI Publisher Two Columns in one Page Design Problem
Summary BI Publisher Two Columns in one Page Design Problem Content Hi , I need to designing to transcript for my university . I prepared query with peopleSoft Connected Query Manager and I got the xml source code .When I tried to page divide two columns for page layout then all my design break down.if I no change in page…
