-
substr method not working in BIP RTF template reports.
Hi Everyone, I am trying get count of a column which is starting with a value 'zero'. Code is : For loop : <?xdoxslt:if substr(COLUMN4,1,1)=0 then xdoxslt:set_variable($_XDOCTX, 'count', (xdoxslt:get_variable($_XDOCTX, 'count')+1),0)?> End loop. <?xdoxslt:get_variable($_XDOCTX, 'count')?> Getting count is zero and the loop…
-
Global Payroll balancing to GL
What reports do you use to balance Payroll and GL?
-
Issue while scheduling BI Publisher report - 12.2.1.3.0
Hi all, I have a BI Publisher report, which I want to burst and FTP the output. The FTP is working fine. When the report is run standalone it gets executed and gives output, but when it is being scheduled through BI Publisher scheduler, getting the below error. Can someone who has faced/not faced the same issue provide the…
-
How to make change OBIEE RPD in online mode
When trying to open OBIEE RPD in online mode, I'm getting error window, RPD will open in Read-only mode. This means I can not make any changes. There are few option, which is enable when we open RPD in online mode. So, I need RPD open in online mode. I tried all solution mentioned below links, but I'm still having same…
-
OBIA Upgrade from 11.1.1.10.2 to 11.1.1.10.3
Can someone guide me in sequence steps for the OBIA upgrade (11.1.1.10.1 to 11.1.1.10.3). I was expecting a document or link which contains sequence steps end to end (Upgrade process). Current Server Software Version Details( OBIA). OBIA : 11.1.1.10.1 OBIEE : 11.X ODI: 11.X Awaiting your prompt response.
-
Data Model Parameters in BI EE (11.1.1.9)
Hi, New here. I'm trying to configure a Data Model to use a Parameter. I want a user to be able to select an Order By condition. The SQL below works fine. select "ALL_TABLES"."TABLE_NAME" as "TABLE_NAME", "ALL_TABLES"."TABLESPACE_NAME" as "TABLESPACE_NAME", CAST("ALL_TABLES"."NUM_ROWS" AS INT) as "NUM_ROWS", from…
-
What enterprise edition software includes bi apps?
Seeking to discover which oracle software packages include bi apps. And whether or not bi apps includes odi tool.
-
Fillable forms using Oracle BI Publisher 12.2.1.3
Hi, Can we generate fillable forms using Oracle BI Publisher 12.2.1.3? I looked the Documentation on PDF template. https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-1437167F-E85A-4E3E-AC93-19E04FE0CB5A.htm#BIPRD3282 This page gives details about how to create PDF template. But it doesn't talk about how to make fields…
-
Moved: Oracle Data Miner functionality/ Machine Learning/ Data Mining
This discussion has been moved.
-
BI Presentation Catalog Tables
Hi, I was looking as to where does the actual Catalog data gets stored (OBIEE 12c - 12.2.1.3.0)? Is it in the database on the app server? Whats the schema name or some table names that houses the presentation catalog data such as: Subjects Areas Catalog Folders Analysis path Date created Date modified I know that the the…
-
OAS installation error : unable to start all servers
-
Moved: Hello Guys, I'm facing an issue while configuring Oracle Business Intel…
This discussion has been moved.
-
OBIEE 12.2 format column headers to left and table data to right
Is there a way to format the table columns to be to the left of the table data without using a pivot table. I supposed one could hide the header and use text to left but then I would need to do it for each column COLUMN Heading TABLE data COLUMN heading table data
-
OAC Gen2 - esscs CLI Issues
Hi, we have an issue with the esscs CLI. we have used this into Data load process automation. Jobs are running round the clock. We have created a passkey using the setpassword command and using it for login. It is working as expected. after few batch runs, (some times in a week, some times in 15 days, some times less than…
-
BI Publisher Number of columns
We are integrating a table with many columns into our rtf template. Is there a way to hide columns in the created document if they are not filled with data?
-
Moved: [nQSError: 14025] No fact table exists at the requested level of detail
This discussion has been moved.
-
<?qrcode:?> 2D Barcode Query
RE: https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E.htm#GUID-E0D697B1-0B13-46A3-8578-1FE933F1A86D Is possible to concat multiple elements for <DATA> parameter?
-
Cannot create BI Content after extended bi Domain with BIP Template
Hey guys! Recently I came across an OBIEE 12.2.1.4.0 installation without BIP deployed, then I got the request to enable it, therefore I run the .config.sh and was able to extend the existing domain using the BIP template, all services are running, I am able to access to BIP through the web, navigate through the catalog…
-
how to reset the weblogic admin built-in account passwd?
Hello everyone, does any one know how to reset the weblogic admin built-in account passwd when no one knows the existing passwd? that is built-in account to startup weblogic/application. Thanks a lot!
-
Graphs (chart) usage in BIP
I am working on a requirement where i have to build a bar chart. I need some help to build this in BIP: This is a stacked bar graph where the products are identified by colors. There are 2 products in this (blue and green) and the requirement is for any number of products (variable), and the products should be to…
-
I cannot find migration-tools.cmd after a new installation of BI Publisher 12.2.1.3.0
I cannot find migration-tools.cmd after a new installation of BI Publisher 12.2.1.3.0 I'm upgrading and migrating a JD Edwards EnterpriseOne One View Reporting instance from 11g to 12c and I need to generate the migration .jar from my 11g instance for import into my new instance. I have a file named migration-tool.cmd, but…
-
oci_connect(): Error while trying to retrieve text for error ORA-12154
Hi All I am trying to make a oracle connection and am getting the below error. Am using easy connect string oci_connect(): Error while trying to retrieve text for error ORA-12154 and tried to change the connection as mentioned in the forum as '//host:port/service_name' then the error code changes and give : oci_connect():…
-
Is there a point to incremental upgrades to get to BIAPPS 12c?
The Oracle documentation (see below) says there are two methods of upgrading to OBIA 11.1.1.10.3 (aka OBIA 12c) given that the recommended route is to recreate all ODI customisations anyway, is Method 2 really just saying do a fresh install and then recreate all your ODI mappings and migrate your OBIEE content from 11g to…
-
Embed BI dashboards from Classic Home ?
Hi All, Do we have some information on how to embed cloud BI dashboards/reports (from OAC>Classic Home) into another web app without prompting the credentials ? The only thing I found is this link: https://docs.oracle.com/en/cloud/paas/bi-cloud/bilug/embed-your-content-other-applications.html but as far as I understood,…
-
Apply a like filter
Dear all, is it possible to apply two like filters with AND logic clause in an analytics project ? Many thanks in advance
-
Get selected values from Prompt filter
Hi, I'm trying to get selected values from a multyselection prompt object in order to filter rows containing 4 substrings in a specific column. I could do that with an evaluate function but i need to know the values selected by user. Any suggestion ?
-
How to Create and authorize user to view report
Hi I m new to oracle bi publisher. how to create and authorize a new user to view oracle bi reports. any suggestion? Thanks
-
OBIEE cache procedure
Hello Can anyone advise on how to handle presentation layer cache. We are removing cache 2 times a week. But we still see issues like this: Once in few months we see LOV values are not getting shown when users access dashboard reports/analysis. Then DBAs clear cache and LOV values start showing up. What we are supposed to…
-
Informatica PowerCenter 10
Hi, is there a way to download Informatica Power Center 10.x ? In the //edelivery.oracle.com/ I find only the Version 11.1.1.7.0. Best regards, Nils
-
OAS Installation and Experiences
Hello, I am wondering if anyone can share experiences regarding OAS Installation. What type of server - (windows/Linux) you have installed the OAS application, how did the installation go, and if everything works properly after installation. We are currently on OBIEE 12.2.1.4.0, and we are not ready for the cloud solution,…
