-
OBIEE Analysis- Involving Union - Result Column - Calculated Formula
Hello Board, OBIEE Version: Oracle Business Intelligence 12.2.1.3.0 Encountered an analysis that needs updated with two additional columns. Went into said analysis and found that it was performing a union, fine. When I add the SUM(0) to one of the union's datasets, and SUM(column) to the other dataset, I am getting an…
-
Limit analysis row set
HI All, We have a dashboard that contains a number of analyses. One if which is returning many rows ... and, as a result is taking up too much space as opposed to the other components. I was looking for the way to limit/restrict the row to be returned (pagination?). But, I wasn't able to find it. Anyone know how this can…
-
end of file communication error
Hi, We are getting ora-03113 end of file communication channel process id error in one of the dashboard which contain 3,4 reports. All the reports giving the same error. If I restart the services it is coming fine, but after some time again we are getting same errir. Can you please suggest what might be the problem and how…
-
Enabling SSO in OBIEE 12.2.1.4.0
Hi All, Please help with the proper steps which needs to be followed to enable SSO through Siteminder. I got too many documents online but confused which needs to be followed. It would be very helpful if someone who has implemented siteminder sso in obiee 12c provide me the steps. Thanks, Anumita Ray
-
Can Mail body be customized while running Agent
Hi, Is it possible to customize Mail body in Agent like below. e.g. One report will be attached and in the mail body we need to write - Hi, Please find the attached report for your Decision Making. Thanks OBIEE Team (Please do not reply to this mail, this system generated) I am able to write all but not able to color the…
-
Calculation Script Duration Execution Issue
Summary Calculation script takes too time to be done Content Hi everybody, I have an issur on one Calculation script that takes about 5 to 6 hours to perform claculation on the cube. See attached features of the cube. Essbase version 11.1.2.3 OS : AIX 7.4.1 Please could you help me to understand possible root cause of this…
-
OAC Essbse - Maxl script execution using CLI
Summary OAC Essbse - Maxl script execution using CLI Content Hi , I am using OAC Essbase trial version (12.2.1.1.115 ) and trying to execute maxl script using Command Line Interface. Looks like maxl script execution is not possible in CLI. Is there any other alternative ways to execute the maxl script in OAC Essbase? I…
-
How to retrieve the custom column labels used in Analyses using Catalog Report
Hello Experts, We have OBIEE 12.2.1.4.0 on Linux. We used the Catalog Report to retrieve information about the dashboards and analyses. We are trying to fill some gaps in the information retrieved through the catalog report , specifically around custom headings used for columns. We have a number of analyses where we have…
-
Business Intelligence Standard Edition
Dear Experts, What is the difference between Business Intelligence Standard Edition vs Business Intelligence Enterprise Edition? where I will get the installation files for the Business Intelligence Standard Edition? thanks
-
OBIEE 12.2.1.3 nQSError: 76015 The Active Oracle BI Scheduler Instance in the Cluster Could Not Be D
Hi All, I am facing the nqserror 76015 while saving the Agents in OBIEE 12.2.1.3 . I have a OBIEE 12.2.1.3 installed on windows 2012 r2 standard with 2 nodes cluster. All the services are up. Bi schedulers are up on both the nodes. Biplatform schema is correctly given in console. When i try to save an agent we get the…
-
12c Web Services to extract Catalog information
Hi, Been trying to research the documentation on how I can retrieve all the Dashboards, Sub Pages, Objects and access privileges using Web Services. I know it is possible using the tool, but looking for a Web Services option. Would this be the WebCatalog? MetadataCatalog? Or API? If I don't know the Subject Area names nor…
-
Excel template date format issue
Summary No date format is recognized by Excel template Content Hi Team, It seems Excel templates in BI Publisher do not recognize any date format when receiving data from BI Publisher report. We have to manually either replace '-' by '/' in all date fields or use formulas in Excel template as describe in this documentation…
-
Calculated measure used in another calculated measure
I created a calculated measure. Calculated Measure 1, the column in the report is called Account. It is a Case statement but very long and works well. Now I want to use this calculated measure for another calculated measure, Calculated Measure 2. The problem is when I select it, the entire case comes over as part of my new…
-
No access privilege for ifnull(aggregate())
we have recently upgraded to OBIEE 12c, and patched with the latest cumulative patch. Our version is 12.2.1.4.190416 Non-admin users are not able to edit reports having a certain formula. They get the following message: "You do not have access privilege for this subject area" The formula looks like this:…
-
Export ODV Visualization to Other ODV Environment
Summary I got some visualization that need to be export or deployed to other Environment Content Dear All, I have OBIEE & ODV version 12.2.1.2 (server version), when I deploy the OBIEE visualization, I'm using BAR and some of the visualization on the prod server are missing. Fortunately I backed it up before the…
-
Data Visualization Desktop 12.2.5.2.0 available for MacOS Mojave?
The latest version of Data Visualization Desktop 12.2.5.2.0 does not include Mojave. I have a user that tries to upload XLS on this and the results never return and there is no error. On my PC it takes 3 secs. Any idea where I can find the download for 12.2.5.1.0, this version apparently was compatible with Mohave? The…
-
OBIEE 12.2.1.2 -> 12.2.1.4
Hi all Is a more simple way to migrate from 12.2.1.2 to 12.2.1.4 ? I read: https://docs.oracle.com/middleware/bi12214/lcm/OBIUP/GUID-93B3A0DC-7546-4ABB-946E-593B3AAE444D.htm#OBIUP-GUID-93B3A0DC-7… It's very difficult! I heve got a lot of problem on every step Is it way to make clean installation 12.2.1.4 and deploy all…
-
OBIEE - Analysis Location, Usage, Interaction Clarification
OBIEE Version: Oracle Business Intelligence 12.2.1.3.0. Hello Board, I am in a new environment where they use OBIEE Version: Oracle Business Intelligence 12.2.1.3.0. We have a 'Usage Tracking' report that tells us when the last time a report/dashboard was accessed and by whom. We have many old reports that are now…
-
Data Sync Question Where do i see date-time stamp of the criteria / filter
Summary Need to see the filter criteria value of the filter Content Data Sync Question Where do i see date-time stamp of the criteria / filter Need to see the filter criteria value of the filter Version Oracle Analytics Cloud Data Sync (2.5)
-
Update / Inserts in Data-Sync
Summary Looking for the count of records Inserted & Updated Content Is there a way to find out how many records were Inserted and Updated. Separate counts not total counts. Version Oracle Analytics Cloud Data Sync (2.5)
-
Connect Oracle Analytics Cloud to Autonomous Data Warehouse
Summary Error while trying to set-up connection to Oracle Autonomous Data Warehouse in Oracle Analytics Cloud Content Dear all I successfully set-up an Oracle Analytics Cloud (OAC) trial instance and an Oracle Autonomous Data Warehouse (OADW) trial instance. I created two different connections to OADW: * one in OAC "Data"…
-
Will Bin function work in OBIEE when using Essbase as source
Bin() expression in OBIEE. When using Essbase doesn't work. (see Bin() tab for example of a simpple Bin exercise). We don't receive an error, just nothing is ever drawn. It is working when oracle tables are source but need to check and confirm if it will work on Essbase as source.
-
ASO Data copy
Summary ASO mdx data copy is hrs Content Hi All, I have an MDX script which will copy data from one member to other member it is taking 3 hours to complete the script.. is there any way to optimize the MDX or any other way to write it execute allocation process on database app.db with pov "CROSSJOIN ({Descendants([Net…
-
Failed to open the wallet [Hint: incorrect path, auto login not enabled on the wallet file, bad wall
Hi Team, I have installed OHS in server1 and OBIEE,weblogic server in server 2.And i have configured OHS in server 2 to control the OHS webserver from server2. While i am trying to start the OHS,getting "Failed to open the wallet [Hint: incorrect path, auto login not enabled on the wallet file, bad wallet, ...] " I have…
-
Source for data enrichment population column?
Summary What is the source for the population column that can be added in OAC data import? Content When a new dataset is brought into OAC that has certain geographic columns (city, state, etc.) one of the suggested columns in the data enrichment panel is population. Where does that population value come from? Is there a…
-
Update of Direct data Driver->7.1.5
What are DataDirect used ? The following are setup ..windows terminal server .. Can they be easly be updated from 7.1.4 to 7.1.5
-
OBIEE Weblogic server pathces
Dear All, We are using OBIEE 11.1.1.9.x Is it required to apply all below patches for my weblogic server 10.3.6.0 PSUDescriptionPatch Download10.3.6.0.19041610.3.6.0.190416 Patch Set Update (PSU) for WebLogic Server 10.3.6.0See the document in the next column10.3.6.0.19011510.3.6.0.190115 Patch Set Update (PSU) for…
-
OBIEE server logs analysis
Hi, OBIEE 12C version - 12.2.1.4.0 I need some help regarding analyzing OBIEE log files for investigation one incident happened today. Users were reporting that they were unable to login and reports performance was also an issue. I can see following logs in OBIEE server, different logs got different errors, few are generic…
-
V$session p1,p2,p3
who know this p1,p2,p3? SQL> SELECT NAME, PARAMETER1 P1, PARAMETER2 P2, PARAMETER3 P3 FROM V$EVENT_NAME WHERE NAME ='latch: ges resource hash list'; NAME ---------------------------------------------------------------- P1 ---------------------------------------------------------------- P2…
-
An error occurred during execution of "connect". Connection refused [Socket:14]
We have integrated OBIEE with EBS R12. In our DEV instance, unable to OBIEE, the log file is showing below error message OracleBIData/web/log/sawlog7.log An error occurred during execution of "connect". Connection refused [Socket:14] --------------------------------------- Type: Error Severity: 42 Time: Fri Apr 26 12:54:07…
