-
Show counted records
Hi, I have column in which i count some records. Is there a possibility that when I click on a number that it shows me records. I think i should make some analysis in which paramateres will be passed from master analysis, but I dont know how. I am using OBIEE 12c Best regards, Matija
-
Hide/show section based on prompt value
Hi, I am using OBIEE 12c and I would like to know how to show or hide sections on dashboard based on prompt value. I made one variable prompt with two values, and when i select first option i want to show section2 only, and when i select second option I want to show third section. Best regards, Matija
-
Cannot create Projects in Data Visualization Cloud service
Summary Cannot create Projects in Data Visualization Cloud service Content Hi, I am able to login to my Data Visualization service and add Data Sets, but I cannot find the "Create Project" link. Even if I click on a Data set and see the "Visualize" tab - all I see is the "Drop Visualizations or Data elements Here" gray…
-
Passing Selected Parameters from Graph to Pivot/Table Views
Dear GURUS, I have a requirement where I need to build a Dashboard with 2 Graphs and 4 Pivots depending on the Graphs. As per my understanding, it is not a simple case of navigation (maybe, Master-Detail linking, but am unable to figure out). Environment Details: OBIEE 12.2.1.3 (I am not using Oracle Visual Analyzer)…
-
Oracle DVD - Use as Filter - How to remove inline filter on each visuals ?
Summary Oracle DVD - Use as Filter - How to remove inline filter on each visuals ? Content Hi, When I use "Use as filter" for master visual, it applies for all dependent visuals in that canvas. That is absolutely fine. But, it creates a filter view and gets added on top of each visuals . I dont want that in display. If I…
-
what are steps of Reference Dashboard Content in External Portals or Applications?
Oracle BI Presentation Services Dashboard URL as I using a Session ID or Ticket, pass it as the NQUser parameter. In the parameter description, SB2 is the name of the request to execute. But It requires me to output user and password. Reference Dashboard Content in External Portals or Applications, What steps do I need?
-
OBIEE 12c BI Consumer Users are unable to subscribe to Agents
Hello, After upgrading to OBIEE 12c (12.2.1.2.0) we are facing an issue with the Agent Subscription where our standard users are unable to subscribe to the agents even though the "Publish Agent for subscription" checkbox is checked for the Agent. We even checked the default permission for the View Deliver Lite UX and it is…
-
Value missing in bar chart
Hi - We are seeing the one of the numbers in the bar chart is not displaying the value (e.g. the value for April, which is 90) . Any thoughts as to why this may be occurring? Seem like all the others are ok ... OBIEE 11.1.1.9.3 Regards, Charles
-
How to create prompts with values changing depending on another prompt values?
I have a requirement to have prompts that will change depending on what the user selects! For example I will have columb prompt Class (value: A B C) and prompt Increase Rate that willl be intered depending on Class. The user need to be able to assign a rate for each class Class A 1% Class B2% Class C 5%. Is there a way to…
-
Avoid sending email if report is blank
Summary Avoid sending email if report is blank Content Hi all, I have a report and scheduling to send to the recipients. If report does not have data, then i have to avoid sending email. How to do this? Regards, CK
-
Insert Timeline?
Summary Insert Timeline? Content Hi, Is it possible to add a dummy Timeline to Your project? I have an excel file with names and reported hours in various weeks. I would like to always show ALL names in a given period (regardless if there is any data for that name/week or not) e.g.: Name | Week # | Hrs Paul | 1 | 40 Mark |…
-
Supress null values in Pivot
Summary Supress null values in Pivot Content Hi, I have a data set with names and reported hours against each week. So in my rows I have the names, in columns I have weeks, and for values I have hours. The issues I'm trying to solve is that if a person didn't report in a given week range - his line disappears from the…
-
Invoice detail tax Lines 'Query'
Summary Invoice detail tax Lines 'Query' Content Hello All, I need please a query or the table that holds Invoice Detail Tax Lines (See snapshot) Thanks a lot. Brgds.
-
DV Version 12.2.4.1.1- Data Flows
Summary DV Version 12.2.4.1.1- Data Flows Content Hi Everyone, I created a Data flows to remove a column (Concatenate) . After that I created a new project and all the measures have become alpha. Data Source Excel File After data flows Could you please tell me how can i solve this problem? Thanks
-
When will macOS High Sierra be supported for DVD?
Summary When will macOS High Sierra be supported for DVD? Content Developer versions have been available since September. If Oracle licenses and supports a product, especially on personal devices, they need to keep up to date.
-
How to calculate Utilization?
Summary How to calculate Utilization? Content Hi, I'm trying to create a kind of utilization report. Currently I have a data set which includes hours reported each day, e.g. Resource | Hrs | Week Ending john.doe | 2 | 27/05/2017 john.doe | 4 | 27/05/2017 john.doe | 2 | 27/05/2017 jane.doe | 8 | 27/05/2017 jane.doe | 10 |…
-
Does not repository variables and subquerys go together?
Hi, I have a repository variable that is "YESTERDAY" (format yyyy-mm-dd). When I try to apply this to the analysis that I wrote myself in sql I get below error. The field "invoice date" that I'm trying to filter on is from a subquery in the code, so might that be why I get this error? State: HY000. Code: 23007. [nQSError:…
-
Calling report and passing paramters across two different OBIEE Servers
Hi, Is there any way we can call detailed report present in second OBIEE server from first obiee server which currently has summarized data. For example we have one server which have summarized data and are required to drill down to detailed report which is available in different obiee environment. In this process I would…
-
Build XML to PDF Converter with BI Publisher
Summary Build XML to PDF Converter with BI Publisher Content Hello together, I was given a task that I shall solve with BI publisher. As I am an absolute beginner with that tool, I need your support. The task is to build some sort of XML to PDF Converter. As a test I was reading in an example XML file and I used the Layout…
-
How can i recognize a break in an RTF Template?
Summary How can i recognize a break in an RTF Template? Content I'm working on an RTF Template in MS Word, which is to be used by BI Publisher (CS) to generate a Transcript. It splits the content on each page into two columns (using Word's column setting). One requirement is to print out a line of text at the end of the…
-
HOWTO - Email output with HTML layout in body and XLS file in attachment (OBIP 11.1.1.9)
Summary HOWTO - Email output with HTML layout in body and XLS file in attachment (OBIP 11.1.1.9) Content Hello, To extract processes running during the night, I've created a report in Oracle Business Intelligence Publisher (11.1.1.9) I want to send by email. I have a XLS extract, and I want to have it in attachment, AND to…
-
Unable to schedule BI Publisher reports after upgrade from 11.1.1.7 to 11.1.1.9
Summary Unable to schedule BI Publisher reports after upgrade from 11.1.1.7 to 11.1.1.9 Content Hi, after a BI Publisher upgrade from 11.1.1.7 to 11.1.1.9 the non administration users are unable to schedule reports, all the upgrade process was successful
-
XDOFX Division in RTF Template
Summary XDOFX Division in RTF Template Content Hello all, I have an RTF template as below. I want to calculate the average of how long it takes per service => total_time / volume2. I have the xdofx in the RTF template for Average as below, but when I run it there is nothing in the Average (see result below). Can someone…
-
Errors after installing patch p23703041_111170 on OBIEE 11.1.1.7.0
Red Hat Enterprise Linux Server release 6.7 (Santiago) OBIEE 11.1.1.7.0 DB Oracle 11.2.0.4 I installed patch p23703041_111170_Linux-x86-64.zip following by readme. Opatch lsinventory said that all patches installed succesfully. But after reboot of server I notice that http://my_host:9704/analytics and…
-
Restrict records at Pivot Report level
Hi All I got a pivot table where Revenue is summed up (i.e. totals) for each state. To keep it simple, the Pivot table shows for each employee Total revenue across states in US (East/Central) The challenge here is after making the Totals, i can't do TOP 10 Employee ILMAMNMITotal RevABC$100404020XYZ$90202040PQR$80104030 . .…
-
Unable to create report or data model (OTBI)
Hi all, In my project, there was a migration activity happened from R12 to R13 (oracle applications cloud). After migration, the services of BI were bounced (Raised ORACLE SR). We are not able to do any activity related to OTBI (BI Publisher part). OTBI Release version is R13. OBIEE version is 11.1.1.9 1. Unable to create…
-
Usage Tracking in OBIEE
Hi All, Can anyone tell me in usage tracking is it possible track the users who is running report using smart view. If yes can you tell me how. Thanks, Shashikant
-
Export to CSV - Maximum?
Summary Export to CSV - Maximum? Content I need to export more than 1 million rows to CSV from a BIP report. I see the default file size for export to CSV in BIP is set at 1 million. Can I export like say 3 million records in CSV? I am trying to strike a balance between client's requirement for huge dataset and the ability…
-
BI 12c : Install BI Mobile App Designer?
Summary BI 12c : Install BI Mobile App Designer? Content Hello, Can you tell me please how to install (or activate) BI Mobile App Designer on BI Publisher 12 C Version : Oracle BI Publisher 12.2.1.3.0 (build# 20170720.0424 on Thu Jul 20 04:29:04 CEST 2017) Regards Djam
-
Why Oracle Data Visualization Desktop 4.0 doesn't support touch of Windows 10?
Summary Why Oracle Data Visualization Desktop 4.0 doesn't support touch of Windows 10? Content Hi All, I find touch screen doesn't work with Oracle Data Visualization Desktop 4.0. I'm using Windows 10 with touch screen. And Oracle Data Visualization Desktop is the only application I have found not supporting touch in my…
