-
RPD Errors - "is not associated with any table(s)."
Hi All, I need to fix two RPD errors, as part of an upgrade we are doing. I found the specific errors in the upgrade logs and was able to trace them back to one of the RPD's it was patching/merging. Business Model Core: [38120] Dimension '"Core"."SIA Instructor Snapshot"' is not associated with any table(s). [38120]…
-
variable for grouping in rtf template
Summary group data accordingly to variable value defined by user Content Hello, I have an rtf template(attach) and i would like a dynamic way of grouping it´s data(attach). If i give user a single choice dropdown to select the grouping i need the rtf template to be able to assign the variable to the <?for-each-group?>. Is…
-
OAC will Support RPD ?
Hi Team, If i opt for the OAC Trail version how can i upload my RPD? Can you please share the steps . I have already installed the DVD in my local system, if i want to upload the RPD will it allow or not. Please let me know. Thanks for your help.
-
How can i get SQL from 'table type -select' AdminTool?
Hello So we have a huge instance of OBIEE. With many tables in view of AdminTool. I want get SQL text from 'table type -select' of AdminTool automaticaly. I try Catalog Manager for this ..but useless. How i can do this? Can you help me
-
OBIEE 12c integration with JDeveloper 12c
Is there any resource available which can walk me through how to integrate OBIEE and Jdeveloper to built custom reports and dashboards ?
-
Dashboards migration
Hello, Is there a way the migrate Transportation Intelligence reports (Oracle BI ) from one environment (DEV) to another (TEST), in a cloud environment ? Regards.
-
Duplicate post
Please ignore
-
OBIEE 11.1.1.9 inline prompts
I have a problem in using inline analysis prompts on some larger datasets. Larger I mean 200+. When ever I try to use an analysis column as a table prompt by drag&drop it into "Table prompts" and this column has more than 200+ distinct values I get and error : "Error Codes: IRVLJWTA Location: saw.httpserver.processrequest,…
-
Compound View Layout in OBIEE 12c Anaswers
Hi , I have created a report which has Compound Layout and Compound Layout :2 , Compound Layout:2 has the Original Report View. When i Publish this report into Dashboard by default it shows data or results in Compound Layout 1 but I wanted to Display Data or Results in the Dashboard as the Compound Layout:2. Inorder to do…
-
Action required in BI publisher 11g ? when database upgrade from 11g to 12c
Content Hi, Currently we have the oracle BI publisher 11.1.1.9 which is using database 11.2.0.3 for RCU creation and business related data's. Now our DBA team planned to upgrade the database from 11.2.0.3 to 11.2.0.4 or 12.1.0.2.0. My question is , Do we need to upgrade our RCU schema's once database upgrade or no changes…
-
Insufficient Permissions when using Visual Analyzer in OBIEE
Hello All, We have OBIEE 12.2.1.2.0 integrated with EBS 12.2.6. Once we login to OBIEE through EBS and click on new 'Visual Analyzer Projects' it asks for login details. When we enter the EBS user id (which we also created in weblogic) and login , it gives below error. Please provide any suggestions to make this work.…
-
OBIEE 12c - Object Level security on Dashboard homepage based on Image Links
Hi All, I’ve five dashboards and contains multiple pages and created dashboard homepage with 5 images linked to dashboards. When the user clicks business images it will be navigated to respective dashboards.I placed 5 images into different sections in the new dashboard, we have three application roles based on these…
-
Setup for row limit when download results to CSV
I have requirement to expand number of rows when download report to CSV file in OBIEE 12c. As I have noticed it is set in two places: Enterprise Manager -> Business Inteligence -> biinstance -> Configuration -> Performance Maximum number of rows processed when rendering a table view option…
-
BI Publisher 11g errors with "A parameter name contains ... is not allowed"
Summary A parameter name contains any of the characters (~, !, #, $, %, ^, &, *, +, `, |, \",\', \\, <, >, ?, ,, /) is not allowed. Content This happens when I add the sql to the edit box. The SQL has been tested verbatim outside BI Publisher, parameters were part of the data model before the current change, any hints…
-
How to download latest CPU patch available for WebLogic 10.3.6.0 and OBIEE 11.1.1.7
Please provide me steps and required path location where I can download all the required patches for OBIEE 11.1.1.7 and WebLogic 10.3.6.0 . Thanks
-
Use value from one column in another column
Hi, Oracle Business Intelligence 11.1.1.9.0 In one of the column for my Analysis, I have a complex formula which also calls a database package function using EVALUATE. I want to add another column with some CASE WHEN condition based on this first column. However for this second column, when I go to the "Edit Column…
-
Obiee Waiting Problem
Hi, Our obiee analytics system has a trouble since 2 days. When I click any object or button on the page, it waits many seconds and then F12 logs say following warnings and we could not find any solution. Pls help me. What do you suggest? Sync load common/privileges.xml obips.ResourceManager.js:1:1846 Synchronous…
-
Where the table is used? (What reports are using determined table)
I have many reports developed by many users in the company OBIEE system. What i need is to find what reports are using determined table/column. Example: The table FACT_COMPANY is used by: REPORT_1 *Second Tab REPORT_2 *Detail Tab Etc...etc.... How can i find that?
-
Date issues
Hi I have a report When export in to excel 2207 its showing values are wrong, the export via Excel 2007 => All dates on or prior to 1969-12-31 are set to 1969-12-31, Could you please let me know about this issue Colum : date column, report is fine when you export then only problem. Thanks in Advance
-
How to increase the page width of PDF
Content I have RTF template and create a PDF by using this template. In the template there is table and in the same table columns are dynamically increasing. We need to increase horizontal scroll bar if table column count dynamic increasing. Any idea how to increase the page width?
-
BI Publisher Auditing Issue
Summary BI Publisher Auditing Issue Content Hi all, I configured BIP Auditing by following the steps; (version 11.1.1.6) Enabling Oracle BI Publisher Auditing - Part 1 - Boxfusion Consulting Enabling BI Publisher Auditing - Part 2 - Boxfusion Consulting everything looks normal, datasource connection works successfully etc.…
-
Data model using ApplicationDB_HCM
I'm trying to write a SQL query from the ApplicationDB_HCM data source, because the obiee data source is limiting my reports, my company hasn't gone live yet so the OBIEE data source is limited to whatever test information they have placed in the environment. I need to be able to select from the other database in my query…
-
Zoom in on "TB Last" on Essbase
Summary Zoom in on "TB Last" on Essbase Content All my level zero balance sheet accounts should have a Time Balance Last (TB Last) tag. I have recently discovered some accounts are missing this tag. Is there a way i could zoom in on the my level zero balance sheet accounts with the TB Last tag, and compare them to those…
-
OBIEE Mobile App Development
Hi guys, I am creating my app for the first time. I want to ask is there a way to clone an analysis that i have created on MAD? I also want to ask how to add date range parameters for the user.My objective is to allow user to select a from and to date for its analysis to work. Regards,
-
Why do I get this error for pivot tables but not standard tables?
Hi All, I've come across the 'Exceeded configured maximum number of allowed input records.' error quite a few times now. However, it only seems to be when I use pivot tables. Why would this only happen with pivot tables and is there a way to bypass this error other than applying additional filters to limit the results? I'm…
-
How to transfer an analysis from OBIEE to OBIEE Mobile App.
Hi All, I have created an analysis and I want to migrate that same analysis on the Mobile App. Is there any way or a reference document I can refer to? Regards Farrukh Nasir
-
OBIEE Agent add email recipient option is not visible on user other than weblogic
Hi Guys, I faced an issue. I was trying to create an agent using a normal user. I cant find the add email recipient option in it to add a local email. I find this option available at weblogic user. Regards Farrukh Nasir Siddiqui
-
Error BAR-00005 in exportServiceInstance OBIEE 12c
I am using OBIEE 12.2.0.1.0 and I want to use command on wlst like exportServiceInstance. I have installed my OBIEE instance on Windows Serwer 2012. I am workin in wls:/offline First I use read domain: readDomain(' ..../bi') Next a I want exportServiceInstance with command…
-
Convert this filter to sql in obiee
Hi everyone, How to convert this filter to sql in obiee, when we use between filtre? I want convert this sql field number. I couldn't find the proper snytax. Screen shot is below. Can you help me? Regards, Merve
-
OBIEE 12c Excel download Issue
Hi All, We are currently using OBIEE 12.2.1.4.0. We observed that when a dashboard is exported to excel, an "Errors" sheet is added to the downloaded excel sheet. Please find the attached screenshot. Has anyone come across this issue? Please let me know how can it be fixed? Thanks!
