-
placing custom images in OBIEE 12c
Hi In OBIEE 12c, I upload jpg or image files to following paths ./user_projects/domains/bi/servers/obips1/tmp/earmanager/analytics/BxF3ko+PTqr1gaEGSOoliA/res/s_blafp/images ./user_projects/domains/bi/servers/bi_server1/tmp/_WL_user/analytics/za01ic/war/res/s_blafp/images…
-
InfoGraphic Sample Plugin Error
Summary InfoGraphic Sample Plugin Error Content Hi All, Trying to upload Plugin "InfoGraphic Sample Plugin" for the gender analysis but getting the following error : using latest DVD "Unable to determine the plugin id. Please check that the file you are attempting to upload contains a valid plugin and try again" Any help…
-
DV Desktop Screen Resolution
Summary DV Desktop Screen Resolution Content Is there something that can be done about the screen resolution of DV Desktop? No matter what I set my screen resolution to, DV does not resize the display. Certain screens (like Data Flows - Add Column) are almost unusable because the list of functions on the right only shows…
-
How many users can be created in the default weblogic LDAP for OBIEE 12c if we have oracle ula (lice
Hello , How many users can be created in the default weblogic LDAP for OBIEE 12c if we have oracle ula (licence). We have around 500 users in total and was trying to configure external table authentication. Unfortunately it is not working and failing in the database adapter configuration. Is it possible to create 500 users…
-
Problem with LDAP authentication (using AD authentication provider) [OBIEE 11.1.1.6.6]
Hello, We use windows AD authentication with OBIEE. At first glance it looks all working fine, but the problem begins, when I want pick up permissions for users to log on into OBIEE. Simply, when I remove user from BIAuthors (security group) with AD level, that user (for example user_n1) still can log on into OBIEE…
-
OBIEE 12c on Oracle Linux Best Practices?
Hi everyone, I am working with an existing OBIEE 12c (v12.2.1.1) customer on Windows and they want to upgrade to v12.2.1.3 or the upcoming v12.2.1.4 and migrate off of Windows to Oracle Linux. The customer wanted to know if there is a guidance/best practices document to help them configure the new Linux environment. I’ve…
-
OBIEE 12.2.1.3 - Unable to see "Contains HTML Markup" in edit text
Hi, I'm having issues seeing the option "Contains HTML Markup" when editing text in a Dashboard. I followed Doc#2311168.1, which instructs to add a <EnableSavingContentWithHTML>true</EnableSavingContentWithHTML> into the instanceconfig.xml file. Did that. I still can not see the "contains HTML markup" checkbox when I try…
-
Calculated Measure in AGO Function
Hi All, Oracle Business Intelligence 12.2.1.1.0 This is a question I received from 1 of the users. Users use AGO function at the report level on top of RPD measures and results are fine. Question is will AGO work for a calculated measure in answers. ? For example , user created a new measure in analysis say COUNT(DISTINCT…
-
Action Links missing export-analyze and other options after upgrading from 11g to 12c OBIEE
Action Links missing export-analyze and other options after upgrading from 11g to 12c OBIEE in 11g, I have action links that show a link to an Analysis (Report) using Navigate to BI Content when I click the link in 11g, The report has options for: Return - Anlayze - Refresh - Print - Export - Briefing Book - Create…
-
OBIEE cache
Hi all, I have implemented a custom skin/style on our horizontally scaled 12c environment which sits on a shared SAN. I am now using trial and error to fix the numerous css issues that the migration from 11 to 12 has given us. Unfortunately, I can't for the life of me work out how to get OBIEE to release the previous…
-
OBIEE 11g Sub Total Headings are not exporting to Excel 2007+
Hi When I export a report Sub-total(Account totals) heading is not coming to excel 2007+ (its working fine in 2003 excel). when we tried to export the report, "Account Totals" head is not coming to excel, only value it is showing not heading. See the below screenshot.
-
Using evaluate for regexp_replace in OBIEE
Hi OBIEE folks, My goal is to use evaluate to incorporate regexp_replace to clean up a name column in the report. Below is my expression. select regexp_replace('John, Doe','[[:punct:]]',' ') col_name dual; Can one you evangelists precisely suggest the evaluate syntax I can use ? I'd really appreciate the help, Also please…
-
Agent failed due to error
Hi Everyone, I am new to OBIEE. We have a system which was working fine recently one of our agent is failed when i try to run it manually i am getting following error. I am not able to understand it. Could you please let me know what need to be done. Strange thing is other 7-8 agents are running fine from same server.…
-
In OBIEE 12c hostname change steps.
In OBIEE 12c, we are going through a Hostname (computer name) change process. Does anyone know the steps where to change the hostname in OBIEE 12c files ? For example: http://ABC:9502/analytics/ is changing to http://XYZ:9502/analytics/ Thanks in advance Rohit
-
Cast a ServerVariable as Date in Dashboard
Hi, I am using a ServerVariable in my reports to present today's date. When I call it in a report it works fine and uses the data type that the database column has: ------> But I also want to call the variable in a section title in my dashboard. When I try to do this I get a different type, the one that oracle supports.…
-
Run BI PUBLISHER reports from command line
Summary Run BI PUBLISHER reports from command line Content Hi, I can use saschinvoke to run an OBIEE agent from the command, is there a similar option for BIP?
-
Sort based on criteria?
Summary Sort based on criteria? Content Hi All, I'd like to sort my results based on County in ASC order. However, there is 1 result with a county value of 'Various' that I would like to be dead last, after the County's that start with W,X,Y,Z. Is this possible in either BIP or the peopelsoft query itself? Order Example:…
-
Repeat line level table header.
Summary Repeat line level table header. Content Hi all, I have requirement, the line level table header with line level data should repeat in the second page, if the rows exceeds in the first page. The above table is line level table. 1. In the first page it should show 5 lines (Line level data - 5 lines) 2. Second page on…
-
Conditionnal formatting on row member in a data table
Summary Conditionnal formatting on row member in a data table Content Hello, I am building a BI Publisher report, I have inserted a data table within it and drag and drop the different columns of the data set I created in this table. I have accounts in rows, entity in columns and data. I want to add conditionnal formatting…
-
Inserting into database table in XML Data Template
Summary Inserting into database table in XML Data Template Content I am using XML Publisher reports for Oracle EBS concurrent program. Previously, when I used Oracle Reports rdf, for complex queries I created a custom database table and inserted data into this table (by breaking down the query in smaller blocks) in the…
-
Getting error while starting bi_server1 in obiee12c
Need help. While installation at the end bi_server1 start failed. Eve when trying manually getting this error: [serviceagilerimtsit@ausdlagildb03.us.dell.com /u03/app/oracle/product/obiee/fmw_obiee/user_projects/domains/bi/bitools/bin] $ ./start.sh -i bi_server1 Starting domain; Using domainHome:…
-
passing presentation variable through go url
Hi, I want to know if it is possible to pass presentation variable value using go url. below is my link and i want to pass user selected prompt values for customer to another page, basically '@val1' should carry user selected presentation variable's value of that column.…
-
error evaluate in drill down
Hello everybody, I got this error in a pivot table when i try doing drill down: Cannot function ship the following expression: EVALUATE There are a field that is calculated with evaluate function. Can anyone help me ? Thanks
-
merge and center in title
HI all, Having an issue with OBIEE analysis report. When export to Excel, title is in a wrap merge and center, which is preventing sorting from happening. Why/how is it set on merge/center, how can I turn it off. Does any one know of a workaround?
-
Error while merging RPD
Hi All, I am getting below error while merging RPD (2 way merge) and able to complete the merge. We are using 11g version Error Message: [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 84c] [46153] The configuration file (security.xml) was not found or is inaccessible. Thanks, Sulochana
-
XML Bursting Program Error
Summary XML Bursting Program Error Content Hi All, I'm trying to use XML Bursting. Ran the Request -XML Publisher Report Bursting Program Encountered below error : XDOBURSTREP module: XML Publisher Report Bursting Program +---------------------------------------------------------------------------+ Current system time is…
-
Cross-Visualization marks are not available for some views. Odbc driver returned an error..
Summary Cross-Visualization marks are not available for some views. Odbc driver returned an error.. Content Hi , This warning message keeps coming up everytime the page refreshes . I checked the logs to find nothing specific about this warning . What does this warning mean ? Anybody with the same warnings ? How do i fix i…
-
Unable to create OTBI data model after migration of oracle apps from R12 to R13
Summary Unable to create OTBI data model after migration of oracle apps from R12 to R13 Content Hi All, We have created custom OTBI reports in R12 version of oracle apps. There was a migration happened to R13. After that i checked few reports, when i run the report, it's throwing the following error. 2. When i try to…
-
How to Change Oracle LOGO with Company LOGO in Oracle BICS
Summary How to Change Oracle LOGO with Company LOGO in Oracle BICS Content How to Change Oracle LOGO with Company LOGO in Oracle BICS?
-
Presentation Services. Connection to MongoDB using Relational View Data Model
I'm building a pilot to connect to a MongoDB database with OBIEE 12.2.1.2.0. Using OBIEE's provided DataDirect Driver, I set up the ODBC System DNS connection in Windows for the Administrator Tool. Setting this up, I used the Schema Tool (you call it with a button in the DNS configuration) creating a Relational View,…
