-
How to add the dynamic page numbers to the RTF
Summary How to add the dynamic page numbers to the RTF Content I need to pass the run control page number to RTF and it needs to increment along with the pages. Any help is appreciated.
-
RTF Template 0.00% number format issue!
Summary RTF Template 0.00% number format issue! Content Hello, I have a number format as 0.00% in RTF template but the output to excel is that the number is multiplied by 100 automatically. Example: 0.75 is the actual number in xml but when exported to Excel the number is getting displayed as 75.00%. Output expected is :…
-
BI Publisher 12.2.1.2.0 scheduleService v2 -scheduleReport Issue
Summary BI Publisher 12.2.1.2.0 scheduleService v2 -scheduleReport Issue Content Hello everyone, I'm facing a problem when trying to schedule a Report to specific future date using V2/ScheduleService in BI Publisher release 12.2.1.2.0. I'm using soapUI 4.6.4 as the service consumer. The soapUI message and error message am…
-
Image generation in excel
Summary Image generation in excel Content Hi All, I am trying to generate an image inside an excel document. But I am not able to place the image within a row of the excel document. The image is getting placed on top of multiple rows as shown below. Expected result : Please find the xslfo table object below. ... <fo:table>…
-
AuditReportTemplates.jar on publisher 12
Summary AuditReportTemplates.jar on publisher 12 Content Hi, We are auditing the publisher data on out DB. Now we want to use the out-of-the-box reports to show data. We know they are located in AuditReportTemplates.jar but we are not able to use them as they are in a previous version. How can we have them in our…
-
BIP webservice maximum concurrent calls
Summary BIP webservice maximum concurrent calls Content Hi everyone, I am looking for the maximum amount of concurrent call that can be done to the runReport() WS for BI Publisher. Thanks Alessandro
-
BIPub : Problem : Display invoice amount total at the last of a page
Summary BIPub : Problem : Display invoice amount total at the last of a page Content Hello all, I am a newbie in BI Publisher, so i began to learn and apply the BI Publisher Oracle Documentation (12C). I have a problem with this code for displaying invoice amount total at the last of a page : <?start@last-page:body?> <?end…
-
Cleaner old analysis in OBIEE 11G
Hi Guys! I have intresting task. I needs automatically finding old analisys and move these analysis to trash folder. After several months delete these analysis. I tried resolved this task via catalog manager. I reported all analisys and loaded to database. Then I matched this report with usage tracking table. And loaded…
-
OBIEE 11G Agent Gives Error [nQSError: 75005]
Hi, when i am running agent,the following error message is seen, [nQSError: 75005] Failed to send AUTH command. No supported authentication mechanism found . I have deleted mail.server and Restarted the BI Services.After that also getting same error. Any other suggestions.
-
OBIEE SOAP Implementation - Minor Issue
Hi, I am writing a code in executeXMLQuery in SOAP to call Presentation Variable created in my OBIEE report. I need to pass more than one value under Variable. This is what the code looks like: <v6:variables> <v6:name>PRODUCT</v6:name> <v6:value>ABC</v6:value> </v6:variables> When I execute the code, I get details where…
-
S_NQ_ACCT
I'm trying to find out the usage statistics (past 6-12 months) for users from a specific campus (university data) How can I use the S_NQ_ACCT table? The Analysis Usage Report is broken unfortunately. Attaching screenshots of the S_NQ_ACCT table
-
Obiee 11g how to pass prompt parameters in soapUI xml
Hi to everyone, for the first time i have to solve a new request using soapUI. i was looking around different forums and i understood how to set a new SOAP project, connect my obiee server on it and i saw all the webservices available (first step). what i think i need are these 3 WS: - SAWSessionService->Logon -…
-
. [nQSError: 12010] Communication error connecting to remote end point: address = xxxxx.com; port =
Hi , I keep getting this error while trying to run the dash board or reports in OBIEE analytics State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 12010] Communication error connecting to remote end point: address =xxxxxx.com; port = 9703. (HY000) so I stopped…
-
OBIEE Usage Tracking - Physical Tables
Hi, I do an analysis in order to find frequently used reports and their physical tables and columns. I use usage tracking (S_NQ_ACCT) and find which reports are used and how many times, but I do not know which tables (physical) are used for those reports. In order to get tables list, I go catalog manager but this way is…
-
OBIEE Report of Permissions and application roles
Hi Everyone, Is there anyway that I can extract in an OBIEE report to see the permissions on the catalog folders? and also manage privileges details. I want to set this up for Admin activities. Could you please suggest a way around here to get this done. Thanks All
-
Styles & Skins: combination problem - 12.2.1.2.0
Hi Team, I followed https://docs.oracle.com/middleware/11119/biee/BIESG/answersconfigset.htm#BABEDDEC to create a customized look and feel for our OBIEE deployment. However, if I set a the default skin in instanceconfig.xml to mazda and I choose a style in a dashboard, it doesn't get applied. (It's like the custom skin…
-
unable to add connection
Summary unable to add connection Content Hello, I used to work with May 2016 version and everything was OK (Since 2 months did not used DVD) This morning, before to work, i upgraded my DVD to Version 12.2.2.1.1-20161222001521 (Dec. 2016) Since I am unable to connect to Oracle database. I just have : "Failed to save the…
-
Essbase DSN
Summary Essbase DSN Content I'm attempting to connect to an Essbase data source in DV for a Fusion Cloud instance and was wondering what the default port and URL look like. I watched the following video and attempted with my own hostname but I'm still getting "Failed to save connection".…
-
Advice for embedded queries
Summary Advice for embedded queries Content We currently use BIP 11.1.1.7, and have several large reports, some of which make use of embedded queries. When running a render job, our global ID predicate can sometimes include a larger set than we need for an individual burst, to improve performance we make use of a reference…
-
Barcode seems to print carriage return after it on all PDF documents generated from BI Publisher
Summary Barcode seems to print carriage return after it on all PDF documents generated from BI Publisher Content We are in the process of upgrading our Oracle Apps instance to 12C and in testing our BI Publisher reports - everything seems to work OK except for bar codes. The bar codes still print and are readable, but they…
-
DVD or DVCS - data sources as dims or facts
Summary DVD or DVCS - data sources as dims or facts Content Folks, Two questions: 1. In the documentation/tutorials for both DVCS and DVD (DV desktop) when adding an excel spreadsheet as a data source it often says: "A data source either extends a dimension by adding attributes or extends facts by adding measures and…
-
how to cpature presentation variables seperately
HI All, is there any way i can capture presentation variables separately(Ex: first ,second,third,...) when i select multiple values from prompts. This is required to do some calculations based on that... Thanks in advance..
-
User unable to login to Analytics
Hi, One of the user unable to login the analytics. OBIEE is integrated with corporate AD/LDAP hence the user information not available in WebLogic. The same user is able to logn to Test instance of OBIEE analytics url. Can you guide where to check for the cause ? OBIEE : 11.1.1.7 Error: The error occurred during…
-
Issue with substr
Hi , i am having some issue with substr. my requirement is, i want to extract separate values based on the users selected(single or multiple) prompt values to use it in calculations. below values i am getting from presentation variable and those values dynamically change. ABC,EFG,XYZ ABC,EFG ABC users can select either one…
-
Canonical Time set up for a fact. error OBIEE 12c
I have a fact table with more than one time column (say Date ordered and Date shipped) After reading about canonical time, I created one date dimension and two aliases to the fact table say (Fact Date Ordered and Fact Date shipped). Joined them to the date dimension in the physical layer and used them as the logical…
-
OBIEE 12c - BI Groups from External Table and LDAP Authentication
Hello Guys, I am currently using OBIEE 12.2.1.2.0 in RHEL 6.7 platform for my current client and facing couple of issues while setting up LDAP Authentication as well as fetching BIGroups from an external table. The issues are: 1. LDAP Active Directory has been set up successfully in myrealms. I can fetch the users from…
-
Dynamically Hide Null Value Column
Hi ., I have a requirement to Dynamically Hide the columns in the report where all the values are null. ex. in report we have 5 columns , if 2 column values are null then display only 3 columns in the report. Thanks Raj
-
Dashboard prompts issue
Please ignore this.
-
OBIEE 12c 12.2.1.2 - config.sh Configuration error on BI Startup - bi_server1 failed
I was having some issues with the final step of my OBIEE 12c 12.2.1.2 installation. I am at the point where I am running the /bi/bin/config.sh and initially was hitting errors on the Essbase step (resolved this in a previous thread, it had to do with the java /dev/random - /dev/urandom java issue) and was able to get my…
-
Finding an Analysis
Is there a way via Usage Tracking or something to find all they Analysis that uses some field. For instance, we want to either get rid of a data item or change the name of it and we want to know every Analysis that uses it. Is there a way to find that out?
