-
No results messeage
Hi I am using OBIEE 12.2.1.2.0 When my analysisi results in no data i get the following message ''The layout of this view combined with the data, selections,drills or prompt values resulted in no data.'' However i want to put custom message instead of this one, i go to analysis and i do this but it still gives me the same…
-
BIP report - change existing report to use different datamodel
Summary Is it possible to change an existing report to use a different datamodel Content On BIP 12.2.2.1.1.0 I have created and report that uses datamodel A as its datasource (datamodel A is a non standard SQL query). I have created datamodel B now (non standard SQL query) Is it possible to set the report to use datamodel…
-
Oracle Analytics Cloud - iBot issue
Hi Guys I have a basic req. but somewhere i am doing wrong and trying to know where i missed out. I m using Oracle Business Intelligence Product Version 12.2.4.0.0 This is regarding iBots where i have to send the same report to users listed in that. Nameemail IdEmployee IDRevenue…
-
RPD join - results are multiplied
Hi, Question related to RPD join setup. We have table with Employees Performance reviews per employee per year. It is joined with Dim_date: EXTRACT (YEAR from DimDate.ACTUALDATE)-1 = PerfReview.Rewiew Year. Now when we try to create simple analysis: Employee ID, Rating, Review Year each Rating is multiplied 360 times. If I…
-
OBIEE Analysis: Adding a specific column creates No Results error
I'm trying to add a salary basis and annualized salary amount into an analysis but as soon as I add the column and try to show the results it comes up with the error No Results. If i delete the column the results of the name,lastname ect. come back. Any thoughts?
-
OAC 18.3.3 update is coming - check the new features
Summary See new features of the new Oracle Analytics Cloud update (18.3.3) ! Content Hello forum members The new upgdate of Oracle Analytics Cloud (18.3.3) is in the process of deploying to all Cloud datacenters. It brings many new functional features for DV end-users, check these out in the overview :…
-
TBW 12.2.13 table incorrect pdf
Summary TBW 12.2.13 table incorrect pdf Content Hy, I've in my rtf a table with two colums. In the left column, i've a an image, in the the right column, i've several lignes whith text and field. Under this, there's another table separated with one blank line. In version 10, pdf produced with server was OK, and now in my…
-
Use case(s) for 'Publishing Dashboard Pages'
Hi All, We had seen the option to 'Publish Page to Dashboard ...'. I've read a little bit about it, but I am not totally clear on the use case(s)/benefits of doing this. Listing a few points/questions below, as examples. It sounds like it is only for individual dashboard pages (as opposed to entire dashboards), right?…
-
success_flag not updating correctly in usage tracking
Hi All success_flag is not updating correctly in usage tracking we see only 0 for success and 3 for all the failures no single column have 1 or 2 for the failure reports. i checked support blog couldnt find anything, our version OBIEE 11.1.1.7.140715 any known issue work around any body aware of ... Thank you for the help…
-
auth-constraint in WEB.xml and security-role-assignment in WEBLOGIC.xml
Dear GURUS, I am trying to understand a few of the descriptors used for Security authentication using LDAP in web.xml and weblogic.xml: Web.xml: <security-constraint> <auth-constraint> <role-name>webuser</role-name> WEBLOGIC.xml: <security-role-assignment> <role-name>webuser</role-name>…
-
Enable Day to Day
Summary How eneable Day to Day, how indexing and how use the application Content Hi comunity, i have an OAC Service instance with severals projects enable and working, i need enable "Day by Day" application but this not work. I installed "Day to Day" in my phone and i indexing accord the documentation. But this dont…
-
Running Total problem in xdoxslt with xdofx formula
Summary How to build a running total with xdoxslt:set_variable when it contains a xdofx formula Content Hi All, I am building a BI Publisher RTF report. I am trying to build a running total for a field that has the following formula: <?xdofx:(WYO_AMEND_FEE_1 + WYO_AMEND_FEE_2 + WYO_AMEND_FEE_CONS + WYO_AMEND_FEE_OTH +…
-
OBIPS: [ERROR:31][saw.rpc.server.responder] An error occurred retrieving DMS metrics.
Hi, for a new OBIEE-installation 12.2.1.4.0 could not configuration process completed because OBIPS-errors. * OS 64-bit Windows Server 2016 Standard * WLS 12.2.1.3.0 * OBIEE 12.2.1.4.0 We get the following information from sawlog0.log: ...[OBIPS] [ERROR:31] [] [saw.rpc.server.responder] [ecid: ] [tid: 348] [SI-Name: ]…
-
How to upload Images in Fusion and use them in RTF
Summary How to upload Images in Fusion and use them in RTF Content Hi have a requirement to use Logo based on Bill to Location. how to store the Images in Oracle Fusion. And How to read them to show in RTF. In EBS $OA_MEDIA/ we use to store and using URL syntax used to refer them in RTF. how to do same in Fusion RTF…
-
[OBIEE 12c] Error when importing BAR File
Hi Team, I am facing an error when i am trying to import a BAR file : I am requesting your help to solve this problem. I am not able to find a solution. The proplem appear only when i'm importing the securtity. Importing Datamodel and catalog is working whitout problem INFO: Service Owner: weblogic Aug 08, 2018 11:34:18 AM…
-
Catalog Manager
i am using OBIEE 12.2.1.2.0 I want to acces catalog through catalog manager and a do this and i got message like this any thoughts of what i am doing wrong??
-
OBIEE Report running for longer time
Hi All, User is facing issue while running the 4 days data using OBIEE, User is trying to fetch the data from 1 Aug 2018 to 6 Aug 2018. But report is taking 5 mins to show the result and when i get the obiee query and ran it in DB its taking 1 mins. My question is why its taking more timing OBIEE is any configuration…
-
Uploading.png
Hi i am using OBIEE I have trouble uploading image, it says that image must be .png, .jpeg... , my image is .png and it still wont upload it? Has anyone encountered this issue?
-
Connect .rpd Online in Oracle Analytics Cloud
Hi all We use Oracle Analytics Cloud version 12.2.4.0 Could you please let us know if we can connect .rpd online. Created DSN and gave the port as 9704 which we use and gave admin credentials but getting the below error What are the checks i have to do and configure. Could anyone throw some light here
-
Connection to my database on-premise from OAC service
Summary How enable connection to my database on-premise from OAC service Content Hi, I enabled a oac service for data visualization, but need create a new database connections to my site.My question is, How to make a connection from my OAC service, to my on-premise database.I think need the public ip asigned to Compute…
-
Export SQL's query from ODI (with OBIA)
Hi everyone, I have question about OBIA and their ETL (with SQL query) in ODI. I worked on OBIA and at now I want to learn ETL in ODI and source system structure. I know Oracle BI Application in OBIEE layer and rpd. It's better to me learn source system (scheme,table etc.) with ODI (SQL query and ETL with OBIA). Can I…
-
Dashboard with thumbnails
Hi I am using OBIEE 12.2.1.2.0 Is there a way to create a dashboard with thumbnails of another dashboard , when clicked to navigate to selected dashboard. Thx, Matija
-
FUSION Custom BIP Report Output Displaying NULL as in Column , Instead of blank
Summary FUSION Custom BIP Report Output Displaying NULL as in Column , Instead of blank Content Hello We have to pass null values to few columns ,So in data model we are passing NULL as default and same is showing working when we check the data with in data model but we are seeing this as String in report output instead of…
-
ODI 12.1.1.3 - RCU is failing
Hi All, I have installed ODI in windows 8.1 and db is running on windows. when I am creating Master and work repositories through RCU it was failing with below error but able to create repositories through the odi studio. please advise at Sep 8 23:36:29.394 AST 2018 ERROR assistants.rcu.backend.task.ActualTask:…
-
Action links on total
Hi i am using OBIEE 12.2.1.2.0 I have a detail report from my base report and I access it via action link, I have an option to enable drill on totals. However, when i tick this the detailed report gives me correct values and it passes al needed parameters but when i click on the Grand Total level (total of whole analysis)…
-
OBIEE Calculated Items
Hello everyone, Background - I'm currently working in Oracle Business Intelligence 12.2.1.2.0. I'm working at converting reports from Hyperion as it is near it's end of life. I'm rewriting hundreds of reports into OBI analyses. I don't have access to view RPD's and am working only in the presentation layer. I'm running…
-
11g to 12c Upgrade: Merging two security stores in 11g to one security store in 12c
We are upgrading from OBIEE 11g to OBIEE 12c. We have two different 11g environments which we want to merge in 12c. Each 11g environment has it's own security stores where roles are different from each other. During upgrade process we first migrated 1st 11g environment and could see all roles in 12c from it. Then we…
-
How to trigger SmartView business rule via VBA
Content My apologies if I am not posting this in the correct forum. The Smartview Forum had a message that it moved and the link took me here. If it's not correct here, kindly send me to the right spot. Thank you! I am fairly new to utilizing VBA in conjunction with Smartview and have a project that I'm not 100% sure how…
-
Bringing data from 2 different data sources
Hi, OBIEE 11.1.1.9.0 I have 2 different Oracle databases. APS database has the Employees information and O&M has the facts. I have created a physical join between "F1 CR ALL DETAILS" to "Employees" on EMPLOYEE_NUMBER being the key. In BMM, I brought both D10 Employees and F1 CR ALL DETAILS in a single BMM and so also in…
-
Materialized View - Accessing through OBIEE
Please forgive me if I have missed this in previous discussions: I am currently on the 11.1.1.9.0 Version of OBIEE, and am a novice in the system. My team has created a Materialized View for me in the RMI Database. They have enabled Query Rewrite, and it is now my job to get OBIEE to read this view instead of the base…
