-
Dashboard Prompt using Direct Database SQL?
Hello Experts, Is it possible to create a dashboard prompt using direct database SQL (sort of like a Direct Database Request)? If yes, is there a trick way because I couldn't figure it out. Please help.
-
Unable to download detail report to Excel in obiee12c
Hi Everyone, I am using obiee 12c version 12.2.1.2 on clustered node. The issue here is i am unable to download the detail report with data more than 65k records. When i try to download the report in excel after a while i get this error "There was an error processing your download. Please check with your administrator."…
-
Get ACL of OBIEE Subject area
Hello, We gather provileges on subject areas for security audit. I want to automate this process and dump the subject area privileges into a database table. I was looking into any pre-built utilities from Oracle but do not find one similar dump_ACL.sh which we have for Webcat. Any suggestions on how to go about it. Thanks…
-
Zoom in columns - autosize ?
Hello, I have a horizontal bar graph in OBIEE (12c) displaying regions of my entity axis as vertical axis. I have set up the option to drill in place and zoom for this dimension in order for users to zoom on region and see the countries below the chosen region displayed in vertical axis. The issue is that under some…
-
horizontal clustering in OBIEE 12.2.1.2.0
hi experts , I have question and that is in horizontal clustering in obiee 12c if we have 2 nodes Node 1 with complete installation and configuration and on node 2 we have only weblogic and obiee install . Now if incase the Node1 completely crashes then how can I bring the Admin Server up on Node 2 What is the mechanism…
-
Programming problem on XML publisher...Please help
Summary Programming problem on XML publisher...Please help Content Hi, I have the following XML data which is generated from Oracle Report Builder on EBS. I loaded it into the self defined XML template which is developed on XML Publisher to generate a PDF output. Here is the XML data -->…
-
How to position Static Text in BI Publisher RTF template at a fixed place in the template?
Summary How to position Static Text in BI Publisher RTF template at a fixed place in the template? Content Hi Team, We have a requirement from our client, where they want to print some static text in the O/P template at the bottom of their Invoice template, but not at the bottom of every page of the invoice. So in essence…
-
Printer configuration in Fusion Cloud (BI Publisher)
Summary Printer configuration in Fusion Cloud (BI Publisher) Content Hello All, I am getting below error after submitting an BI report with destination as printer in Oracle Fusion Cloud Application (Version : 11.1.1.11.0) Error deliver document to printer::Exception happened when calling deliver API::Error deliver document…
-
Embedding XML string in QR Barcode
Summary Embedding XML string in QR Barcode Content What my business needs is to embed an XML formatted string in a QR barcode such as: <barcode> <docType>Vouch</docType> <businessUnit>BU</businessUnit> <voucherNumber>12345</voucherNumber> <docDate>1-1-17</docDate> <invoiceNumber>12345</invoiceNumber>…
-
Exporting Data
Summary Exporting Data Content When I try to export a visualization to cvs file using the "Share" Data option I receive a "General Errors Was Found" message. How can I export the visualization to a cvs file without receiving this error message.
-
Print 'Prepare' Visualizations
Summary Print 'Prepare' Visualizations Content The canned visualizations in the 'Prepare' window are very useful. Especially since they are nicely formatted for NULL values. Is there a method to share or print them? Please say 'yes'... Thanks, Stu
-
How to retrieve value of @{session.locale} on BI Server level
Our server run in multi language environment. We would like to show some data based on Locale (location) selected in User Preferences. @{session.locale}. We know how to get WEBLANGUAGE in RPD (BI Server) level. But we can't get value from LOCALE (it's not a session variable). When I log in to OBI I can chose my language:…
-
Level Base measure in OBIEE
HI All , I am having one doubt on level based measure in OBIEE i.e If I created the Level based measure on on measure column against to Year level.suppose If I use the same level based measure value which is calculated at year level with month column in the report what will be results and how it will display .could you…
-
How can I call the UI of Skype or Cisco Jabber from a phone number in a table in Answers?
Hello, Did anyone try to call the UI of Skype of Cisco Jabber from a phone number in a table in Answers? If so, could you please share how to do that? Thanks!!! Pauline Damman.
-
OBIEE 11G - Oracle BI Server Cache (For seeding cache)
Hi All, Here the situation, i have a report with more than 500 000 rows in the resultset and the query is taking 24 min to be executed. The idea is to run the query during the night by using an ibot with the destination : Oracle BI Server Cache (For seeding cache) The ibot is executed but the resulset of the query is not…
-
OBIEE 12C clustering
hi experts , I want to do clustering RHL7 for OBIEE 12.2.1.2.0 So now I have few questions 1) do we need to create virtual ip 2 ) is the failover possible in OBIEE12c 3) so if we configure domain in one server and in the other server we just install weblogic server and obiee then is it going to be failover or horizontal…
-
Oracle DAC connection with MS Azure SQL Server
Dear All, I need to connect MS Azure SQL Server on cloud, in DAC which is installed in premises. means: SQL Server is in MS Azure Cloud Server Orace DAC is in premises. Will you please let me know, what will be the say to resolve this connection issue. Regards, Ather
-
OBIEE 11.1.1.7.0 Installation Fail at Configuration step
Hi friends, We are getting below error while installation of OBIEE 11.1.1.7.0. oracle.as.config.ProvisionException: Unable to validate NonJ2EEManagement Application deployment on admin server. at oracle.as.config.impl.AbstractRuntimeServiceConnection.validateNonj2eeApplication(AbstractRuntimeServiceConnection.java:580) at…
-
Determine and use data based on newest date
Summary Determine and use data based on newest date Content I'm trying to create an RTF layout that only displays information from the latest set of responses from a User. A user may have 1 or more attempts at completing an assessment, I want only the most recent responses displayed on the report. I'm struggling with how…
-
Preview Failed in BI Publisher MS Word 2013
Summary Preview Failed in BI Publisher MS Word 2013 Content Hi, Loading BP Picker Image for Custom Reports using RTF Template is not working. When tried to preview the image it is resulting following error. Error : FOProcessor setLocale: en-us oracle.xdo.XDOException: java.lang.reflect.InvocationTargetException at…
-
Unable to display Ordinal Number in small font in RTF Layout
Summary Unable to display Ordinal Number in small font in RTF Layout Content Hi, Am trying to display date in my report in the format "1st June 2017" which is of a rtf output but the system prints as 1st June 2017 instead. Can anyone guide me on how to get the rtf out with the format which am looking for. Tried below…
-
how to connect my shared hosting mysql database to cloud BI?
Summary how to connect my shared hosting mysql database to cloud BI? Content how to connect my shared hosting mysql database to cloud BI?
-
BI Publisher integration with EBS 12
Summary BI Publisher integration with EBS 12 Content I'm trying to use oracle EBS security inside BI publisher. I read the documentation and I was able to upload the DBC file but when I go to the roles and permissions tab under administration>security center I get the below error: any idea what is wrong? thanks, Rachid…
-
Smart View VBA Connect to EssCS Issue
Summary Smart View VBA Connect to EssCS Issue Content Hello All, I've created a workbook that utilizes Smart View VBA to connect to, submit data to, calculate data in, and retrieve data from an EssCS cube. I set up the connection like I have in the past with OP Essbase, but even though I've sent in the username and…
-
Purge Cache log
HI, OBIEE 12.2.1.0.0 We are using event pulling tables to purge cache, we do manual inserts into BI12C_BIPLATFORM.S_NQ_EPT as a last step of our daily ETL. I can find entries in BI12C_BIPLATFORM.S_NQ_EPT at 6.20 am today, but when I run the dashboard it was pointing to old data. when I verified BI12C_BIPLATFORM.S_NQ_ACCT…
-
OBIEE and HFM Integration data issue
Hi, We have imported HFM 11.1.2.4 application in OBIEE 12c physical layer through ADM We can view all the members for the dimensions but cannot see the values when we try to create reports. It shows blank values. We are able to see data for same combination in Hyperion Workspace. Any suggestions on data can be viewed for…
-
Oracle EBS R12 Integration with OBIEE 12c
Hi All, We have done an out place upgrade with OBIEE Apps 11.1.1.7.1. Now we are supposed to integrate SSO with Oracle EBS R12. Do any body have any article or blog post, idea that how we can achieve that? Keep in mind that we want it for OBIEE 12c. I have done many times for OBIEE 11g, but that is not working if we follow…
-
Unable to set system session variable in repository in OBIEE 12c (12.2.1.2.0)
Hi all Prior to OBIEE Version 12c, it was possible to set the system session variable USERLOCALE to the desired value. (de-ch, de-fr, de-it and so on) This was done with a Now in Version 12.2.1.2.0, this is not possible anymore. Furthermore, the variable is shown as only de, it. So only the same value like in WEBLANGUAGE…
-
OBIEE 12c: [nQSError: 13082] Status of read-only lock on the repository is already true
As an ongoing development process, we always modify the RPD in Offline mode and then upload the RPD to the server. This upload is ran by a Administrator user, which is shared across the developers for uploading purposes. I'm frequently getting notified by the developers that they are seeing the below error while uploading…
-
Bringing in tables from Database
Hello - I currently have 7 different tables that host documents and its pertaining demographics in Oracle Database. Problem - I'd like to create a union or some sort to concatenate all 7 tables into one so that I can load this into OBIEE to use to generate charts. Is there a way to combine all 7 into one (they all have the…
