-
OBIEE reports hanging after being amended
We are on OBIEE version 1.1.7 having upgraded from version 1.1.5 and are getting the following behaviour Reports coming from an Oracle database subject area will not return after being an object is changed. The reports return data unchanged. Our support person can run and change the report in our UAT environment without an…
-
New Features - how to enable
Hello I am using Oracle Business Intelligence 11.1.1.7.150120 I deployed Sample App. In the sample App when I go to Edit Dashboard -> Column Properties (column in which a prompt is placed) . I see "Freeze Column" option which can be checked and unchecked. But when I go to create a new dashboard and add a column and some…
-
XML example for the Catalog Manager command line function publisherPermissionsImport (OBIEE 11.1.1.5
Hi all, I have an issue that has confused me. From the Catalog Manager we can manually edit permission for folders and other objects. Also Catalog Manager allow make changes from command line using runcat.cmd I want to use the function publisherPermissionsImport but I don't know XML structure this function needs. May be…
-
Add HTML to OBIEE global template
Version: 11.1.1.7.151020 Platform: RHL 5 I'd like to add an HTML tag within the <HEAD> tag of the global template (assuming that exists). I've searched here and The Google Machine and most of the articles that come up reference BIP. I refined my search at one point to search for the integration of Google Analytics, but…
-
unable to export image
Hi Experts, I am trying to exporting the report in to pdf but image is not coming...i am using narrative view. the image copied in two different locations as per the other sites. but i can see other values from the view but only image is not showing on the PDF. Any solution. Thanks!!!
-
Dynamic Database connection (e.g. Test, Prod) based on OBIEE Login
We have designed an OBIEE RPD where the physical layer is based upon a single Oracle database, however, there are multiple instances (TEST, PROD ...etc) of this database structure. While we require most users to report against the PROD instance, it is also a requirement to occasionally be able to run the same reports…
-
Unable to start BI services
Running the following command: /oracle/Middleware/Oracle_Home/user_projects/domains/test-bi01/bitools/bin/start.sh ... Reading domain... /Servers/AdminServer/ListenPort=9500 Accessing admin server using URL t3://test-bi01:9500 Starting AdminServer ... Admin Server Start Exception: Error occurred while performing nmStart :…
-
OBI sort order analysis based on sort order in another analysis
Hi, I am using OBIEE version 12.1. I have created Analysis 1 with a sort order based on column x I have created Analysis 2 and would like to set the sort order based on Analysis 1 results Is that possible to achieve or is there a better work around?
-
Passing value from one prompt to other prompt between pages in dashboard
hi, i have 2 pages(P1, P2) in one dashboard(D1). P1 page has prompt - PM1 and Report - R1 P2 page has prompt - PM2 and Report - R2 i have two different columns Organisation and institution.but both columns has more or less same data But those are two different columns. PM1 Columns - Organisation R1 Columns - Organisation…
-
Install Oracle BI 12c: config action BI configuration failed
Hi! I'm trying to install OBIEE 12c on my VM. I have succesfull installation of weblogic server and bi platform, but i have an error on the "Configuration Progress" step in Configuration Assistant. About VM: CPU i7, RAM 5 Gb, SSD 75 Gb. OS: Microsoft Windows Server 2008 R2 Standart x64. DB: Microsoft SQL Server 2012 SP1.…
-
[OBIEE USER PROVISIONING] CAN IT BE DONE BY UPLOADING FILES (EXCEL, CSV) OR THROUGH CODING?
Hello! I have and OBIEE connected to ESSBASE. I pull in ADAM users from Shared Service Console we use to log in to essbase. We have many users and many groups. I know we have to go enterprise manager (EM) for OBIEE and do the followings: 1. Create groups. 2. Provision active directory users to the corresponding groups.…
-
Formula column - calculation based on value from other row
Hi Friends, I am new to OBIEE. I have a requirement to create formula column based on value from other row. For eg: ----------------------------------------------------------------------------------- rownum Account_num Account_Desc Amount ----------------------------------------------------------------------------------- 1…
-
Pass other prompt presentation variable as a default value to current prompt
i have 2 pages in my dashboard.each page has one prompt With one different column each my requirement is to pass presentation variable of first prompt column as a default value to second page prompt. both prompt1 and prompt 2 have not the same columns. anyone suggest me how can I a hive this?
-
RCU for OBIEE 11.1.1.9
Hello, Iam going to install OBIEE 11.1.1.9 on Solaris SPARC 64-bit machine. But when I checked for RCU 11.1.1.9, it is only available for Windows 64-bit, Linux 32 and Linux 64-bit Platforms. How do I proceed ?? Please suggest a solution/workaround for this as soon as possible. Regards/ KK
-
Oracle VA 12.2.1 - Line Bar
Hi, Does anyone know if you can produce a Line Bar Graph in Oracle VA 12.2.1? Thanks.
-
Aggregate manager - waiting for all threads to complete
Hi all We are creating aggregates via nqcmd scipts. All is working but sometimes it takes a very long time for the process to complete. Looking at the NQQuery log, we noticed that there is repeated messages "Aggregate Manager: Waiting for all threads to complete". This message appears every 10 minutes. We can see that the…
-
User name Password session variables
I Want to connect to database from RPD based on login user name and password. for that I am using :user in connection pool to get connect to database. But not sure how can i pass password. anyone suggest how can I pass password in connection pool to connect to database?
-
OBIEE agent - BI Publisher report embedded in dashboard
Hi We got a requirement to use agent to send the whole dashboard (3 obiee report dashboard pages and 1 BIP dashboard page) in excel formatt. The requirement is to send 1 Excel file with mulitple tabs. However, when the agent run, the BIP tab/dashboard page came out blank, while other 3 tabs with obiee report came out fine.…
-
View display error in obiee 11g anlytics?
Hi, I am working on obiee 11.1.1.9 . I have created reports in analytics with year, month prompt selection. after open the report i am getting below error. view display errorExceeded configured maximum number of allowed input records. Error Codes: EKMT3FK5 Location: saw.httpserver.processrequest, saw.rpc.server.responder,…
-
Rolling dates in prompt
Hi friends, Im in obiee 11.1.1.7 I need to have a prompt with a rolling dates of 20 with effective from sysdate. Like for example if sysdate is 17-1-2016 then i have to display the next 20 dates in the prompt dynamically like starting from 18-1-2016 to 06-02-2016(6th feb). So in that way the dates will be incrementing…
-
Business Intelligence filters through the Go or Dasboard URL
Help me! :-) I need to pass filters through the Go and Dashboard URL, but i've not result! Link I've create is: Link like these: http:///analytics/saw.dll?Dashboard&PortalPath=&NQuser=&NQPassword= give me correct result but following link:…
-
how to do a data marker on a gauge
Hello, I have a simple gauge that works well, however I would like to add a data marker as well (basically showing the forecast). the forecast column is a static number. I'm trying to differentiate the 2 needles by changing the forecast one to a line but everytime i try this and click ok it doesn't save it and it then goes…
-
how to invoke java beans on oracle EBS form
how to invoke java beans on oracle ebs form
-
Always Display default values in pages with action links
I have multiple pages in one dashboard. i Set prompt scope to 'Page' in all pages. As per requirement , I need to create links(action link) for other pages In first page. ccurrently if I navigate from first page to second page through action link, all prompt values are passing from first page to second page. my requirement…
-
OBIEE 12c & EPM
Hi, Which version of EPM is certified to be used with OBIEE 12c? Can we connect to Essbase from OBIEE 12c? Thanks Nandoo
-
One line for labels in Stackbar graph in OBIEE
Hi Gurus, Need urgent support from you!!!! My client requested for stacked bar graph, which on the horizontal axis has two labels (text format). Depending on the values selected on prompts, these labels could be presented in one, two and three lines. Now, the customer requires to have these labels in one line at ALL THE…
-
Error to create Logical Level Based Hierarchy
Hi All, i am creating logical level based hierarchy using Time Dimension Time Dimension comes from following query select to_char(bilmon,'RRRR') Year, to_char(bilmon,'Month') Month, to_char(bilmon,'MM') Month_in_num,…
-
Display actual value and percentage in OBIEE 100% stacked bar chart?
Hi All, We have built a 100% stacked bar chart in OBIEE 11g with data markers set to "Always show", but they only display % values inside the bars. One of our customers requested for the actual value too to be displayed alongside the % value within the same chart. I have looked through all the options that the graph offers…
-
Unable to export the report as a normal user
Hi Experts, I am facing the issue , I am a admin user I can able to export the report in to excel. but as a normal user he is not able to exporting the report in to excel. Can you help me where I need to check the permissions for this. Is there any specific permissions I need to apply. Thanks in Advance!!
-
"You are not currently signed in to the Oracle BI Server. If you have already signed in, your conne
We are certifying EBS (12.2.5 ) with BI instance 12.2.1 integration After integration when we try to access the Analytics url, we see this err. Has anybody seen this issue anytime. Any pointers would be highly appreciated. Error noticed in the app url: You are not currently signed in to the Oracle BI Server. If you have…
