-
OBIEE 12c to TIBCO® Data Virtualization 8.2 DB connection issues
Hi All , We are trying to connect to Tibco data virtualization 8.2 DB from OBIEE 12c using the ODBC driver (oracle.bi.datadirect.odbc/7.1.5/lib/libcomposite82_x64.so) but we are getting below errors in OBIEE report. Previously we connected to Tibco 7.0 version from OBIEE using odbc driver " libcomposite70_x64.so" -- we…
-
Data Markers with less value not display in stacked bar graph
Dear All As you can see below , some data markers are not displaying on bar (highlighted with arrow has values =4), I wan to show all the values even if value is zero, can anyone please help me
-
How to hide data labels of Trendline and show on Bar
Dear All I have a requirement to show bar graph with trendline, show data labels on bar graph but hide data labels from Trendline I have used trendline function with LINEAR option, using OBIEE 12.2.1.3.0 Fig.1, Graph with data labels of Bar and Trendline I have searched on different forums but unable to find the solution
-
Create a session variable in RPD in offline mode
Summary Create a session variable in RPD in offline mode Content Hello community, I am creating a session variable with the purpose of being able to apply security at the data level, however when testing in my analytic, it shows me the following error: Status: HY000. Code: 23006. [nQSError: 23006] The session variable…
-
Dependent DFF Value Problem in Analytics
Summary I can not see null values for dependent dff value in report Content Hi Dear All, I use two dff value in purchase order. Those are Member Type and Member. Member Type is independent value but Member dependent on Member Type. In additional they are not required. I created a analytics from Purchasing Real Time. I…
-
Menu bar disappeared from OBIEE for users
Hello, For some users, the menu bar disappeared. Have tried deleting browser cache (IE, Chrome and Firefox) but still didn't work. Any suggestions? Many thanks! Rachna
-
How to change the remote port 9501 on opmn.xml?
Hello every one, we have obiee12214 and OBIA 11.1.1.0.2 on the same box, not sure why, port 9501 is being used by both, when we try to change port 9501 on opmn.xml for BI App 11.1.1.10.2, we are seeing BI down in obia11gEM console. is there any one has the issue? if so, how to change the port 9501 for OBIA11.1.1.10.2…
-
API for Graphs
Content Hi All, Whatever visualization/graph which we create in OAC, how it can be accessed through APIs. I want to call APIs and display the underlying visualization/graph from the calling tool
-
BI publisher report
I created report in BI Publisher but lookwise it is not good. Is it possible to resize the table to be of page size and to get only 10 rows and then click on next and get the next 10 rows. I checked in table properties, rows to display is 10 but if I click on report I see 2 issues. One table doesn't take the complete page…
-
Nqs Error - 17014 (Could not connect to Oracle Database in Report level) - OBIEE version 12.2.1.4.0
Hi Team, I have installed OBIEE 12.2.1.4.0 (Build BIPS-20180409090153 64-bit) version and Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production I have placed TNSNAME.ORA File in this location.C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\config\fmwconfig\bienv\core. While developing RPD I…
-
Can OBIEE 12C be installed on 11g weblogic
HI All, We all have a customer who is on 11g weblogic. Can he install 12c OBIEE on this 11g weblogic. Please let me know if there is any document which can let me know what all versions of weblogic are supported for 12c OBIEE. Thank you so much in Advance.
-
BI Publisher Bursting issues in 12c
Summary BI Publisher Bursting issues in 12c Content Hi all, First time posting here so hopefully this is in the correct spot. We have just upgraded from OBIEE 11g to 12c and noticed a huge increase in time spent while bursting. For example, reports bursting to file location (on local server) increasing from 4 minutes to 40…
-
Suppress column value in facts table
Note that my version ( 11.1.1.7) is no longer current. An analysis produces a report of about 25 columns detailing payment transactions to each vendor for a billing period. The requirement is to suppress the "care days" column so that it only appears once for all of the payment transactions for each vendor for the billing…
-
Reg: Aggregation not working in Dim table
Hello Team, Hope everyone doing well. We have dimension and fact tables all the detail level tables and no hierarchies was created. Recently we have created summation columns in both fact and dimensional tables * Distinct count column based on ID in the table, we kept default aggregation rule as distinct count (this we…
-
How do I extract a range of dates from the current_date object in OAC
Summary I want to extract a range of dates (last 7days or last 14days) from the current_date object in OAC Content Hello, In a OAC project, I have a visualization, that uses current_date object as the x-axis and current_month as the top level filter. Currently, as shown in the screenshot, for the current_month, data for…
-
Month wise Average of Measure
Dear Friends I am working in hospital and draw a bar graph in OBIEE and applied average function on measure, it was working fine until next month start, * In April-2020, total counts are 25 and 20 working days as shown in Fig.1, average must be 1.25 * in March-2020, total counts are 19 and 2 working days as shown in Fig.2,…
-
cast of date column in "concat" not consistent
Version in use is 11.1.1.7 There are two analyses in the dashboard. The first analysis does a concatenation of an ID and a cast of a date column generating the format DD-MON-YY for the date. The second analysis in the dashboard also does a concatenation of an ID and a cast of a date column generating the format YYYY/MM/DD…
-
Filter Based on Time
Hi Team, How to filter out lead records that are auto-created during non-office hours? Like I need to show lead which is assigned after 5 pm till 8:59 Am next day in OBIEE report It's a daily report. Only Friday is a holiday. Office hours are from 9 am to 5 pm. Thanks
-
Previous Year Values using Date Between dashboard prompt
Hi, There is Date dashboard prompt, where " is Between" is the operator for this date dashboard prompt. Can you please let me know how to display the previous year values in a simple report. Thanks in Advance Ajith
-
Unable to get excepted result using the filter" Based on results of another analysis"
Hi, I am having two analysis, they are 1. The table shows Lead details 2.Another report which shows the holiday lists with holiday name, From date and To date.From and to dates will be the same that is one day holiday and it will also have records with 3 continuous days as holidays. I need to display the lead whichare…
-
Column hide option in graph view in obiee
Hi, I am using graph view in one of report. In that I am trying to hide multiple columns which I am using sorting purpose.is there anyway I can hide the columns similar to how we hide the columns in pivot view, instead of going back to criteria and update the column properties, since I need to display same columns in…
-
em console shows coreapplication down when everything is fine
Hello, we have obia11.1.1.10.2 after changed remote port 9501 to 9551 in opmn.xml file. we get the error in admin server log: InetSocketAddress: obiee/10.0.0.10:9501 dialOpmn: SSL obiee:9501 wallet=/u01/app/fmw/user_projects/domains/bifoundation_domain/opmn/instance1/wallet timeout=60000ms dialOpmn: SSL connect failed…
-
OBIEE Connection Pool
Hi All, Oracle Business Intelligence 12.2.1.4.0 We increased number of OBIEE users. With that, we are reevaluating the number of connections specified in the connection Pool. I have seen the magic formula of number of connections in oracle support and various blogs I don't want to increase the connections if its not…
-
Display only last 4 digits of National Identifier
OBIEE - Would someone please help with a formula to display only the last 4 digits from this social security number field? The field name is "Worker"."Primary National Identifier Number" Example: change 123-45-6789 to 6789. Thanks!
-
Number of columns limitation in Bi publisher
Summary Number of columns limitation in Bi publisher Content Hi, In bi publisher, i am facing with exceeding more no of columns so while creating reports from specific datamodel i want to pull 25 coloumn at time in bi publishr report . but the table is showing there is no more enough space. so, is there any way to increase…
-
Narrative view not working with union report
i created union report from multiple subject areas.when I try to use them in narrative view like @2, @3.., it’s showing values from only one subject area not from other subject area. anyone suggest me if narrative view works well with union report Or do I need to follow any additional steps to get them work. thanks in…
-
List of value (Filter LOV) is defferent for a user
Hi, I am using Oracle Business Intelligence 12.2.1.1.0 One user is unable to see the same list of value as other users with same role. What can cause the lov not to refresh for a particular user (I tried on different computers and browsers.) Thanks Youssef
-
Column Interaction in dashboard
Hi, I have a dashboard section of different products with their revenues in performance tiles. As a requirement, I need to add an interaction to those performance tiles so as when the tile is clicked, it shows the details of that particular product ONLY. I am unable to filter the data based on the product. As of now, I am…
-
OBIEE12c - Automation of user/group adapter files creation for SQLAuthenticator
Hi, I'm automating the configuration for the SQLAuthentictor on OBIEE 12.2.1.2.0 and for this i need to call the OOTB script libovdadapterconfig.sh to add the necessary user and group adapter files. However when libovdadapterconfig.sh is executed with the list of allowed parameter values supplied, it prompts for the…
-
Dynamic filename while bursting on content server (UCM)
Hi, I am trying to burst a BI publisher report on a Content server (UCM) server. While bursting I want to create a dynamic filename & dynamic folder creation based on some field selected in query. Any help will be appreciated. Regards
