-
Data Sync Meta data Information
Summary Accessing OACS Data Sync Meta data for connections and projects Content I am looking for OACS Data Sync Meta data information. I required this information to identify where exactly DataSync stores metadata related to Connections, Project etc In context of connections where it stores source and target connection and…
-
BI Publisher Template
Summary Create a BI Publisher template when there is no data in the XML file Content Hello, I have a data model with 5 data sets and there is no enough data in all the data sets to export and create the BI Publisher template. There are some data sets with no data and not pulling into the xml file. How to create a bi…
-
OBIEE REPOSITORY EXPORT IS GIVING REPOSITORY TABLE OBJECT ERROR WHEN I TRIED TO EXPORT REPOSITORY D
OBIEE REPOSITORY EXPORT IS GIVING REPOSITORY TABLE OBJECT ERROR WHEN I TRIED TO EXPORT REPOSITORY DOCUMENTATION USING RPD UTILITIES
-
OBIEE Plus Components
Hi everyone! I need to know what components are licensed in the Oracle Business Intelligence Suite Enterprise Edition Plus application, especially I want to know if the Oracle Hyperion Essbase application is included in this license. Can anybody help me? First of all, Thanks.
-
Is a fully qualified host name (FQHN) mandatory for OAS/OBIEE Installation?
I am about to install OAS 5.5. I've installed OBIEE many times, so I am familiar with the installation process. This time, I was planning to install OAS with short host names. Reason being, I want to clone the LINUX VMs (let's call this development) once all components are installed and operational, as to avoid repeating…
-
Zip files left behind from Bursting Program
Summary Bursting program leaves zip file in concurrent request output directory Content We have several XML Publisher jobs which burst the output to recipients via email. During the bursting process (XDOBURSTREP), it seems to be zipping up the output of the XML Publisher job (which in our case is always PDF) into a zip…
-
OBIEE 12c Component Status Notifications
OBIEE Component Status Notifications Sending the Output Through Email Environment : OBIEE 12.2.1.4.0, WINDOWS SERER 2016 Every day we have to send the status of the OBIEE 12c server by automated email. Is this possible to implement ? fire the status.cmd on command prompt once status exectued it will send by email to the…
-
Obiee rpd and webcat convert to lower version
Hello, We have to lower the version of rpd and webcat from obiee 12.2.1.3.0 to 12.2.1.0.0 as we came to know the version difference while we are migrating from test to production.. ..now we do not have the time to upgrade obiee to the above version. In 11g we had option to lower using nqoldverrpd..but couldn't find the rpd…
-
Agent recipients displaying in the email after upgrade to 12.2.1.4.0
OBIEE version: 12.2.1.4.0 OS: Microsoft Windows 2016 x64 (64-bit) We are now upgrading to OBIEE 12.2.1.4.0 from OBIEE 12.2.1.3.0. We have many agents that distribute reports (analyses or dashboards) to users via email. Some of these agents have rather large recipient lists. When these agents run & send the emails out of…
-
Selection steps impacting grand total
Hi all, I have a problem, not sure if it's a misunderstanding of selection steps or an error in my repository. In my repository I have a dimension for company and a fact table with employees. In my analysis I have the column for company from the dimension and the column for the number of employees within a company with a…
-
YTD calculations on PBCS data
Content Hello Everyone, I am building dashboards in DV (oracle managed) on top of PBCS dimensions and data. PBCS provides Dynamic Time Series functions (YTD, QTD, MTD etc.) out of the box but these functions don't seem to be accessible from within DV. Since PBCS has separate dimensions for Years and Periods, hence it is…
-
Obiee 12.2.1 teradata database connectivity
Hello all, We are trying to set up obiee 12c connection with teradata 12.. we have added the odbc entry in odbc.ini in config/core/odbc.ini.. Now what are the entries to be added in rpd connection pool..the server IP of database in odbc.ini . can we create a odbc in the system where admin tool installed and it can be used…
-
Calling Oracle BI Publisher Report From Oracle Forms 10G
Dear Gurus, Please guide me could i call Independent BI publisher Report from oracle forms 10g. If Its Possible how it could be done. BI Publisher 12.2.1.4 and Forms 10g
-
OBI on prem vs OAC
Has anyone done a fit-gap analysis of moving their OBI (on prem) reporting environment to OAC? I am searching for any information that might help identify any functionality loss in moving from OBI to OAC for reporting (Answers, Publisher, Dashboard, Security, etc.).
-
OBIEE 11G - SMTP SSL Configuration
Hi everyone I'm using obiee 11g (11.1.1.7) for dispatching daily mails with refresh dashboards. Now Mail services asks to communicate with SMTP Server through secure channel. BI architecture is not SSL enable. SSL is used only to communicate with external LDAP. I'm having troubles trying to configure Mail Server settings…
-
Connect the existing Subject Area to a new DB
We have a OBIEE Subject Area connected to an oracle database named OLD_DB. And there are few standard and adhoc reports which are built based on this subject area. Now, a new database NEW_DB is built which is similar to OLD_DB with few more additional tables and columns. How can I connect the existing subject area with the…
-
OBIEE next version
Anyone knows what OBIEE next version will be and if it coming within this year?
-
Missing data when multiple companies being selected
Hi, I'm facing following problem. With below mentioned data model I get data when selecting company 00001, I get data when selecting company 00004, I get data when selecting multiple items from which I'm sure they should return data for both companies 00001 and 00004 but I only get data for company 00001 when I don't…
-
TopN functionality in OAC not giving appropriate results
Content Hi, TopN functionality in OAC is not giving appropriate results. Does any one know how to fix this? My Top10LoginCount is a custom calculation that is calculated as TOPN(“Login Count”, 10). In the screenshot attached, on the right hand side legend only 3 customers are shown. In case, I change the calculation to…
-
Writeback Error
Hi, I am using OBIEE 12.1.2.1 and implementinh writeback, I have followed the steps to configure as outlined below https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-6F16F7CA-E525-4569-A5A0-C1C0F851F57E.htm#BIESG9156 When attempting to insert a record in the analysis I get the following error The system is unable to…
-
Latest Date from Date column - To be implemented at RPD Level
Hi All, I have requirement to build report 1. Status with Latest Date. I have a date column,status column populating from same dimension table. I want to get the latest Date from Date column. At a report level we can add MAX Function on date column but I want to achieve this in RPD. how can we implement this at RPD level ?
-
Disabling issue of SQL through Go URL in OBIEE 12c
Is there any way to disable issue of SQL from Go URL in OBIEE 12c? If yes, how can we do this? Any help would be appreciated.
-
Dashboard Prompt Default to LAST_DAY(sysdate)
Is there anyway to default a dashboard prompt to the last day of the current month? I tried using SQL RESULTS as "select last_day(sysdate) from dual" but this does not work. The prompt defaults to "All Column Values". The value needs to be a date in the format MM/DD/YYYY. I want to avoid adding a variable to the…
-
OBIEE (12.2.1.4) I need an alternative to using a "union" in an analysis
This is my first post, hopefully I explain myself thoroughly. I'm using OBIEE 12.2.1.4. This is a scenario which I've made up. My real life scenario is very similar to this. I'm having issues using "unions" in my analyis and getting a correct Grand Total %. So here goes.... I have a database table with Attempts and…
-
ML Algorithms in OAC
Summary List of ML algorithms provided in Oracle Analytics Cloud Content Hi, I would like to know what are the ML algorithms that are available in the latest version of OAC. Are there any new additions? I am specifically looking for algorithms like Singular Value Decomposition and Tree based algorithms. Or does Oracle Big…
-
Error when i try to save a report in Shared Folder
Hi, when I try to save a report in Answers in Shared Folder, I receive following error. : I log in as weblogic user. Weblogic user has a Full Control to Shared Folder. How can i resolve the problem? Thanks
-
Save a report directly in Shared Folder
Hi, I have a doubt. In Oracle Business Intelligence Analysis is possible to save a report directly in shared folder without to create a folder? Thanks
-
'Explain' feature in OAC
Summary Reliability of OAC 'Explain' Feature Content Hello, I've been Exploring OAC's "Explain" Feature to generate meaningful insights out of my data. For ex, I have ErrorCode as one of the fields in my data and I would like to find the probability of occurance of a particular ErrorCode based on other fields in my data,…
-
Where is "Available to Reserve" fact in BI
Could you kindly advice where in BI is "Available to Reserve" fact located in? So far none of the following facts and dimensions display the result: 1) Subject Area: Distributed Order Orchestration - Fulfillment Lines Real Time -> Dimension folder: Fulfillment Lines - General -> Reserved Quantity 2) Subject Area:…
-
OBIEE Scheduled Reports not displaying addressees in the Email
OBIEE - When I schedule a report to email recipients, the outgoing email does not populate the addresses in the TO box. I am manually entering addresses within the scheduling function. Below is a screen shot of what one of the emails look like. You can see that the "To" is blank. Any ideas on how the get the emails to…
