-
Discrete Accrual Account Analysis completed with warning
Summary Discrete Accrual Account Analysis completed with warning Content Hi Team, XXX Inventory and Discrete Accrual Account Analysis is custom xml report completed with warning. Not able to open output as we are getting OPP Issue Can anybody suggest to fix this solution Thanks Sampath
-
BIP report hangs if opened second time with XLSX output
Summary BIP report hangs if opened second time with XLSX output Content There was a similar scenario described: The report runs in BIP and results in a XLS file. The file opened is read-only and has a generic name (XDO.XLSX). The problem is, if we keep the file open and run the same or any other report with XLS output…
-
obiee .csv export issue
Hi All, I have data like 1-9 . 20-1 11-6 which should be same when i export to .csv from an analysis, but after exporting i see the data as 1-Jan,20-Jan, 11-Jun which should not be the case. Can any one help me out how to make sure the Analysis export to .csv should remain same as the results we see on obiee. Help is…
-
How to Grey out (Disable) selection of weekends and holidays in calendar prompt of OBIEE?
I have requirement to Grey out (Disable) selection of weekends and holidays in calendar prompt of OBIEE. Any Ideas?
-
OBIEE:coreapplication_obisch1 -- Time out while waiting for a managed process to restart
This is the status I am seeing after starting opmn process. ---------------------------------+--------------------+---------+--------- ias-component | process-type | pid | status ---------------------------------+--------------------+---------+--------- coreapplication_obiccs1 | OracleBIClusterCo~ | 47517 | Alive…
-
Level measures (including percent to total)
Summary Level measures (including percent to total) Content What is the syntax for level measures in DV? For example let's say I have some sales data by region, what is the syntax to get total sales across all regions, no matter what the filtering is. This could be used to create a percent to total by region measure :…
-
patch 22601212 for OBIEE 11.1.1.9.170117
Hi All, my customer upgraded to OBIEE 11.1.1.9 (because of some specific PSE developed on top of OBIEE 11.1.1.9.170117, they cannot apply at the moment a newer bundle patch). They are also facing the issue described in the bug 22822515- BLR BACK PORT OF BUG:22601212 ON TOP OF 11.1.1.9.0, for which a fix exists, but it…
-
Pivot Table single "Grand Total" for multiple measures
Hello, I have a Pivot Table with the layout shown in the screenshot I'm trying to add a "Grand Total" not for each measure but a single "Grand Total" (also shown the final output in the screenshot) Is there any way to implement that? Any help would be appreciated Thanks and Regards, Isaac
-
how to add action link in the BI Report that will open the actual record for me
Hi, I am trying to add a link in the report that would open the account record for me. I am trying to do that in the Oracle BI in Oracle Sales Cloud, but the solution Oracle Support provided to me is not working. They directed me to an FAQ where I have a path for the Action link, but it does not say where to enter the…
-
OBIEE Agent not resolving group members
Hi, We are trying to send dashboard page to users using OBIEE (12.2.1.3.0) agent based on their role. Our security is set up in following manner: * users are held in Active Direcotry (ActiveDirectoryProvider) * groups are held in database (BISQLProvider) When we log in WebLogic Server Administration Console, under Users…
-
Repeat Column Values
Summary Repeat Column Values Content Hi, I am using BI Publisher version 11.1.7.1.9. I am working on a template in report layout and grouping the totals by product. I find that the product values are being supressed in the report, I would like to display/repeat the product values in the column Is it possible to achieve…
-
Account Default Search
Summary Account Default Search Content Hi Team, On Opportunities page, while searching for an Account, the default record set is "Records where I am on the team or territory". In order for this record set to fetch the results, what needs to be done on Account records? We want to understand on the following- 1)On…
-
OBIEE 11g and ODI 11g integration
Dear Experts, I am trying to integrate OBIEE 11g and ODI 11g by following the below url but not able to. http://www.ateam-oracle.com/integrating-odi-with-obiee-how-to-invoke-odi-scenarios-load-plans-from-obiee/ I have deployed ODI as java web in epm environment and trying to use the WSDL in OBIEE configuration but got…
-
Custom Data format for numeric currency value
Hi , I have a data in one of the reports in OBIEE as below £1200.00 -£3209494.00 £0 £19999.00 -£199.00 Currently I have a set the Data Format as currency and its displaying as above. My requirement is I want to display the negative numbers in RED and '£' should appear outside Bracket I am trying something from the one of…
-
Trying to develop report that prints a pie chart using BI-Publisher and using Peoplesoft Query or Co
Summary Trying to develop report that prints a pie chart using BI-Publisher and using Peoplesoft Query or Connected Query Content I am trying to develop a report using MS Word and BI Publisher and upload this template into Peoplesoft. The report is going to have table of items listed on the report and I need select one of…
-
BI Publisher (JDEdwards) - Barcodes
Summary BI Publisher (JDEdwards) - Barcodes Content Hi, I designed in BI Publisher (MS Word) to print item number, quantity and location with BARCODES (Code 128). When I designed it in BI Publisher I can see the Barcodes in Preview. But when I print it and tried to scan it, my scanner can not read it. Scanner is not the…
-
Records having Blob data not shown in the BI report
Summary Records having Blob data not shown in the BI report Content Hi, we are using BI publisher 11.1.1 , however I am new to this area. I have connected to oracle database were there is a column with BLOB data type. All the records having null in that column are shown but records which have some blob data in this column…
-
Capability to limit user by number of reports
Hi all, My company has a product based on OBIEE, some of our customers want to buy only few reports . My question is: what is the best way to allow a customer to view only the reports he wants? some additional requirements : 1. need to be part of the installation process.( maybe using a csv file with the names of the…
-
OBIEE 12.2.1.3 Alternative Authentication Provider OBI-SEC-00018 OBI-SEC-00500
According to the description in the document Oracle® Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition https://docs.oracle.com/middleware/12213/biee/BIESC/BIESC.pdf Section Configuring a Database as the Authentication Provider i’ve configured the alternative authentication provider, but…
-
Unable to load dataset into DV version 12c 12.2.4.1.0
Summary Unable to load dataset into DV version 12c 12.2.4.1.0 Content After upgrading to 12.2.4.1.0 I am unable to load any excel data sets into DV. DV simply closes without any messages. It starts fine until I press select file for upload, then it basically closes without any messages at all. I have tried uninstall and…
-
installing advanced analytics failed
Summary installing advanced analytics failed Content I tried to install advanced analytics for my Oracle Data Visualization Desktop application on a windows10-Home machine, and received an error message saying "The system can't find the path specfied". However, when installing the same on the other windows10 Pro machine,…
-
How to create AND OR condition in obiee 11g filters.
Hi All, I have created dashboard prompt and Analysis with filters prompted. I have to use filter combination as below For Ex: AND Processed Date is Prompted OR Termination Date is Prompted AND Current Record Ind is equal to / is in Y Problem is, When I enter only Processed Date, condition is not applying on report. means…
-
How to hide null value in Pivot table for one column
In Pivot table there is a null value and requirement is don't want to see null values in Pivot Table. I can't filter it on Report level because it will filter the data.is there any way i can do it in The Column Level to hide the Null values. Example :- In service Column don't want to see null and corresponding values.
-
Sales Account Extension folder in Sales - CRM Pipeline is not opening for BI Answers Reports
Summary Sales Account Extension folder in Sales - CRM Pipeline is not opening for BI Answers Reports Content Hi All In Sales - CRM Pipeline under Customer we will have Sales Account Extension but when I am trying to expand the folder the arrow is blinking so much time and it is not opening up. Can any one help us here. Why…
-
Run BIP
Summary Run BIP Content Hello All, How can we run a BIP report without passing Through the Reports and Analytics pane. Can you please help. Thanks a lot
-
Stop filter being overwritten on drill action
Hi, I am drilling into a dashboard page and it is overwriting one of the filters on an analysis that I do not want changing. Is there a way to stop this. Thank you!!!
-
Grouping In OBIEE
Hello All, I have a requirement they want to see count of the columns.I am facing a issue to do it. Can anyone let me know how to do this requirement. Sample Data:- Status 2015Status 2016Status 2017Service PartSerial PartTBDService PartSerial PartTBDService PartSerial PartService PartService PartSerial PartSerial…
-
Connection to DB2 through OBIEE Admin Tool
We are trying to Import tables from Db2. When we try to import we see the below error. Oracle asked us to install Db2 Client and import tables through DB2 CLI (Unicode). But still we see this error. Please guide if anyone came across this issue.
-
Difference in date format between .xlsx and .csv file in obiee 12c
Hi Team, In obiee 12c we found a different issue while exporting the report into .xlsx format and .csv format. In .xlsx format date value is showing correct (17-may). But same report in .csv format it is showing (17-06-2018). which is wrong. It should show (17-06-2017). Please help me on this. Note: These column is direct…
-
DVD Jan 2018 update
Summary DVD Jan 2018 update Content Just saw Jan 2018 dvd update - is there a list on the new features and bug fixes for this release? Documentation is still pointing to Oct 2017 release.
