-
Data Visualization Open Forecast Syntax Examples -- there is no package called 'OBIEEAdvancedAnalyti
Summary Data Visualization Open Forecast Syntax Examples -- there is no package called 'OBIEEAdvancedAnalytics' (HY000) Content When I using Data Visualization 12.2.4.0 to open Project : Forecast Syntax Examples, I got following error (please see the last image), and I'm sure I install Advanced Analytics successfully as…
-
unable to generate output xml report
Summary unable to generate output xml report Content Hello, I prepared rtf format and upload in xml publisher template. i prepared rdf and move to server and also updated rtf format with xml data. i registered in application as concurrent request. when running report from application than getting completed with waring and…
-
Integration with RPD
Summary Integration with RPD Content Hi All, We have our custom RPD (OBIEE). We would like to integrate the RPD with Oracle visualization. Please let us know the steps for the same. Thanks & Regards, Prasad
-
Exclude null rows when "Show Total value for all measures on unrelated dimensions" is selected
Hi, I have created an analysis in OBIEE 12c with a pivot table using the feature " Show Total value for all measures on unrelated dimensions" in the Advanced tab. Unfortunately, when I have this option checked, rows with null values are being included in the table even if I don't have the "include null values" option…
-
ERROR when refreshing OBIEE
Hi all, We are currently using OBIEE 11.1.1.7 and utilising SSO authenticating using an LDAP directory. About 6 months ago, we noticed a strange error whereby sometimes if you opened the OBIEE URL, you would face the following error: If you hit refresh, OBIEE will load as expected. After some more investigation, it seems…
-
Obiee 12c creating analysis
Hi , I am new to obiee and having trouble creating an analysis based of a dimensional database. I have one table that holds all the column row values I want to match to the total number of employees that fit that category. ie : the field Description has the following data in it grad degree , undergrad degree, some college,…
-
Dashboard Prompt displays Year in State field
We have a dashboard that when brought up the first time, displays the year (2019) in the State prompt as a default. The report on the dashboard associated with the the prompt errors giving invalid number error. The value of 2019 is not a valid selection. I have no idea where it is coming from.
-
Create BIAuthor like Role without Delete privilege on Shared Folders
Hello, We are using: Oracle Business Intelligence 11.1.1.7.150120 Recently we had an event where a user with BIAuthor role accidentally deleted a sub-folder under Shared Folders. I want to prevent this from happening in the future. How can I create a role which allows the user to create new Analyses and Dashboards and save…
-
OTBI - calculate YTD
can you give me an example or formula to do a YTD or YOY or MTD calculation when building a report? or a link with this information
-
Agent Dashboard Page-Grand totals Wrong
Hello I have created an agent for Dashboard page to send an email. Everything is fine but the grand totals are not right in the file that got emailed through agent.Is there any way we can see the Agent SQL log that generated? Also this issue is intermittent. It is getting wrong total for the first time. Re-running the…
-
Referenced Catalog Object Inaccessible
I have an analysis on a dashboard page. It has worked great in the past. But recently, the analysis does not display and I open the page. When I edit the dashboard page, I can see the analysis listed there. However, there is a "!" icon next to the name. When I hover over the icon, I see this message: "Referenced Catalog…
-
Column Heading to be displayed for facts on Pivot table
Hi, I am trying to get column headers for facts on Pivot table but cannot find a way to do it. I do not want to use unions as I have over 50 reports and excluding the drill down reports and that might cause the server to crash. Can anyone help? I need to have the formatting as in the Table view to the Pivot table view. If…
-
OBIEE Hints from Answers
One of our report query needs a performance improvement. While analyzing all the indexes and data model design the only option left to use database Hints (Parallel) as it improves the query performance by 50%. We did not want to add hint at the RPD physical table as it will change the Optimizer plan for all the reports. Is…
-
BI Publisher- Repeating Section and Running Total
Summary BI Publisher- Repeating Section and Running Total Content Hi, I am designing a slide deck using BI Publisher. I am running into issues with using the repeating section and running total on my line graph. Basically I have the planned costs and actual costs for my projects by month and I want the graph to show a…
-
Unable to connect to Oracle Database
Summary Unable to connect to Oracle Database Content Hello Everyone, I Started to use DVCS , unfortunately I am unable to connect to an Oracle Database. When I try to add a data source, I enter my database connection information., Click Save, takes about 4-5 minutes and eventually ends up saying: Failed to save the…
-
Import of several identically structured CSV files
Summary Import of several identically structured CSV files Content Hi all, I would like to create several data sets from CSV files in ODVD that share the same structure (same number of rows, same row naming, same row sequence etc.). When importing the first file, I can define if the row is threaten as measure/attribute,…
-
[nQSError: 82095] All recipients rejected by the mail server
I am getting the following error when OTBI agent completes. The agent completes but fails to send email to recipient.T he current version is on OBIEE 11.1.1.9 The Agent, manish-test, has completed with warnings. Eventually succeeded, but encountered and resolved errors... Number of skipped deliveries: 1 of 2 AgentID:…
-
OBIEE Prompt Limit value through SQL script
I want to create the script (Within prompt )so that I can limit the values of employee location name as per employee location country. I have created the below mentioned script however the script populate the country name instead of limiting location name as per country. SELECT Distinct"Employee Location"."Employee…
-
Hierachy prompt - how to hide catalog option
OBIEE version 12.2.1.2 - I have built a hierarchical prompt on a parent-child hierarchy. Is there a way to hide the Catalog option ( see image) seen in the search dialog of the prompt? I understand it is pretty harmless if there is nothing to select in the Shared Folders selection but it does expose the shared folder…
-
Hierachical graph drilldown return link option
Hi, With OBIEE 12.2.1.2, I have created a report using a parent-child hierarchy -similar to the "Value Based (Parent Child) Hierarchy" report in SampleApp V607 (Dashboard - 6.10 report building features). I have created a vertical bar graph view which allows parent -> child drilldown on clicking any parent bar. However I…
-
OEM Reporting
Summary OEM Reporting Content Hello All, We are going to schedule backup status tablespace utilization report using BI publisher in OEM. 1) Backup Report : We are working on scheduling backup status report for last 24 hours, for this we used mgmt$ha_backup view, but it contains only recent backup status instead of last few…
-
getting error while configuring Map Viewer
Hello Expert, I am getting error in Map report. I have went to mapviewer admin console and tried to check the logs present over there and getting below error oracle.sdovis.ds.NativeOracleDataSource <init> SEVERE: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of…
-
BI Publisher engine failed to generate report.(SBL-RPT-50524)
Hi Team, followed oracle step by step procedure document to Integrate BIP 11g with Siebel IP 13, getting following error while generate sample xml from "Sample Data File Generation View" even have set EAITransport folder parameter at Enterprise & Component level. to sli 1][0] Error writing XML to file…
-
Changing column separator format from column to semi column when delivering CSV content
Hi Guys, Wondering if you can help with this. In OBI 11g, how can i change the default column separator format in the CSV file from column to semi column? When I download the file manually it is not a problem as I can replace in notepad the , with ; , but when sending a report via agent is annoying. Would you have any…
-
Choice list filter with display and return value
Hi, Is there a possibility to create a “choice list” filter with a return value that differs from its display value. For example we have some date filter with the following options: Display Return 3 months ago 90 1 month ago 30 7 days 7 1 day ago 1 (Arguably, the first 2 values should be calculated.) In the create filter…
-
Repeat content in Header
Summary Repeat content in Header Content Hello, I'm working on a report where I need to have a barcode (amongst other content) that repeats itself on all the pages in the header. The thing is that this used to work before because I had this structure : "content to be repeated in header" <?start:body?> "content not to be…
-
Reduce size of content in template header
Summary Reduce size of content in template header Content Hello, I have a repeated header in my template and the barcode is huge which prevents me from making the display I want : The code behind this barcode is <?format-barcode:SHIPMENT_XID;'code128a'?> and the size of the "code 128" font is 24 and it appears quite small…
-
Quality Tab and Related Tab Missing
Summary Quality Tab and Related Tab Missing Content I have the Inspection of the Model missing tabs, Quality and Related. How to fix that?
-
current_date auto change when it's Monday
hi all, I have a question about how to change the current_date, I used CURRENT_DATE-2 to get the data, however, I wounder can it auto update to CURRENT_DATE-4 when it's Monday for example, in R , I will try like this : if(weekdays.Date(Sys.Date())=="Monday"){ datadate <-Sys.Date()-4}else(datadate <-format(Sys.Date()-2)…
-
R packages installed failed after V607 SampleAPP deployment, any suggestion?
R packages installed failed after V607 SampleAPP deployment, any suggestion? I execute install_sampleapp_R_packages.sh, but got an error while installing arulesviz. Thanks, John
