-
Add date format in Prompt of OBIEE
Hi I want to add date format in promot of dashboard and followed the following document but fail How to Dispaly date type data to a format such as 'DD/MM/YYYY' (Doc ID 963352.1) Used below query in SQL of Prompt SELECT EVALUATE('TO_CHAR("Time"."Calendar Date")',"Time"."Calendar Date" , 'DD/MM/YYYY') FROM "Data Management"…
-
Unable to change edit/view mode:
Hello all, I logged into Obiee balance score card as administrator and tried to toggled between edit mode and keep getting the following error message. I have turn Toggle Maintenance Mode off and also clear all user Sessions but the error still coming back. Any direction as to how to solve this will be appreciated. Unable…
-
Opening detail report on same page
Hi all, I am trying to create an action link that doesn't open the detail report on another page, but adds it on the same page as the master report. I want it to be invisible at first and want it to appear whenever someone clicks on a value. I know it's possible because I've seen it before, but I can't find it anymore. To…
-
obiee 12.2.1.4.0 installation in aix failing at the configuration step
Hello All, We are trying to install obiee 12.2.1.4.0 in aix 7.1 and installation fails at configuration , exactly at adding default service instance. Error log looks like vague and couldnt find the root cause. [ERROR] [] [oracle.bi.install.config.actions] [tid: 81] [ecid: 0000MM66WXn5qYsLGi5Eif1RXepK000004,0] Non-skipped…
-
Create ibot based on dashboard selections in obiee 11g
HI I have dashboard, if i select values at dashboard prompt and once i click apply button, i need to see the report and send report via email through agent. IS this possible in obiee11g. Can any one suggest , as is this doable or not?
-
Oracle Data Visualization for Desktop
Summary Unable to query Microsoft SQL Server Database Content In the Oracle Data Vizualization Desktop for Windows Version 12.2.5.0.0-20180829155113 I have created a connection to Microsoft SQL Server 2016. I had to use the IP address rather than the host name for the connection but now that I have done that the connection…
-
ML Based Data Visualization
Summary How can we embed results of machine learning analysis in data visulization Content It is interesting to have discussion around machine learning based data visualization. We have Dataminer 4.0 where we can derive algorithms on the basis of various patterns in our data . At the end of any work like classification or…
-
In OBIEE, is it possible to maintain Denominator regardless of the Filters applied?
Hi All, We have a requirement where Numerator of a Column has to be Filtered by the Prompt Values butnot the Denominator. Whenever a Product is selected in the Prompt from the List of Products , then the Column Logic will be ---> Selected Product /Sum(All the Products) As of now, whenever i select a Product from the…
-
Can we write select statements in rpd
I have a requirement to get a count of flag in my fact table. I can get a correct count in the database using this code ( SELECT distinct A_FLAG, Number FROM B_FACT where Number =12345 ) however when I try in this in the analysis (count(distinct "Fact - A_FLAG" by "Number ") ) and filter by Number =12345 I am not getting…
-
OBIEE 12c: fmap location
Hi, I have to display one logo(when I export the dashboard in ppt/pdf, the first page would be fully covered with this logo) on the dashboard which is having size 900 kb. I couldn't find the fmap location in OBIEE 12c to upload my image. Could you please tell me the fmap path and configuration process. TIA, Madhav
-
Restrict same credentials for XMLPServer and Analytics
Hi We have installed OBIEE 12c, we have developed some reports in BIP (which is part of OBIEE --- not a standalone) and some dashboards in Analytics, due to some security, we want to limit one user for BIP reports only that user should not be able to login on Analytics. Is it possible?
-
WriteBack Error in OBIEE12c
Hi All, Yesterday I have migrated the newly created dashboard from Dev to Prod instance. After successful migration of RPD,Reports and Dashboards writeback functionality is not workling.(abovve mentioned XML moved to Prod but its giving error) Please find the below error for reference. Write Back ErrorThe system is unable…
-
WebCat replication in OBIEE 12c
Hi gurus! We have two OBIEE 12c servers in different sites - one in US and another one in UK. The users usually connect to the US site, but UK site must be up to date in case of downtime in US. We are looking for a way to seamlessly and automatically synchronize the web catalogs. For example, once a catalog in US is…
-
Unable to display Image on BIP report saved as blob in database
Hi Previously We were working in oracle 11g forms and reports, we were displaying Company's Logo (blob image in database) and there was report in report builder to show as image. Now we are planning to convert our reports into OBIEE 12c (BIP --- XDO), When try to show blob data on BIP report then instead of Image raw data…
-
Fonts Installation on OBIEE 12c
Hi We want to install some fonts on OBIEE 12c which does not exists by default, Anyone please help from where we can download required fonts and how to install regards
-
How to compare today's date with last month's date in OBIEE
Hi I have a requirement to compare one date with the last month's date (needs to add field in RPD) Example 01-Jan-2019 compare with 01-DEC-2018 22-Jan-2019 compare with 22-Dec-2018 I Can't write 30 days ago due to change in number of days in multiple months anyone please suggest the solution regards
-
OBIEE XLSX Export Missing Spaces b/w the Data
When I am exporting OBIEE report to XLSX format, the download is missing spaces from the data. eg. actual data is 'ABC 123', exported output comes like 'ABC 123'. Instead of 5 spaces, excel shows me only one space. However when exporting to .csv format, i get data intact with 5 spaces.
-
Export OTM Transportation Intelligence Analysis/Reports
Hello, Can we automatize the export (Excel, CSV..) of a report or analysis, already created within OTM Transportation Intelligence, via a batch process or something like that? Oracle Business Intelligence Product Version 12.2.1.3.0. Regards,
-
Exporting data as image with BI Publisher - OS dependent
Content Hi, We are using BI Publisher to export data into different formats such as html, jpg etc. We could see that while exporting the data in image format or if the data contains an image, then the output from BI Publisher is different in windows and linux. Anyone has any idea whether BI Publisher is OS dependant? Is…
-
How to send the message to phone in BI Schedule?
Hi Experts, I want to monitor the reports for running successfully or unsuccessfully by Phone in BI Schedule,and I only need get the message on success or failure, but I do not know how to use or configure this functionality .Is there any material for introducing it step by step? Thanks for your kindly help.
-
Recommendation about Subject Area in RPD
Hi I am working in hospital where there are 4 major domains Financial Diagnostic Treatment Administration every domain needs dashboards, KPIs and Scorecard Please share your knowlede either we should create subject area of every little requirement or we should create subject area of major domains as written above. Is there…
-
Unable to install OBIEE 11g on Windows 10
Hello Team, I am Installing OBIEE 11.1.1.7 version on windows 10 but I am getting following error while installing : error: Checking operating system certification : failed and not getting any error description in below window Could you tell me can we install OBIEE 11.1.1.7 on windows 10? do I need to install any other…
-
NULL values in every dashboard prompt in OBIEE 12c
Hi I have designed many dashboard prompts in OBIEE 12c, every prompt has a NULL value, please guide how I can remove this such as NULL 2019.00 2018.00 2017.00 also how I can remove .00 or add format in year data regards Rai Qaiser Hussain
-
OBI 12c Prompt (Fetch Values) does not Limit : Failed to load ODBC Error
Hi Team, I am using OBI 12c with Hadoop Imapala Database connection. I am using a 'String' data type column which is the first dashboard prompt.The dashboard gets autofilled with Max(Column Value),but when we try to select a prompt list value ,it shows "Failed to Load ODBC Error". I have used "SQL results" for Prompt…
-
questions on weblogic
I was asked this interview questions, but I am not sure if I answered well. So I will like to hear from others 1) After creating users and group in web logic, how do you test it or what is the next step to test what you have created . 2) what is a sub query
-
Can you advise with it?
Hi all I have 3 datamart tables: Client(every month i gather all data about client) Account (every month i gather all data about account) Payments (every day i gather data about payment) Calendar(Montly) -cause business have to analyze monthly I have this schema Client , Account - are ok . All formula work and attribute…
-
OBIEE Cluster environment node manager2 is not starting
<Oct 12, 2018, 2:07:12,908 PM GMT+05:30> <Error> <oracle.wsm.resources.policymanager> <WSM-02353> <Unable to get the Action Executor due to "javax.security.auth.login.FailedLoginException: [Security:090938]Authentication failure: The specified user failed to log in. javax.security.auth.login.LoginException:…
-
Obiee 11g audit IP Address of user in BI presentation services
Hi everyone, We are using OBIEE11g as a BI tool. For monitoring reason we need to keep tracking of users who access reports and dashboards. It is implemented Usage tracking system with S_NQ_ACCT and S_NQ_DB_ACCT tables, and it works fine. We are required to keep tracking also the Host IP of the user that is accessing the…
-
OBIEE 11g: Function to compare 2 data values in an ad hoc report formula
Hi, I have to develop an Ad Hoc report on OBIEE 11g but I miss a SQL formula to get a data from the DB. Here is what I have: * A field named “Tool ID#” to identify different tools. * A field named “Event” with different events (‘Bas’, ‘Proc’, ‘Dev’, ‘Qual’, ‘Aud’) when the tools were used. Note that there is no…
-
OBIEE Greek Letters Problem
Hi Everyone, I am using OBIEE 11g, once I prepared the analysis, in some fields there are greek letters such as 'Ý' and these types of characters show up in result mostly as '?' I searched and couldnt find a guide or answer for this issue. I would like to ask if there is a way of showing these letters as it is? Beside this…
