-
Behaviour of Incremental Dataflow with "save data to" option set to "db connection"
Content Hello, I've created an incremental Dataflow in OAC to over come the problem of "huge record set" in my datasource. My datasource has more than 10 lakhs of records and dataflow processing this dataset fails. To overcome this issue I am using incremental dataflow for which I've set, "save data to" option to "db…
-
Permissions to rename object (OAC)
In latest OAC edition "Classic OBIEE"... Do users still need "Delete" permissions on an object in order to rename it? Documentation is unclear, but this seems to be the case in practical use. If so, this is incredibly frustrating. "Edit" permissions should be enough! Thanks for input.
-
Is Essbase the backend for OAC?
Summary Essbase vs OAC Content Hi All, A traditional EPM user looking to move to the cloud and I want to clear myself of some confusion on what OAC is and what role essbase plays in it. Can someone please clarify if Essbase is the backend engine for OAC or if it is just a product within the OAC Suite? I have tried to read…
-
column headers are not aligned with the rest of the table
I have a dashboard that contains two tables. For one table, the column headers are not aligned with the contents of the table. It is as if the headers are shifted half an inch over from the rest of the table. However, if I refresh the page or visit it later, the problem disappears. The issue is coming and going at random…
-
OBIEE- Scheduled analysis return cached data
Hi, I have an agent scheduled to send email everyday. The data we get by email are not up to date. When I run the same analysis manually (not scheduled) I get the up to date data. As a work around, I added a prefix to the analysis SET VARIABLE DISABLE_CACHE_HIT=1; The scheduled data are now up-to-date. I don't understand…
-
Column Font Size Varies in OBIEE Table
I have created a table in OBIEE. One of the column headers and its contents have a significantly smaller font size, and I am not sure why. This column was added to a previously published dashboard. Any help would be appreciated.
-
OBIEE 12c / Apache Derby (Embedded)
Hello, What version of Derby is embedded in OBIEE 12c? thank you.
-
OBIEE Soap interface maximum row limit
Hello, We are using web service interface of OBIEE. We are calling executeAnalysis SOAP method. The response contains maximum 250 <tns1:row> elements. However we need to return more rows. Is there a configuration file or option where I can increase this limit? Thanks and best regards, Bilge
-
Display Dashboard prompts in row order without scroll bar
I am using an obsolete version of OBIEE(11.1). I would like any insights on whether I can order over 25 Dashboard prompts in row order without triggering a scroll bar so that all the prompts are visible to the user without scrolling. I tried to use the Dashboard Properties dialog to use the "fill browser window" browser"…
-
SQL using Presentation variable from dashboard prompt, not working
Hi all, I'm trying to get a (or multiple) presentation variable(s) working in the where statement of a sql-clause. I have this specific sql used in bi using the "DirectDatabaseRequest" functionality. With variables hardcoded it works fine, but my colleagues would like to have the possibility of using an excisting…
-
Oracle 19c Auto Indexing (AI) html Reports
Summary How do I interpret 'Original Plan' and 'Plan with Auto Indexes' in the AI html reports? Content Hi, I've enabled Auto Indexing (AI) on our Autonomous Data Warehouse (in Oracle19c). The first report I ran for the past 24 hours is very self explainatory and it clearly shows the improvements for, before enabling AI…
-
OBIEE 12c : NodeManager fails to strat with "Key store identity alias does not contain a certificate
Hello, We are following the Doc ID 2188982.1 in order to configure SSL communication OBIEE 12c but when attempting to start the NodeManger, it doesnt start, the log show the following error : <23 déc. 2019 10 h 31 CET> <INFO> <Loading domains file: D:…
-
Action Link with Multiple Parameters
Hi all, I'm using BI on OAC. I have a requirement to use action link to navigate to another BI content analysis which should filter for more than one value (Ex: When customer click on action link, country and Industry should be filtered). Instead the action link is filtering only on Industry ignoring the country. Any ideas…
-
Autoadjust the width of the dashboard
Hi Is it possible to have the dashboard auto-adjust its width based on the device type in OBIEE 12c? I have a dashboard built on a PC which works fine but when trying to access it on a phone/tablet, the alignment of the width is not adjusted accordingly and I get a horizontal and vertical scroll bar. Thanks in advance
-
Unable to delete a reporting agent
Hi everyone, Hope everyone is safe and well! I was trying to delete a disabled agent and it doesn't seem to allow me to. I always get this error message. Anyone else experiencing this issue? What should I do? Appreciate the insight. Thanks!
-
Upload RPD on OAS
Hi does anyone know how can I upload RPD to OAS, also for the admin tool do i have to set Oracle BI Server OAS in ODBC Data Source Administrator(64 bit)? Kr, Matija
-
Blocking Analyses Based on Criteria in OBIEE 12.2.1.2.0
Hi All, How to implement Blocking Analyses Based on Criteria in OBIEE 12.2.1.2.0. Requirement: Basically users are not applying mandatory filters in obiee as a result query's running a long time and users are saying obiee slow. We need to display pop up window message when users not applying mandatory filter. Ex: Custom…
-
OBIEE12c: How can I prevent Usage Tracking from inserting to S_NQ_DB_ACCT?
Hi gurus, I am using Usage Tracking. I would like to enable writing to S_NQ_ACCT and disable writing to S_NQ_DB_ACCT. Is it possible? Thanks! Alex
-
Warning 38100: Tables joined logically, not physically
Here is an example of a warning from my consistency check: Warning: [38100] The logical tables "Core"."Inventory" and "Core"."Dept Budgets" connected by logical join '"Relationship_2004:6243231247724664"' have no corresponding physical connections. Analysis: There are 74 of these warnings in the consistency check. Most of…
-
Warning 39092: Column is first under presentation hierarchy but not a grand total level
In an RPD that started its life in 11g and has been migrated to 12c, I now see a consistency check warning in 12c: "[39092] Presentation level "Budgets"."Time"."Year" is first under presentation hierarchy, but logical level it is associated with is not grand total level." Year has always been the topmost level of this Time…
-
Coonect Oracle Admin Tool to OAC error
Hi everyone, I have OAC with link: xxxbieedev-xxxcloud.analytics.ocp.oraclecloud.com I have for my OAC the Identity Cloud Service I have user with BI Administration Services. Log in OAC working fine, I import my 'test' rpd like import .bar file in snapshot. It's working fine I see my all presenation area and whole model.…
-
Multiple Line Bar chart in a view
Hey, I am trying to figure out how can the below result be reciprocated in OBIEE, I made it in Tableau. I have tried several ways but cannot seem to achieve the desired results. Any feedback or suggestion will be appreciated. Thanks, Manan
-
BIPS Cursor Log
Hello. We are using Oracle Business Intelligence 12.2.1.4.0. If you go to Administration > Manager Sessions > BIPS Diagnostics > BIPS Cursor Log, there is information about memory usage for specific session. Is there any way to get this information for all sesssions at once? Greetings M.
-
Calculate the count based on previous month products
I would like to know how can I get the exact new product count for data like below. Month | product | Amount 1st Jan 2020 | TV | 100 3rd Jan 2020 | sofa | 200 4th Feb 2020 | TV | 300 7th Feb 2020 | furniture| 500 in the above case, I need output like below. month|product count|Amount Jan 2020 | 2 | 300 Feb 2020 | 1 | 800…
-
BIP Jobs stored in DB table
Hi Team, I have a requirement like, to automate(need to schedule a report) the BIP jobs ran for current date. I found the below tables where BIP jobs information was stored but I couldn't found the Job name(Blank/no entry) in the table XMLP_SCHED_OUTPUT. XMLP_SCHED_OUTPUT XMLP_SCHED_JOB XMLP_SCHED_DELIVERY So please…
-
How to find the IP Address and the private key to SSH in to the OAC server?
Summary How to find the IP Address and the private key to SSH in to the OAC server? Content Hello, I am trying to configure “Usage Tracking” in OAC and as a pre-requisite for this I need to deploy RPD on OAC. To download an offline copy of RPD, I need to SSH in to the server. Does anyone know how to find the IP Address and…
-
How to configure full load and incremental load in OBIA 11.1.1.10.2?
Hello, How to configure full load and incremental load in OBIA 11.1.1.10.2? also, if the full load fails, how to re-start it rom scratch and from the failure point only?thanks
-
ERROR IN DISPLAYING ADW DATA FROM OAC USING RDP
Hi everyone, I am in the visualization of data built from a thematic area with RPD, use the data of tnsnames that contains the autonomous Oracle Oracle wallet, from the RPD I could import my tables and see data even from the tables, but once loaded the offline file in the Analytics console and refresh the metadata from the…
-
How do I know the OAC usage report?
Summary I want to know the number of users logging in to our (accessing) OAC instance Content Hello, Is there a way to get a report on number of users logging in or accessing our OAC instance? If we could generate a report, I would like to get this report for a particular duration, say, weekly or monthly. If there is no…
-
How To Disable Or Remove The Export / Download - Data - CSV Format Option in 11g
Hi, How To Disable Or Remove The Export / Download - Data - CSV Format Option in OBIEE 10g And 11g (Doc ID 1270579.1). I tried to follow the steps given in oracle https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=232568382297144&id=1270579.1&_afrWindowMode=0&_adf.ctr… But this is not working and i still get…
