-
OBIEE Report size increases slightly more than double while mailing from desktop mail clients like T
Hi All, We are having a OBIEE report on "Oracle Business Intelligence 12.2.1.4.0" with few graphs and tables! Issue: Size of OBIEE report delivered by OBIEE delivery agent is ~600KB and when it is forwarded from Thunderbird/Outlook Email desktop client it increases to 1.6 to 2 MB Could you please help us in the above to…
-
Page Break adding additional Line in 2nd page
Summary Page Break adding additional Line in 2nd page Content Hi Gurus, Problem with Page break for the last 10 days and no solution yet. I have a pre-printed stationery with a group start at the beginning and end of the page. I have a Page break at the end. First page comes correctly, but an additional line is always…
-
Does OBIEE 12c (12.2.1.4) have SQL Server 2017 Driver? And is it supported?
Has anyone had any luck connecting to a SQL Server 2017 database as a data source in the RPD? And if so, is it supported by Oracle?
-
OBIEE 12C smtp server setting
Dear Experts, I have upgrade obiee 11g to obiee 12.2.1.4.0, I wants to configure smtp in my new environment. 1) the first thing i wants to confgiure smptp, before or after configuring this i wants to stop all agents which will triger to respective timestamp ? how can I stop all agents ? 2) I can see scheduler tab is…
-
OAC Connection for Eloqua
Summary Why OAC only support Replication Connection for Eloqua? Content OAC only supports replication connection to Eloqua. Do we know why? Do we have plan to support Connection to Eloqua without replicating data from Eloqua to a target connection (e.g. Big Data, ADW). This helps if customer just wants to access the data…
-
OBIEE 12c - My Folder not appearing in catalog for Admin Users
Hi, We have migrated from OBIEE 11g to OBIEE 12c. The migration went successful. However, My Folder is not appearing for Admin users including weblogic. But users with consumner roll can see My Folder in their catalog. Any idea on root cause? Thanks, Shiva
-
Need formula to remove dashes from string
OBIEE - Would someone please help with a formula to remove dashes from this social security number field so that only the digits remain. The field name is "Worker"."Primary National Identifier Number" Example: change xxx-xx-xxxx to xxxxxxxxx (must be 9 digit social). Thanks!
-
Way to get Previous month booking
Hi, I'm very new to OAC and I'm finding trouble with the following case. I have a situation: when the user selects the month in the prompt, he could able to see Selected month bookings, as well as previous month bookings (in two separate charts) in the dashboard. How can I get previous month bookings dynamically? I…
-
EBS - APCC - RPD/catalog - Not able to set dependency between 2 columns which are in 2 different st
12c OBIEE-/ APCC - RPD/catalog - Not able to set dependency between 2 columns which are in 2 different standard logical folders we have Item folder/dimension and Organization folder/dimension. in catalog /view - i am trying to create a dependency between the Planning group column which is in the Item folder/dimension where…
-
Selecting a value in a chart filters other charts in the report
Hi, I am working on an Analysis in OBIEE. I have 1 table with Countries list and their sales information. I have another Bar chart with Products and their Sales information. So, whenever I click on a Country in the Table, the bar chart should be filtered with the products that are sold in that selected country and the…
-
OAC to AWS
Hi I am wondering if there is a way to connect to AWS (redshift) from OAC Data Model. I know that there is a connector for DV, but any chance that the RPD (data model) can connect to it? Thanks!
-
Custom Filter in Analysis
Hi, I am trying to create a custom-defined filter in my Analysis, which I am unable to figure out how to do it. Let me explain this with an example for a better understanding: I have the following table: StudentID StudentName Section Internal_Marks External_Marks 1 ABC A 20 25 2 BCD A 15 28 3 DEF B 22 26 4 FGH B 18 24 Now…
-
Data level security for OBIEE Agents
Team, i have one obiee report which contains 10 retail stores data , now i need to design a deliver/agent so that each store owner gets their respective data? Any leeds? Thanks Joji
-
Getting Green up arrow in the chart
Hi, While creating a financial chart, I couldn't able to find Green up arrow in conditional formating to represent the positive growth in the KPI. Could you please suggest how I can get it? Thank You, Krishna Kalyan
-
BI publisher: how to get query hitting database from a BI publisher report
Hi Gurus, New to BI Publisher space. Wondering how to retrieve the query behind a BI publisher report. We need to performance tune BIP reports so i would like to look at the SQL query if there is any chance to optimize it. Thanks in advance.
-
OBIEE 12c batch file
Dear Experts, How to write simple batch file to call below command from task manager to take bakup welly base E:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin>exportarchive.cmd ssi E:\Oracle\Middleware\Oracle_Home\user_projects\BAR\BARExport OBIEE 12.2.1.4.o, windows server 2016 Please share your ideas
-
Obiee Weblogic Login Problem
Hi, We have a problem for logging into obiee CONSOLE site via user weblogic. When I try to login console, the login pages come and enter weblogic user and password. Then I get the error below; The username or password has been refused by WebLogic Server. Please try again. However, with same user and password I can login EM…
-
Export All Layouts in one Excell File in obiee publisher
Dears, Any one can help me in how to Export All Layouts in one Excell File in obiee publisher Thanks in advance Hassan
-
Attend The Premier Oracle Technology Conference—ODTUG Kscope20
Summary Your ODTUG Kscope20 conference pass includes access to over 300+ technical sessions, all-day symposiums, lunch and learn panels with Oracle experts, and hands-on-training. Content ODTUG Kscope stands out from other user group conferences and training due to its: * Non-stop learning and special educational formats,…
-
OAC Data Gateway FAQ
Summary Everything you ever wanted to know about OAC Data Gateway (with inputs from Product Management) Content DISCLAIMER: This post was initially created in August 2019, when the standard documentation was lacking details. Some information below might not be accurate today (that’s the beauty of cloud and its associated…
-
BIEE 12.2.1.4.0 JDBC (jndi) error when execute Scripts on Connection
Dear Specialists I will describe the case: Current scenario Datasource's; Oracle with VPD and Vertica with VPD. BIEE 12 with Connection Pool using OCI. Script on connect defines sessions that are the parameter for data security / governance. The two blocks of code currently look like this: call dbms_session.set_identifier…
-
How to show results within the past 30 days
I'm new to OTBI. I have an analyses where I want to return data for all employees termed within the past 30 days. I want it show terminations 30 days ago, 29 day ago, 28 days ago down to 1 day ago. How can I apply a filter or formula that will do this? The field is "Worker"."Termination Date".
-
Obiee 12c to bi publisher 12 c sending emails
Hello all, We have a requirement to print a report from obiee dashboard which is developed in bi publisher . We are able to set up the print option using link or image option.when user click print button it will navigate to bi publisher and open the report. Now we need to send it to the user email as well. Seems…
-
Subquery in data filter in Admin Tool
Hi. does anyone know is it allowed to put subquery in data filter like this? "ADW_TEST"."Costs"."Prod id" IN (SELECT "ADW_TEST"."Products"."Prod id" FROM "ADW_TEST"."Products" WHERE "ADW_TEST"."Products"."Prod category id" != 205 ) 205 value is currently hardcoded, it will be changed by a variable later.
-
rank function and prompt
hello I've used a analyze contain employee and salaries and rank function (rank(mysubject.year)) everything is ok and rank show me a correct value.. but when I add year as a prompt then rank display overall not the data affected by prompt I use obiee12c
-
Data Reading Best Approach
Summary Viewing the OAC data source best approach Content Dear Experts, We are implementing OAC and considering the best approaches to read the data from the Oracle on-prem databases. We have a large volume of daily transactions, so what is recommended whether to read directly from the on-prem resource (example using Data…
-
How do i design a report for mobile
Hello everyone, i am using OBNIEE 12.2.1.3.0 i have designed report and they are working with no problem , i would like to transform them to Mobile reports. 1st question : Is there any difference between designing reports for Android and Iphones ? 2d question : What is the best way to create mobile reports 3rd question :…
-
Unable to choose member from the parent-child hier. on dashboard prompt after migrating from 11g to
We are getting this error in browser console after choosing member from the parent-child hierarchy on dashboard prompt: selectionsmodel.js:1 Uncaught TypeError: Cannot read property 'getKeyColumnInfo' of null at Function.SelectionsModel.getColumnXsiDataType (selectionsmodel.js:1) at…
-
Obiee Cache Question
Hi, In our company, we use obiee 12. There are lots of dashboards and analysis seen by customers. Sometimes, because of obiee cache reports are not refreshed and does not bring latest value. How can we solve this issue? We thought that we can clear total cache every 6 hours :S Is it a good opinion? Or, do you suggest any…
-
OBIEE 12C BAR file automated daily backup
Dear Experts, Do we have any process for obiee 12C BAR file automatic backup on daily basis. Please share your experiences. Thanks,
