-
Bi Publisher 12.2.1.2.0 chart types are greyed out therefore I'm unable to create chart
Summary Bi Publisher 12.2.1.2.0 chart types are greyed out therefore I'm unable to create chart Content After new install of Bi Publisher 12.2.1.2.0 chart types are greyed out therefore I'm unable to create report with chart.
-
Fusion OTBI report
Summary Fusion OTBI report Content Hello All, I have been working on fusion OTBI reports I have a question on seeded reports. In seeded report data model there is a XML file from where output is comming, where it has been located in application. if I want to see the query and need to include few columns into that. How can…
-
How a user can change his own Password in OBIEE 11G Analytics?
Hi Experts, I had given a requirement from client, that i had to create a user and his password in weblogic console but when user login in BI Analytics for the first time he can reset or change his password.
-
OBIEE 10.1.3 agents only delivering in dashboard not in email when selected recepients from conditio
Hello All, We have set up ibot in obiee 10g and we are unable to deliver it to email. The job manager shows completed status for the ibot (Exit code 1). What could be the issue. Any help will be highly appreciated. When i configured the email for the administrator user it is delivering the email. When i select any other…
-
XML Publisher desktop installer on Mac book.
Summary XML Publisher desktop installer on Mac book. Content Dear All Please suggests a link/steps to download XML publisher installation file for mac book. Thanks Srini
-
OBIEE 12c Google Maps - First steps?
I was recently asked to take on investigating how to get maps working in OBIEE. I did some light research and from what I gather I need to familiarize myself with Map Viewer (which is a part of the OBIEE installation) as well as need to get spatial data in a database in order to get maps running. Finally I can choose to…
-
OBIEE Peformance Tiles not working with Essbase
Hi all, We are having an issue with performance tiles not showing the figures. We have financial analytics and performance tiles work on these reports that use a relational DB, but they don't when using Essbase as a source. Table and pivot are showing the correct results but not the performance tile (which only shows the…
-
Aggregate distinct OBIEE 11g
HI guys. I have these modeling scenario: Table FB_PostsTable FB_CommentsID_POST ID_POSTDS_POST ID_COMMENTQT_LIKES_POST DS_COMMENTID_BRANDQT_LIKES_COMMENTID_BRAND Where POST to COMMENTS has a 1:N relationship. So let's imagine the scenario below: My FB_POSTS has the measure QT_LIKES already aggregated at the source. I have…
-
Converting Column values into Rows - RTF Template
Summary Converting Column values into Rows - RTF Template Content Dear Friends, I have a requirement in RTF Template to convert the column values into rows based on an Account_Number. For example, Account_Number 001 has Year values as 2011, 2012, 2013, 2014, 2015, 2016. As using the source as SQL Query, it comes to RTF…
-
Update Oracle BI Publisher Layout
Summary Update Oracle BI Publisher Layout Content Hi everyone, i have to change the layout of a report in BI Publisher deployed in Oracle Answers. I would like simply to delete a logo from the layout. In Analytics i click on Edit link about the report to modify the layout. Then i click on "Modify Layout" in the right…
-
Passing a date parameter to a date parameter
Summary Passing a date parameter to a date parameter Content How do I pass a data type of date to a data type of date parameter in another report? I have a hyperlink that passes a parameter to another report in the format "{//date_parameter}" in the word template ... data type = date The receiving program accepts the…
-
How do I pass a List-of-values to a List-of-values
Summary How do I pass a List-of-values to a List-of-values Content How do I pass a selected value of a list-of-values to a list-of-values parameter in another report? I have a hyperlink that passes a parameter to another report in the format "{//list_parameter}" in the word template ... which is a list-of-values. The…
-
Display company information on the side, dynamically, only on odd pages
Summary Display company information on the side, dynamically, only on odd pages Content Hi all, I've been trying for a few days now to find a solution for the following issue and I failed... My customer asked me to display the order company address on the right side of every odd pages of the invoice, vertically (reading…
-
The server can not be used due to a configuration error, please contact the administrator. If you ar
java.lang.RuntimeException: Failed to retrieve data from Presentation ServerCould not connect to OBI Presentation Service. I have installed latest OBIEE 12c on windows server 2012. Initially everything is fine but in publisher I have enabled the superuser and security model BI publisher security model. Then and there…
-
How to know Oracle BI Mobile Public Demo connection details?
Hi, I have installed Oracle BI Mobile on my Android smartphone. Could you please let me know the following? 1. How I can check the Public Demo connection details. 2. Apparently, it's connecting to a 11.1.1.9.0 Demo environment. How I can connect to a 12c Public Demo environment. Thank you. Regards, Manoj.
-
Hide the column as per prompt selection
Hi, Is it possible to hide the column from an analysis based on the prompt selection i.e. when "None" is selected in the prompt the column doesn't appear in the analysis. I could achieve it using column selector but i need to achieve it using prompt only as column selector doesn't appear whenever there is no results in the…
-
OPLA cycletime - working days vs calendar days
I am looking for a way to use the cycletime metrics in OPLA but I need it to just be working days and not calendar days. Is there a way this can be achieved?
-
12c - upload/download rpd
Hi we are in the phase of 11g to 12c and suddenly i have noticed bi server (instance) is not up and running. so is there any suggestions to bring it back. i tried to restart and have checked the logs. no much information about the issue. i just says check the log but no much information in logs. can someone please share…
-
Formatting of a report is different in OBIEE 11.1.1.7 and OBIEE 11.1.1.9
Hi , I recently upgraded to OBIEE 11.1.1.9 and found that same report is giving a different output in terms of formatting. I am copy pasting the same xml in both the version. Font size of OBIEE 11.1.1.9 is small compare to OBIEE 11.1.17 Is that possible? Thank you .
-
Font size not changing
Hi , Column Header font size is not changing in reports in OBIEE 11.1.1.9 . Steps performed - * Created a report with one column * Changed column properties , made it to bold , color as green and font size 20 Column Header value changed to bold and color to green but font size remained same. Can somebody help?
-
12c Upload RPD - Restart which services?
Hi All, Long time no post in this section! On a cluster environment we are occasionally not seeing RPD updates available for some sessions. Symptom suggests that one of the BI Server Nodes has not got or applied the new RPD Definition. What is the general consensus on here for Release process , are most people restarting…
-
How to increase inactive session timeout BI Publisher 12
Summary How to increase inactive session timeout BI Publisher 12 Content Hi, I am trying to figure out how to increase inactive session timeout for BI Publisher 12 but could not find any solution. Any suggestion? Regards
-
Mass creation of BI Publisher users
Summary Mass creation of BI Publisher users Content Hi, Is there an api or program available to create mass no.of users? We have a requirement to create around 500 BI Publisher users with the same role. Could someone please suggest what is the easiest way to do this? Thanks
-
SVG support
Summary SVG support Content Hi all, I am trying to embed an SVG into the generated document. With the following code, I am able to export the svg in PDF <fo:instream-foreign-object content-type="image/svg+xml" width="12pt" height="12pt"> <svg width="12.0pt" height="12.6pt"> <g xdofo:shape-id="3"> <ellipse rx="6.0" ry="6.0"…
-
the new version announcement still relates to October's release, will there be info posted on the De
Summary the new version announcement still relates to October's release, will there be info posted on the Dec release new features etc? Content for previous releases the information and discussion about the new release has been very helpful. the main new release announcement banner still refers to the previous version.
-
What system variables are available to pass in pre process function the data source level
Summary What system variables are available to pass in pre process function the data source level Content I am trying to pass the :xdo_user_roles variable in a pre process function at the data source level. Is the :xdo_user_roles variable not available at this level? What variables are available? I can pass the…
-
I have installed the DVD,but it can't be running
Summary I have installed the DVD,but it can't be running Content
-
Support for Stacked Combination chart
Summary Support for Stacked Combination chart Content Hi, My requirement is to create a stacked Line Bar Chart in which the bar is stacked. I was able to create a Line Bar chart with multiple bars using "COMBINATION_VERT_ABS" . Could you please let me know if there is anything else that I should do for a combination chart…
-
How to improve the performance in BIP11.1.1.7.141014 with two the two Data Model sets with two diffe
Summary How to improve the performance in BIP11.1.1.7.141014 with two the two Data Model sets with two different databases one AS400(IBM-DB2) and second one Oracle DB 12c. Content Hi All, Thanks in Advance.. I am creating a RTF template In BIP 11.1.1.7.141014 by using the two Data Model sets with two different databases…
-
BI Publisher Cache Issue?
Summary BI Publisher Cache Issue? Content Hi, I have experienced when uploading a new template to a BI Publisher Report, the new template doesn't show when I run the report. According to this document ID 1946497, this is due to a catch issue. I followed the steps documented in here:…
