-
How to fix OBIEE Security vulnerability
According to the results of internal vulnerability scanning, OBIEE have security vulnerabilities, what we need to install the patch? SeverityPortSynopsisDescriptionSolutionRisk FactorCritical7001The remote Oracle WebLogic server is affected by a remote code execution vulnerability.The remote Oracle WebLogic server is…
-
Lookup column values from a OBIEE report
Hi, I need to populate Column Z( from another report and subject area) in my report which value would depend on the values of Column A in the Lookup Report. Can you advise on how to go about it.
-
How to include a LTS filter as part of an outer join (instead of the Where clause) in OBIEE RPD 11g
We have and outer join between two tables - let's say TableA and TableB - where TableB currently have a filter in the Content definition in the BMM of the RPD. This filter is negating the outer join, which then behaves as a normal inner join. A SQL statement from this join looks like this: SELECT * FROM TableA A LEFT OUTER…
-
OBIEE 11g installation on windows 10
Hi Friends, I have tried obiee 11g installation on window 10. its not allowing to install. Is OBIEE 11g compatible for windows 10?? Thanks, Pavan
-
OBIEE 11G Direct Database Request with DB Link
Hi all, Do you know if it is possible to use a Database Link in the Direct Database Request in OBIEE 11G ? Best regards, Ben
-
I have two small doubts about RCOUNT(1) and Convert Amount into words
Hi, This is R K. Related to ROWCOUNT: I have a small doubts about RCOUNT(1) when i use it i'm getting Serial Number which is fine until I use Grand Total when I use both its showing both total of RCOUNT(1) and my SUM(Amount) how can i disable the Total of RCOUNT(1) without disabling the Grand Total. Convert Amount into…
-
Horizontal scroll bar in PDF report
Summary Horizontal scroll bar in PDF report Content We are developing a report in excel, html, word and excel type. All based on same RTF template. We will have a huge number of columns in the report ant it can go till 1000 columns. I am using the BIP plugin for developing the RTF layout. The report comes fine in excel,…
-
OBIEE Hint when having aggregation(sum) in the report/dashboard
Hi , I have a scenario where iam pulling sum(colum1) and adding an evaluate function in the same analysis for OBIEE dashboard/report. EVALUATE('/*+LEADING(Table_object_name) parallel(Table_object_name,4) */ %1', 0 ) When this gets converted to SQL the hint moved to second or lower column and oracle doesnt recognise the…
-
Not Able to login to EM and Console with weblogic user.
Hi All, The default application Roles got deleted by mistake from EM. And after that I am not able to login to EM and Console with the only admin user weblogic. But I am able to login to analytics. is there any way to recover the Roles.? Thanks, Abinash
-
OBIEE Narrative View Export
Hello, I have a narrative view on my dashboard, when exported to excel it looses the format of report. Is there a way to avoid this and keep the same format when exported to excel? Thanks
-
Permissions report for catalog manager objects
Hi, We have OBIEE 11g and we're trying to find a way to list all objects (analyses, dashboards, prompts, etc) a user could have access to in Answers Shared folders or Catalog manager. We would also like to be able to list all privileges/permissions of all objects. Who has access to what? For example, if a user creates a…
-
W_MCAL_DAY_D is not populating new dates
Hi, We have OBIA 7664 implemented the table w_day_d is populated till 2020 but w_mcal_day_d is still 31 dec 2017. We noticed the SIL_TimeDimension_MCalPeriod task has a $$END_DATE specified in DAC as 20171231 we changed this parameter and ran the ETL as normal but it didnt populate the table. Could someone help and point…
-
Increasing default report size in answers
Is there a setting where I can increase (set) the default report size in answers. My users know how to set it for each report (in properties) but would prefer a default size setting ( I am talking about the overall report, not the column) Thanks
-
wrong display of date in the BIP report
Summary wrong display of date in the BIP report Content I need to display date in my report.I have given format as DD/MM/YYYY. '31-12-9999' is displayed as '31-12-1999'.Kindly help me to resolve this. Will i face some other issue in displaying date if i give this format.
-
Where are output files created during bursting?
Summary Where are output files created during bursting? Content We have a report being bursted and all the pdf files that were generated and then bursted were being stored in a specific directory /var/tmp and accumulating there. In the Bursting Control File, found that this is because the directory was hard-coded in the…
-
OBIEE 12c - Commentary in analyses
OBIEE 12c Is there some way to add commentary on dashboards or reports. The purpose would be to explain some metric/KPI on the dashboard or report. The commentary would persist after exiting the report dashboard.
-
Mashups in OBIEE 12c
Hi Is Data Mashups in obiee 12.2.1.2.0 come as default or should we configure any where? please share lights on this I got access to BICS trail from Oracle, where I can find Add Data Source button to add the excel as SA. Thanks MM
-
Is this possible to connect OBIEE RPD with other reporting environments
Hi Folks, Is there any possibilitity to integrate OBIEE RPD with other reporting tools like Jaspersoft,Spotfire tools. Reason is other tools are having more visualisation capabilities when compare to OBIEE. Awaiting for your valuable suggestions. Thanks you...
-
OBIEE Image path and Size limit
Hi Experts, I have 2 questions. 1. Is there anyway we can store the images in a different folder other than the below paths and refer using fmap in dashboards ../user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/s_blafp/images…
-
Authentication failed error while open....screen shots attached below...Guru's please help !!!
VERSION: successfully installed the version below on windows 10. ISSUE: I am trying to open rpd file in online mode. I remember the password for that correctly ( made a note during installation). How ever I am also being prompted for USER: Administrator the password. when I enter the same password as Repository password it…
-
Oracle BI Publisher 11g Trial Edition - error raised
Summary Oracle BI Publisher 11g Trial Edition - error raised Content Hello. I have downloaded and installed "Oracle BI Publisher 11g Trial Edition" that I will use associated at Oracle Database 11g. Under Administration, Data Source, JDBC Connection I have set the connection to the database, as in the following picture…
-
How to remove the unnecessary spaces in the output from BI Publisher Reports.
Summary How to remove the unnecessary spaces in the output from BI Publisher Reports. Content Hi All, I am creating a XML report using BI Publisher Add-In for Microsoft Office 32 bit on Windows 8.1 I have written some conditions before the actual contents of the BI Publisher Report. While displaying the output of the…
-
OBIEE12C Limit by Not working
In OBIEE 12c "limit by" option in dashboard prompt is not working in Internet Explorer 11. Any bug fixes/ solution for this?
-
OBIEE Login Page Not Opening
Hi All I installed standalone OBIEE on my machine for study purpose. It worked for first day. But next day after shutdown of laptop overnight and then startup on morning when I tried to open the OBIEE Sign on page I am getting error message in Chrome - The message says - "LPT-67 restricts the access to this page" Is there…
-
How to sort by a column not used in a graph
I am currently working on a turnover graph that displays the projected turnover and YTD turnover rates in a lines and the total terminations per month in bars. The "Month Only + Year" field I have brought it displays Jan-16, Feb-16 and so forth but when I sort them it shows them alphabetically. I have another field called…
-
How to export Visual Analyzer project
Hi All, I want to know is there any option to export Visual Analyzer project like we have export option for Dashboard. Any help would be appreciated. Thank you.
-
Configure Printer in Oracle Forms
Summary Configure Printer in Oracle Forms Content Hi All, I am using Oracle BI Publisher 11g. And I configured Printer Delivery option as like below. But when I run the report, it shows the below error Delivery failed. [INSTANCE_ID=lenovooo-PC.1460088690811] [OUTPUT_ID=1016] Document delivery failed…
-
How to backup or export OTBI and BI Publisher Templates?
Summary How to backup or export OTBI and BI Publisher Templates? Content Hi, Is there anyone know how to backup or export OTBI and BI Publisher Templates? Since currently our team are doing the reporting using OTBI and BI Publisher in a demo environment, we need to export the existing customized reporting templates for…
-
How to set cell format type=text when opening bi publisher created html page in EXCEL
Summary How to set cell format type=text when opening bi publisher created html page in EXCEL Content Hi, We use the Oracle BI Publisher 11.1.1.6.0( mainly the oracle.xdo.template.FOProcessor class) to change xsl-fo file to html page. And then save the html page to an excel file. We want to set the excel file with cell…
-
Error while creating Data Set with Oracle BI Analysis
Hi All, I have created the data set with Oracle BI analysis. But while viewing data its throwing me the error shown below.
