-
Create a data source
Summary Create a data source Content When I try to create a data source using a file the application is crashing. I did create 2 data sources, I deleted them and from this point I cannot create a new one. It crashes every time.
-
Oracle BI Publisher Burtsting Reports
Summary Oracle BI Publisher Burtsting Reports Content Looking for documentation to setup bursting in Oracle BI Publisher to burst and send report by email.
-
Odata connection failure
Summary Odata connection failure Content Hi, I am attempting to create a connection with ODATA. When I enter my credentials, I get a "Failed to save the connection. Invalid username/password." error message. (Yes, I am typing in my password correctly ) The username that I need to enter is a companyid\userid from the cloud…
-
BI report PDF output
Summary BI report PDF output Content when trying to create the template in RTF what bothers me is when I create RTF and generates report and view in PDF my header looks unorganized. and how can I sort all it out in PDF view
-
OBIEE disable internal stitch
Hi all, We have OBIEE 12.2.1.3.0 and Oracle 12c as database and we would like to avoid internal stitch if possible. In Administrator tool on database features tab we have configured following: FULL_OUTER_JOIN_SUPPORTED - true WITH_CLAUSE_SUPPORTED - true PERF_PREFER_MINIMAL_WITH_USAGE - false…
-
Disabling dashboard path at bottom of screen
Hi all, Quick question: does anyone know if it is possible to disable this path of previously accessed dashboards in OBIEE 12.2.1.0.0? I've not been able to find anything so far on doing this. Many thanks in advance
-
AD Provider for OBIEE 12C
With OBIEE 12C, there are 2 new providers added to the list. What is the correct order of these providers? Trust Service Identity Asserter DefaultAuthenticator DefaultIdentityAsserter DCIADProvider DCIADProvider is the AD provider that couple of AD users are running into login failure. Thanks!
-
Supplied sample XML file does not allow bursting
Summary Supplied sample XML file does not allow bursting Content I have used bursting before, and I am stumped as to why I am getting this error: "Supplied sample XML file does not allow bursting" What are the reasons that my sample XML file won't allow bursting. I did make MINOR modification to the query - and I…
-
Oracle DV connection to Essbase
Summary Oracle DV connection to Essbase Content Hi, I'm trying to connect Oracle DV to an on premise version of Essbase but cannot seem to return any working reports. I notice the user guide states supported data sources include Essbase 11.1.2.4.0+, however we are currently running Essbase 11.1.1.2.1 (upgrade scheduled…
-
NQSError 17003 :Oracle gateway error: Unsupported data type 188
Hi Guys, I have a Table with USERDATE as column whose datatype is TIMESTAMP WITH TIMEZONE in database I have imported this table in RPD physical layer. When i try to view data of this particular column then i am getting an error which is Unsupported data type. And i have used this column in DDR(Direct Database Request)…
-
Forecast time series function in OBIEE 12c
Hi, I have a forecast function with below formula FORECAST("Sales", ("Year" timeYear, "Qtr" timeQuarter),'forecast','modelType=arima;numPeriods=%1;predictionInterval=70;', 3) And for the highlighted fields above instead of using static values I would like to use a column in place of it. Ex: Product Expiry in periods. So…
-
Table in one row using SECTION
Hi, I created table with on dimension column and thre fact columns. I add another column on section. My table replied vertically - see screen below. It's working ok, but can I set these tables horizontally? Thanks
-
RPD - Duplicate LTS with filter for a new meassure
Hello, I have a fact table in a BMM and i need duplicate its logical table source filtering by a value to calculating a new column (meassure). When i want setting the physical table for my new meassure the new LTS does not appear just appear the original. I understand its happen because both LTS refer the same physical…
-
disable bi publisher .xsl, .xml, .fo, and .out
Summary disable bi publisher .xsl, .xml, .fo, and .out Content Hi, I want to disable bi publisher .xsl, .xml, .fo, and .out getting created on the host server file system. There are thousands of files getting created on the server causing space issues. I disabled the LogLevel=OFF in the xdodebug.cfg that helped in…
-
Flash required for OTBI (expected HTML5 view)
Summary Flash required for OTBI (expected HTML5 view) Content Hi, According to: http://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r12/wn/r12-financials-wn.htm#_Toc475946739 "OTBI graphs can now be viewed in web browsers that do not support Flash Player. The OTBI default graph style has been changed from…
-
Multiple field in a single cell using Excel template?
Summary Multiple field in a single cell using Excel template? Content Hi, We have the OBI bundled with our Oracle HCM cloud service. I'm building a tabular report which uses a parent master data model ie. Employee and Assignments (1 to many). However, the requirement of the report is to have a single cell contain most of…
-
Regroup Data in RTF Template
Summary Regroup Data in RTF Template Content Hello, I'm working on a template with data that I want to regroup when it is similar. Example of what I currently have : I would like to regroup the quantites for SLI---2112 and the quantities for SLI---0770 in order to have only two lines in the synthesis. Fyi, I currently in…
-
Permanently Hiding Side Panels
Summary Permanently Hiding Side Panels Content Hello all, I am doing some work on Data Visualiser V4 and I was wondering whether it is possible to "hide" the side panels (i.e. Data Panel, and Viz Grammar Panel) permanently so that a non-developer user can't see them, or access them. I know about the "Toggle Panel…
-
Toggle between analysis on Obiee Dashboard on BICS
Hi , We have hit a problem in OBIEE on BICS where in on the Section properties of Dashboard we don't get the "Condition" option to enable us to toggle the analysis based on condition. We have two analysis and have to display each analysis based on some condition. Is there any other way of achiving this without the Section…
-
Automation of Create report utility of catalog manager
I want a report on analysis and dashboard which shows me what object is placed at which path, which dashboard has what dashboard pages and analysis associated with it. We can do this using create report option in catalog manager. Can we automate that option to run on weekly basis?
-
Computing the Net Book Value for a fixed asset: Querying a Table column or creating external calcula
Summary Computing the Net Book Value for a fixed asset: Querying a Table column or creating external calculation -BI Publisher Content Hi, I am trying to use the "FA_" tables for fixed assets to create some information at the "date of run" that goes like Asset ID, Asset_Orginal_Cost Asset_Useful_Life, Asset_remaining_life,…
-
Remove decimal places in OBI Dynamic Repository Variable
Hi All, Oracle Business Intelligence 12.2.1.1.0 We have created repository variables for Fiscal Year, Previous fiscal year etc. Query to populate this variables return the correct result in database without decimal place. But when I execute the same in OBI RPD initblock, it appends a decimal place to the result. Also When…
-
Group by on union report
How can we run group by in union all report in OBIEE. My Report generate following query select A1, B1, SUM(M1) from Table1 group by A1, B1 UNION ALL Select A2, B2, SUM(M2) from Table2 group by A2, B2 i want result set to be Select A, B, SUM(M) FROM ( select A1, B1, SUM(M1) from Table1 group by A1, B1 UNION ALL Select A2,…
-
BI Publisher, Data Table, Managing Filters
Summary BI Publisher, Data Table, Managing Filters Content Hello, I have a question about BI publisher concerning data tables and filters. I am trying to filter data out of a table based on dates. If the "Request Date" is less then the "Actual Ship Date" I want to show only the lines in that filter in my data table so that…
-
Write back template error in obiee 12.2.1.0.0
Hello all, Logged in as weblogic and even tried with another obiee admin user. Write back template code <?xml version="1.0" encoding="utf-8" ?><WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1"><WebMessageTable lang="en-us" system="WriteBack" table="Messages"> <WebMessage name="control_table"> <XML>…
-
Union all report - Error Exceeded configured maximum number of allowed output prompts, sections, ro
I have created report using union all of 4 reports. Total count of these four reports is around 600k. I am getting Error Exceeded configured maximum number of allowed output prompts, sections, rows, or columns. Table and pivot view settings seem fine to me. Does union report uses Chart or Cube section of instance config…
-
Go_URL Download
Hi, can anyone tell me if there is a go_url option to download a file to a specific directory and give the file a specific name? thanks, Robert.
-
Action link to report on same dashboard
Hello, I have a dashboard with an overview of an amount of orders per day for the next week. I would like to use an action link to go to a more detailed report on what is going to arrive at a particular day. But I would like the detailed report to appear on the same dashboard and only to appear when I click on a particular…
-
Scheduling of RPD utility
How can i run rpd utility from command prompt? I want to schedule it monthly.
-
Scheduler Service Active-Active Clustering
Hi All .. is it possible to have scheduler service clustered as active-active horizontally? ver. 11.1.1.7.x Thanks
