-
Displaying a message on click of apply button
Hi , We have implemented writeback. As our updates are taking time.User are not able to figure out whether the apply button has worked or not and they hit the apply button multiple times Can Anyone help me understand(steps) how we can display a pop up box saying 'Updates is being applied please wait' on click of apply…
-
Integrating OBIEE 12C(12.2.1.4) with Essbase 11.2.1.4
We want to federate Oracle Essbase multidimensional sources(aggregated data from relational sources) with relational data sources(detailed facts). Is there any bad known issues between these versions besides issue with bi admin tool? OBIEE 12C and Essbase 11.1.2.4 integration issue We are moving from OBIEE 10g + Essbase…
-
How to practically understand the relationships among the Session Timeout parameters?
Hi, I have two questions related to the same topic - session timeout values: LogonExpireMinutes, ClientSessionExpireMinutes and ConnectionExpireMinutes. This question is 2/2. At work, I have OBI EE 10.1.3.4.2. While we want to increase the session timeout value(s) to four hours, I want to know which session timeout value…
-
filter inside an analysis
Hi, I'm totally new to OBIEE so sorry inadvance for the stupid questions that will follow. I created an analysis wthat provides a pivot table which indicates the sum the average time spent and the amount who exceed this average time spent. Now i want to show a second table with only the ones who exceed the time spent (…
-
Using Value passed from one report to the other
Summary I am trying to pass a value into a dataset where clause Content I have 2 reports. Rpt 1 & Rpt 2. Rpt 1 shows "Count of Days" and "Count of REQIDs". Rpt 2 shows all the fields from the table the couns came from. When the user clicks on the "Count of Days" cell in Rep 1, I want to know how to use the passed value…
-
OBIEE 12.2.1 metadata import does not show freshly created user from a pluggable database
Using SampleApp V607 OVA image did the following steps * log in to pdborcl container via the SQLDeveloper in the image using the connection: 'SYSTEM - Admin123 --pdborcl' * Creating user in the pluggable datababase: create user NEWDBUSER identified by Admin123; * starting OBIEE Client Admin tool v12.2.1.3.0 client (however…
-
Embedding OBIEE reports on other applications
Hello Experts, Currently we embed our OBIEE reports onto other JAVA based applications and we use GO Url option to embed OBIEE report in an iFrame in other application. Now we plan to use an option other than iFrame and would like to know what options we have for this kind of request. I was also thinking of using a web…
-
OBIEE 12.2.1.3 Heap Setting
Hi All, Anyone know if there is a maximum on the heap size for 12.2.1.3? I have a lot of memory on my server and the only application is OBIEE. Also, can I set a minimum just by adding -Xms? Thanks in advance!
-
oacs standard edition: security
Content Hello, When using OACS Standard edition with dataviz, which are the security options available in order to secure access for users through dataviz ? My data sources is database and/or flat files. Thank you.
-
OBIEE 11g: Customize "include column" interaction
Good morning, Quick question, is it possible to customize the list of possible column proposed in the "include columns" interaction ? See below example, I want to leave possibility for the user to include column interesting for data description (e.g. Site, Subject, etc.) but I don't to see some others columns which don't…
-
Error using column selector
Hi, On the report with column selector we are receiving error: State: HY000. Code: 15018. [nQSError: 15018] Incorrectly defined logical table source (for fact table Fact Workforce) does not contain mapping for [Dim Location.Region]. (HY000) Report contains two column selectors. Error is displayed when on first we select:…
-
Exporting report outputs(PDF, CSV) to Network Shared File system(Windows Server) from Agents in OBIE
I have followed all the steps from document https://support.oracle.com/rs?type=doc&id=1610118.1 excepting generating wlfullclient.jar as we are already in 12.2.1.3 and when tried to generate I got message as jar is depricated and cannt be generated. and while I tried to check EJB on agents Im getting below error .. Is…
-
Need A report for the AP Payment Approval through BPM Work list
Summary Need A report for the AP Payment Approval through BPM Work list Content Need A report for the AP Payment Approval through BPM Work list Version r13 19A
-
How to hide Credentials when LWSSO is disable
Hi All LWSSO is disabled and we don't want to enable; We are using Oracle forms 11g and opening our dashboards with webutil.client (dashboard URL) function. Our client raised objection that we should not display credentials on address bar as shown in Fig.1. Is there any solution, Can we hide credentials? Fig.1, Username…
-
Issue with report from BIP
Summary Trying to figure out why the Report from BIP is short Content Hello All, In running a report from BIP in Oracle Integration Cloud via a Soap Adapter, I am seeing that the report is resulting in a CSV file that is missing a few data entries in the last column. Example journal field 1,field 2,field 3,field 4,fied…
-
Import new column into RPD
Hi All, We have just added a few custom columns (category 1 type) to our data warehouse, per a business need. We tested the ETL's a few times now, and we can see that the data is coming through properly - fact stage and target fact tables. I was looking but didn't see that the new columns are being reflected in the RPD ( I…
-
Help with Advanced Editor Raw SQL Syntax
Hello all- Thank you for reviewing my Advanced Editor SQL Question. I have two queries that work alone by themselves. I want to add or subtract these numbers together. Here is an image of each result along with the SQL that is generated. I would like to Add or Sum the results of Query 1 with the results of Query 2 to get…
-
Waterfall Graph Based On Calculation
I will try to explain my issue in as much detail as possible. I appreciate all of the members on this forum for taking the time to review this question. This is a very difficult issue I am facing and I have been trying to solve it for more than a week. I have tried many different attempts with nothing to show for it. It…
-
Need suggestion over aggregation of records
Hello Experts, I need a suggestion regarding a requirement related to OBI. I have a requirement where - Against one user_ID there are two customer Name - Both are the name of same customer (some how in source system it has been entered). - In OBI actual report is looking like The requirement is - Create a single record…
-
How to pass a presentation variable via GoURL/prompted URL?
Hello everyone, I am using 12c. Question 1 This is the scenario. I have 2 dashboard pages. Dashboard page 1 has a District column with a Presentation variable attached to it. Let's call it PV_DISTRICT. (this is a prompt). This has a default district selected. This page has a performance tile, which when clicked on takes…
-
OBIEE query returns zero rows based on number of columns in select list
OBIEE queries such as the one indicated below executed with no issues for months. Following a recent reload of the table, the query returns zero rows unless the select list is expanded beyond three columns. Customer ID = 123 Select List... Customer ID, Transaction-Date, Transaction-Code.
-
OBIEE 12c Run action with select list option
Hi Guys I would like to run the action using the selection list as a parameter , is it possible ? The default field is String . I was able to modify the xml file for a given action by changing the "type" field from "string" to "date" in the parameters , but i need something like select list or option field form. I would…
-
Error when creating report from XML data source
Summary Error when creating report from XML data source Content Hi I have a new installation of BI Publisher Enterprise 12.2.1.4.0 and I have created a XML data source from a valid XML file. I can view the content of the file by clicking the data tab. When I try to create a report using the XML data source I get the…
-
Failed to Save OBIEE Connecction in Oracle DVD
Content I am getting "Failed to Save " Error when I am trying to connect OBIEE in Oracle DVD., I have freshly installed Oracle DVD Version 12.2.5.1.0-20190125221045., in Windows 10 laptop Do we need to do any configuration?
-
#Lost files in OBIE
Hi! Does anyone know if there is any way to recover deleted folders from obie? this in particular is installed on linux, we can not locate some folders we do not know if they were deleted, is there any way to check that in the log? or even recover them? thanks greetings
-
How to deploy RPD using unix script to automate deployment? Please provide the script.
How to deploy RPD using unix script to automate deployment? OBIEE 11.1.1.6.12 Please provide the script. Thanks
-
How to cinvert english name into Arabic name in report
Content we have created one report based on the Arabic template but name field is storing in English but we are looking for how to convert English name into the Arabic report Version r13 18D
-
What information does ORA_BIPS_LBINFO, ORA_BIPS_NQID, ADRUM_BTa cookies carries? and is it sensitive
What information does ORA_BIPS_LBINFO, ORA_BIPS_NQID, ADRUM_BTa cookies carries? and is it sensitive?
-
OBIEE Bar Graph Custom Coloring
Hi Guys, I am creating a graph that has channels as bars ( x axis) and its rating ( y-axis) for a month. I want to fix a color for each channel meaning that I want each bar to have a different color. Is that possible? I do have dimension of Channel. Is there a way to fix color scheme to each channel so in future every…
-
BI Publisher Data Model
Summary BI Publisher Data Model - Different Data Type Sets Content Hello, I have a requirement where I have data sets with SQL Query Type and one data set with Oracle BI Analysis. I am not able to link between the Sql Query Data set and the Oracle BI Analysis Data set. Is it possible in BI Publisher Data Model? if so, How…
