-
Bursting Error:Error while generating the Document..
Summary Bursting Error:Error while generating the Document.. Content Hi Guru's Need your help please production issue, we have a report which generates pdf output and send the pdf output via xml bursting to the user. .. Here pdf output completed normally and output is generated but bursting program error out with below…
-
Error Loading Data
Summary Error Loading Data Content I have multiple projects in DVD and any time I open one up I receive an error saying "Error Loading Data" and it lists the data elements that could not be loaded. These elements include CustomerName, Sales_3485, and SalesPerCustomer which either are in the data and I am positive or in the…
-
DVD Error - Error Loading Data corrupts file
Summary DVD Error - Error Loading Data corrupts file Content I have multiple projects in DVD and any time I open one up I receive an error saying "Error Loading Data" and it lists the data elements that could not be loaded. These elements include CustomerName, Sales_3485, and SalesPerCustomer which either are in the data…
-
Merged Cell in Column Header
Summary Merged Cell in Column Header Content Hi all, I want to create a Merged Cell Header as shown below . I know i can achieve the above requirement in RTF and Excel Template , is there a way to do this in Online template Builder . please help me .thanks .
-
convert-to-bookmark
Summary convert-to-bookmark Content Hello, I'm working with template builder for Word 10.1.3.4.1 and i use <?convert-to-bookmark?> to generate bookmarks on pdf output. It works fine on preview on my pc but on server i don't see any bookmarks. Any idea ? Thank you in advance. regards
-
Cambodian font displayed as boxes in the generated PDF
Summary Cambodian font displayed as boxes in the generated PDF Content Hi All, I am facing an issue in generating PDF in Cambodian language. All font is appearing as 'boxes' in PDF, although inside application Cambodian font is properly getting displayed. We are able to edit Cambodian language font in web application, but…
-
How to set URL in BIP 12c
Summary How to set URL in BIP 12c Content Hi I am using Oracle BI Publisher 12.2.1.2.0 (build:20160906.0632) . I have a link column to navigate to other reports. When I set the URL http://{/DATA_DS/HOST/BIPURL}/PLMforProcess_Reference/GSM/Reports/General/Audit Trail Event Model.xdo?, it is working in BIP 11g, but is not…
-
OBIEE 11g Performance Issue
Hi, We have a performance problem in obiee 11g. Yes, I know this is a very general definition of the problem but just try to start from one point to define it. The issue happens not all the time, but sometimes. When I see the Session Manager, I see list of queries in running mode waiting in queue. Since, these are in queue…
-
BISQLGroupProvider configuration issue in SAML SSO
Hi Team, We have configured SAML SSO for authentication , and BISQLGroupProvider for authorization from external table(where the user can update the group name in the landing page application(which is SSO integrated). Flow of the process: 1)The user logs into the landing page application(which is SAML SSO integrated in the…
-
Obiee 11g Hierarchy
Hello, I want to create a hierarchy from two dimension tables. Table 1 Customers, Table 2 Products. The hierarchy should have two levels 1.Customers.Customer_Name, 2.Products.Category. These two tables doesn't have a common key to join. Can we achieve this?? Thanks.
-
Export service instance remotely (12c)?
Is this possible yet? I remember reading something about we'd be able to use a web service to remotely export and import instance data, rather than having to connect to each machine and run the export.
-
problems installing R packages in sampleapp 607p
the current script fails on this statement due to missing dependencies Rscript --verbose -e 'install.packages("http://cran.r-project.org/src/contrib/Archive/arulesViz/arulesViz_0.1-8.tar.gz", repos=NULL, type="source")' Log installpackagecustom("http://cran.r-project.org/src/contrib/sROC_0.1-2.tar.gz",…
-
convert measure dimension to flat measures - obiee 12c
Hi I am importing Essbase cube in to obiee 12c and I wanted to convert measure dimension to flat measures. but I am unable to find it when doing it in 12c obiee admin tool. in 11g it was definitely possible. Does anybody have the same issue or is that a bug? please share some lights. Thanks MM
-
Obiee 12C Answers Access locking up
I upgraded our environment to obiee 12c last month and since then we have been running into this issue almost once a week where all the users that have access to Answers, loose their access. They don't have the 'Analysis and Interactive Reporting' option under the New drop down to create a new analysis anymore. Also they…
-
Parent Child Hierarchy Creation issue
Hi., Getting the below error while executing data population script created by wizard when creating parent child hierarchy in obiee 11.1.1.7.1 Error report - ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 41 06502. 00000 - "PL/SQL: numeric or value error%s" *Cause: An arithmetic, numeric, string, conversion,…
-
Customizations from 11.1.1.7 to 11.1.1.9
After Upgrade from 11.1.1.7 to 11.1.1.9, if we deploy the same analytics res of 11.1.1.7.140527 in 11.1.1.9.0 will it work ? Please note i am talking about skins and styles customization. Appreciate any inputs.
-
How to create User and Role in BIP 12c
Summary How to create User and Role in BIP 12c Content Hi When I using BI Publisher Trial Edition 11.1.1.7.1, I can create new User and Role in Security Center. But I cannot find buttons to create them in Oracle BI Publisher 12.2.1.2.0 (build:20160906.0632) . Would you please tell how to create new User and Role in BIP…
-
Is there a way to simultaniously edit 1 dashboard from 2 different computers?
Summary Is there a way to simultaniously edit 1 dashboard from 2 different computers? Content I love the visualization capabilities. I am wondering if there is a way that I can create and edit a dashboard within my DV desktop and have a coworker see this dashboard and simultaneously edit it. Anyone know if this capability…
-
Sum for subtoal returns ZERO
Summary Sum for subtoal returns ZERO Content Hi, I am using OBI P 11g Layout Editor to create data models and layouts. I have 2 subtotals and grand total in my report. all works good but first subtotal returns zero for the function SUM/Count. Example: Region Region AreaOutletOrdersRegion 1 Area 1Outlet 12Outlet 2 3Area 1…
-
BI Publisher Integrating with Oracle E-Business Suite
Summary BI Publisher Integrating with Oracle E-Business Suite Content I followed document https://docs.oracle.com/cd/E23943_01/bi.1111/e22255/integ_security.htm#BIPAD206 for integrating BI Publisher with E-Business Suite R12.1.3 Please explain session login information (overall end to end connection) . For example: 1. say…
-
Conditional formatting (col A) in BICS fails when the condition itself reference a different column
Summary Conditional formatting (col A) in BICS fails when the condition itself reference a different column (col B) Content I am trying to set a conditional format for column A that depends on column B. It appears that any reference to any other column in the condition results in a format failure. I can set the selected…
-
add custom calculated item in middle of rows in obiee 11g?
Hi here some report line descriptions with balance values. i want calculate the 10-11 . when i calaculated 10-11 using grop members, calaculted items then descriptions & balance values are repeating . see the following screen shots. here 10-11 calculated item. report line desriptions & balnces values are repeating. i dont…
-
Multiple Dashboard pages are not visible after upgrade to 12c
Hi All, We recently upgraded from 11g to 12c and observed that if a user has access to multiple pages within a dashboard, he is not able to see all the pages. Only 1st page is visible. However same user can open the other pages from Catalog. All the permissions are intact. Also tried to change the order of the dashboard…
-
Security of data using DVD
Summary Security of data using DVD Content Can you please advise how we can implement security in DVD? Is there a server version of DVD where we can control access to data and visualizations based on user roles? Is DVD a good replacement for Discoverer?
-
PDF attach to BI
Summary PDF attach to BI Content Hello Everyone Can I attach a existing document that is in PDF format to the BI output. I wanted to have the PDF printed after the last page of the output that is generated in BI. This is related to embedded BI within E1. Thank you Satish
-
Oracle cloud
Summary Oracle cloud Content Hey All,, i need a help , i am trying to build a report but i found some issues to find the tables that related to shared goals so if anyone has any idea to help me to find the tables for shared goals as the highlighted part in the attached picture . thank you ,,
-
Oracle cloud
Summary Oracle cloud Content Hey All,, i need a help , i am trying to build a report but i found some issues to find the tables that related to shared goals so if anyone has any idea to help me to find the tables for shared goals as the highlighted part in the attached picture . thank you ,,
-
Action Links with dynamic Project Number
Hi, I have some problem with my issue. I have data like: And now I want to drill EpicNumber to task on JIRA. I have link something like that: https://jira.XXX.com/browse/XELRMICTIG-587 How can I create a action link to the right end of the link (epic number) receive as value from epic number column? I try:…
-
obiee12c not running after odi12 installation
hi experts, first i insatllaed obiee12c(12.2.1) & running fine.Now again i installed odi 12c on same machine. odi 12c(12.2.1) running fine.now i try tostart the obiee 12c service,we got the below error. C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin>start.cmd BI_PRODUCT_HOME set as…
-
RTF template dinamic hyperlinks
Summary RTF template dinamic hyperlinks Content Good day! I create a RTF report in BI Publisher 11g in which to dynamically display hyperlinks to a different web sites. In the database links are stored in field "URL", type: varchar2(1000): like: www.site.com/a, www.site.com/b etc. When I create the RTF report hyperlink…
