-
OBIEE Lineage Dashboard - RPD Metadata Analysis and Catalog (Answers) Metadata - combine these two
Hi All, We have created two different tables for the OBIEE Lineage or OBIEE Metadata analysis of RPD and the Catalog (Answers) - the purpose is to do some impact analysis like 1). if there is a column name change what are the tables, reports that are impacted in the RPD metadata and also the Catalog (Answers) Reports For…
-
OBIEE Analytics - "Most Popular" tab on the home page
Hi everyone, I want to understand on what basis the Most popular tab of the OBIEE home page will get loaded with reports/ dashboards. Is there any configuration involved to enable this feature? I don't have an idea on when the results will be available.. Please suggest Thanks, Yaswanth
-
Error : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
Hi everyone , i have this error when i try to run an analys , as its said i checked the ORACLE connection with the datawarehouse and it works , so i dont know whats the source of the error Thank you for helping , i am new on OBIEE Codes d'erreur : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P Etat : HY000. Code :…
-
OBIEE SampleAPP link online
Hi, Anyone can tell what the the online URL that I can access V607. I had the below URL for V511 and unfortunately it is not working anymore. http://slc02okg.oracle.com:7780/analytics/saw.dll?BIEEHome&startPage=1 Regards, Ibag
-
How to have page break in etext template
How to have page break in etext template if sequence number for records more than 72@
-
State: 08004. Code: 10092. [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not
hi expert , I am getting this error every time I run reports or dash board in OBIEE 11g State: 08004. Code: 10092. [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not currently running. Cannot connect to server machine (08004) what could possibly cause this problem please if anyone can help Thanks
-
OBIEE Top Processes
Hi, When I run TOP command on obiee server, catalogcrawler object comes to the first line and uses %100 CPU. Is it normal? I just want to learn obiee processes and their functions work properly in order to monitor system health. Here are the details of top command; Regards, Dilek
-
Line Graph: Line Width
Hello, Where can I change Line Width for each line graphs? I know that I can add and change for each lines on graphs in properties: But i want change only Line Width (px) for each Line Graphs - default should be a 1 px.Maybe in xml or some config? I have: Oracle Business Intelligence 11.1.1.7.131017
-
BI Publisher 11g Admin Server does not start after moving from one Windows VM to another VM
Summary BI Publisher 11g Admin Server does not start after moving from one Windows VM to another VM Content Facing issue with starting BI Publisher 11g Admin Server does not start after moving from one Windows VM to another Windows VM. Copied the image from one Windows VM to another keeping same IP Address. Admin server…
-
Authentication Error invalid session ID in BI publisher webservices
Summary Authentication Error invalid session ID in BI publisher webservices Content We are using java application webservice to schedule BIP reports. In production instance we are facing below error i. Due to the error, at rare instance almost 1-2% of our jobs fail at random. I searched OTN forum and found a similar but…
-
How to access OBIEE Custom Layouts(BIP template) using GO URL?
Summary How to access OBIEE Custom Layouts(BIP template) using GO URL? Content Created a BI Publisher report using the OBIEE Analysis as a data source. First created OBIEE analysis and added it to a dashboard. Then using the "Custom Print Layout" option in the Print Options on dashboard, created a custom layout that…
-
Footer should be always at the bottom after printing the grouping values
Summary Footer should be always at the bottom after printing the grouping values Content We have a requirement to develop a BI publisher to report one document which has 2 inner groupings where in inside the first group for each inner group looping the report has to generate footer at the bottom of the page like For-each X…
-
After migration to OBIEE 12c (Oracle Business Intelligence 12.2.1.2.0) failed XSLT template
Summary After migration to OBIEE 12c (Oracle Business Intelligence 12.2.1.2.0) failed XSLT template Content Hi I have 11g version OBIEE . And i have report with using XSLT template that get data by Publisher Data Model . In result i get report in XML workbook format. I open it wih Excel. Everything work fine with 11g. But…
-
EXCEL Template
Summary EXCEL Template Content Hi, Could you suggest on below. Below is the data structure in my .xml, I m building Excel output report. <dataStructure> <group name="SUMMARY_MODE_GRP" source="Q_RUN_SUMMARY_MODE"> <element name="L_RUN_SUMMARY_MODE" value="L_RUN_SUMMARY_MODE"/> <group name = "CCID" source = "Q_SUMMARY_MODE">…
-
BIP scheduled reports info
Summary BIP scheduled reports info Content HI Team, We have many BI Publisher reports scheduled. We need to get the information like start date, frequency, recipients , subject etc about all the scheduled reports. Instead of opening each report and check is there any way to get the information of all the scheduled reports…
-
XSLT: namespace getting added in first element of each group
Summary XSLT: namespace getting added in first element of each group Content My requirement is to convert below xml file : <span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="pun" style="font-size: 13px; color: #303336;"><?</span><span class="pln" style="font-size: 13px; color: #303336;">xml…
-
Date functions on BI publisher
Summary Date functions on BI publisher Content Hi, I'm trying to add a year to a 'date_to' field but I can't find function on BI publisher. I need the function to return a year later than 'date_to' e.g. If DATE_TO = 31-Mar-15, I want it to return 31-Mar-16 I keep getting function for difference between dates:…
-
Data Formatting in BIP Report
Summary Data Formatting in BIP Report Content Hi, We have a report in which the database column is a varchar2(4000) field which has very long text. Data is stored with tabs and carriage returns: AAAAAAAA. AAAAAAAAAAAAA. AAAAAAAAAAAA, AAAAAAAAAA When I do a select in Toad and cut paste the sql output onto textpad, I can…
-
Error in uploading RPD file
Hello experts .. After executing the RPD upload command using the data-model-cmd.sh file. Command: ./data-model-cmd.sh uploadrpd -I /oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/K.rpd -SI ssi -U weblogic -P oracle12c RPD Password: i get the following error: Service…
-
S_NQ_ACCT is not inserted after done for Setting Up Usage Tracking in Oracle BI 11g
Hi All, Anyone facing the same issue as title above? I have followed all the single steps in http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html .However, records are not inserted to the S_NQ_ACCT. Anyone share some ideas/experience on enabling usage tracking? Kim
-
PostgreSQL DB into OBIEE 11.1.1.9
Hi Gents, I have to connect PostgreSQL from OBIEE to using Direct DB Request, please confirm DataDirect Connect ODBC Drivers will support?? otherwise which drivers I have to install?? OBIEE running on Linux box. Kindly assist me. Regards, Avinash
-
OBIEE 12c: Why "export to csv" exports lesser number of rows than what is configured in ResultRowLim
In instanceconfig.xml file I have set : <ODBC> <ResultRowLimit>500000</ResultRowLimit> </ODBC> Also, <DefaultRowsDisplayedInDownloadCSV>500000</DefaultRowsDisplayedInDownloadCSV> is set as my requirement is to have 500k records in the exported csv file. But this doesn't work. I can download the CSV successfully, but it has…
-
Cross Joining Rows
Using OBI 11g, How do I transform the following results from that in figure-1 in an Answer analysis to the one in figure-2? Thanks in advance. Initial Result (Fig-1):Product IDContact TypeContact DatePart NumberPart Order Date100-Day Pre Order DatePre-Order Cust. Inq. Count221Cust. Inq.02/11/2016 221Cust. Inq.02/17/2016…
-
OBIEE Installation on RHEL-6
Hello Guys, I want to install OBIEE with OBIA on RHEL-6, please suggest the installation procress. Any per-requsties to be taken care of? I searched few forum and got to know, the following to be installed. Please guide me through the installation process. 1. 12C DB (As i want 12C database) 2. JDK 1.7 only (As suggested in…
-
Uploading on-premise data-model to Oracle BICS - Change of Physical DB Connections to Cloud DB Servi
Summary Uploading on-premise data-model to Oracle BICS - Change of Physical DB Connections to Cloud DB Service Content Hello, Can anyone please help me with the below query? I am trying to uploading on-premise data-model (rpd) to Oracle BICS using the steps mentioned at…
-
BICS-No active services match the currently selected filter.
Summary BICS-No active services match the currently selected filter. Content Hi - When i am logging into BICS i am getting the message "No active services match the currently selected filter." no mater which domain i select.Could you pls help what could be the issue and how can it be resolved. Thanks,
-
Migration error while exporting bundle from OBI 11g to OBI 12c
I am trying to export bundle from OBIEE 11g Ver# 11.1.1.7.150120 to OBIEE 12.2.1.2.0 and i am getting below error problem while exporting. Log location : /home/oraclebi/MW_HOME/user_projects/domains/bifoundation_domain_smis/bilogs/migration 2017-04-03 11:23:48 INFO Loading 11g jars from '/home/oraclebi/MW_HOME'…
-
I want to install Oracle Text, but not found catctx.sql file.
I am presently trying to install OBIEE 11g on Windows 7. OBIEE 11g installation held up due to a pre requirement Oracle Text not installed. I want to install Oracle Text, but not found catctx.sql file. Please help on how to install Oracle text on Oracle 11g database and so I can resume my OBIEE 11g installation.
-
Presentation Variable conversion to Date Format
Hi, We have two fields on a dashboard prompt, Close Month and Release Month End Date. The Close Month is actually a date field, but user would like to see it in 'MMM-YYYY' format, so we have changed the date field to varchar. eg: EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER (30),"Close Month",'MON-YYYY') The release month end…
-
OBIEE12c Migration (from 11.1.1.7.150120) fails
Hi folks I've got a Problem and do not know how to solve it I've installed OBIEE12c on a new (Windows!) Server and extracted there the bi-migration-tool.jar and moved it to the old OBIEE 11.1.1.7-Server where i create the test_Export_170403.jar. When i try to load this JAR into my newly installed 12c Environment it always…
