-
OBIEE 12C: AGENT FAILS WHEN USING CONDITION & HTML CONTENT
Hi All, I am getting below error message with Business Intelligence Server Enterprise Edition – Version 12.2.1.2.0 after I have scheduled a BI Agent with an Answer than contains HTML code(In column formula) and agent delivery content is a conditional analysis. I spoke to admin team and got required privileges. But still I…
-
OBIEE end user guide for dashboards
Hello, Couldnt find an end user guide for obiee dashboards . How to view data, Export data Use prompts etc.
-
BI
Summary BI Content I am generating an analytical report of Oracle BI, when executing it, three columns do not bring information, but when I consult that cube if it shows me information, could you help me?
-
Change rtf report tempalete to Legal size
Summary Change rtf report tempalete to Legal size Content Hi All, I've a BI API for word installed now i am using the BI Publisher ribbon(hosted in word office) to update/modify to make the default print from "Letter" to "Legal" for this particular report/template . All data binding work correctly but the default paper…
-
Printing Rich Text Format in XML publisher report
Summary Printing Rich Text Format in XML publisher report Content Hi All, Our requirement is to print Rich Text Format in XML publisher report. Basically we are storing Rich Text format data in clob type column in database and data is being stored something like below. We are fetching this data and printing into XML…
-
How to sum a number on the retrieved value on chart xsl
Summary How to sum a number on the retrieved value on chart xsl Content How to sum a number on the retrieved value <RowLabels> <Label><xsl:value-of select="YRE"/></Label> </RowLabels> <Label><xsl:value-of select="YRE"/></Label> retrieved value 2019 i want it to be 2020 <Label><xsl:value-of select="YRE + 1"/></Label>
-
Report Taking long time to run
Hi All, Can anyone explain me about tag below in details.When i can add this in instance config file. <Cube> <CubeMaxRecords>100000000</CubeMaxRecords> <CubeMaxPopulatedCells>100000000</CubeMaxPopulatedCells> </Cube> I have one issue like in my report only 344 records which is running fine when i ran that in…
-
Agents
Hello Experts, I have a question here. Am trying to schedule a report which has 100 rows on it and i did that it is working fine. From past 2 weeks we are having DB issues. Now the user is asking us to get the error message when report fails to his/her email ? Can we do this in OBIEE 11G or 12c ? Please help me out here.…
-
DVD - Our internal internet connection appears to be preventing Maps from rendering
Summary DVD - Our internal internet connection appears to be preventing Maps from rendering Content Using Oracle DVD 12.2.4.0.0. The map layers are not rendering on our network. We get the following results when trying to plot latitude and longitude coordinates using the different map types: Thematic - The coordinates…
-
OBIEE 11.1.1.7
Hi, I'm having a problem with one of my facts. If I add another fact to my analysis. Aggregated data is wrong (reproduced) for this fact ... I have recreated this fact in the repository, the problem persists ...
-
Straightforward way to implement Multi tendency with OBIEE 12.2.1.3.0
Hi, My question is regarding OBIEE 12.2.1.3.0. Can I configure Multi tendency? Is there any Straightforward way to do that? Thanks.
-
Table Name for Calender Events Geographic Tree in Fusion HCM
Summary Table Name for Calender Events Geographic Tree in Fusion HCM Content Hello Gurus, I have a requirement to develop a report which will show Calendar Events (Public Holiday) specific to a Geographic Tree Country (New Zealand). I am able to fetch data for Calendar Events but for Geographic Tree country I am not able…
-
conditional page breaks in BIP excel template
Summary conditional page breaks in BIP excel template Content Hi, I have a requirement to insert a page break whenever the category changes. I observed that this is possible by using excel template, but I need to use this in excel templates. That would be a great help if anyone has a solution for this. Thanks, Srikanth.
-
HR/ Manager Dashboard
Summary HR/ Manager Dashboard Content hi guys, Currently, dashboards are not in strong use in our company. There are some available, but only a few people use these. This is mainly because of the route that managers/ Global HR teams have to use to get to the desired report. E.g. Navigator - Reports & Analytics (new page…
-
Problem starting all components of OBIEE 12.2.1.3.0
I have installed OBIEE 12.2.1.3.0 on Windows environment. After installation I configured it using C:\Oracle\Middleware\Oracle_Home\bi\bin\config.cmd Than I used C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bitools\bin\start.cmd To start all server. Everything is started. But I can't see Analytics or…
-
Migrating Identity Store (Users/Roles) between OAC instances
I am not finding any documentation on how to migrate Users from one (existing) instance of OAC into another (new) instance of OAC. I believe I should be able to create a CSV download of the Identity Store (Users/Roles) from OAC so that it can be imported into a new instance of OAC. In my new OAC instance, under…
-
How to Implement Digital Signature using the Oracle XML publisher
Summary How to Implement Digital Signature using the Oracle XML publisher Content Hi Gurus, We have a requirement to implement digital signatures in the XML report output(PDF) . We use the BI Publisher Word Add-In to create the templates. I would like to know how to accomplish this requirement in Oracle 12.1.3. Appreciate…
-
File Upload Failed Invalid - type-options-xml provided
Summary File Upload Failed Invalid - type-options-xml provided Content I am trying to upload a simple CSV file. The load fails with: File Upload Failed Invalid type-options-xml provided The file looks like this: $ head -2 sigo_cleaned.csv ADES_NOMBRE, ADES_APELLIDO1, ADES_APELLIDO2, TIPO_DOCUMENTO, ADES_NUMERO_DOCUMENTO,…
-
DVDesktop-12.2.4.1.1.exe does nothing
Summary DVDesktop-12.2.4.1.1.exe does nothing Content http://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html Is there a trick to getting DVD Desktop to install on W10. I had it on my old W7 laptop, but I had to change my laptop. I have downloaded it…
-
Reg: MUD for single SA
Hi All, As we are in initial stage in developing RPD , as of now we have 1 subject area working by few teams. Can we implement MUD(multi user development) for a single subject area can anyone suggest on this and steps for implementing. Version : OBIEE 11.1.1.7.1 Thanks,
-
Unable to display iframe in OBIEE dashboard
Hi, Currently we have an issue when upgrading from obi 11g (11.1.1.9.1) to 12c (12.1.2.1.0). As part of 11g, there is an iframe on obiee dashboard which links to an external application (Oracle apex 4.2.4). Post upgrade to 12C, we have default restriction to block external content. I have gone through oracle documentation…
-
Presentation Variable for Prompt using "Between" operator
Is it possible to create a variable which gets the value of just the second part of a prompt using the "between" operator? e.g. in the below screenshot, when the users selects a week ID range between 2018-02 and 2018-06, the variable should have the value '2018-06'
-
MySql database connection with Oracle DVD
Summary MySql database connection with Oracle DVD Content I use MySql Community Edition ...It fails to save the connection when tried to connect to Oracle DVD ..Is there any other way to connect to Oracle DVD and fetch the tables? Or is it web services can be accessed via Oracle DVD? Do give some ideas
-
How can I schedule a burst in BI Publisher for an email to include an attachment in Excel format and
Summary How can I schedule a burst in BI Publisher for an email to include an attachment in Excel format and not receive a warning when opening the attachment? Content In BI Publisher when I set my bursting definition to 'EXCEL' as the 'OUTPUT_FORMAT' and my Report Output Format includes 'Excel (mhtml)' the email appears…
-
RTF and XSL Template under same RD - PDF and XML output format for R42565
Summary RTF and XSL Template under same RD - PDF and XML output format for R42565 Content Good morning all, I would like to know if it is possible to have double output format for the invoices with BIP. Now I have a Report Definition connected with XSL Template, because for eletronic invoices we transform JDE XML into…
-
BIP Bursting to DFS
Summary BIP Bursting to DFS Content Hi all, Is it possible to reference a mapped SAN share in a bursting definition. For example, in Production, we have a share that can be accessed via \\prod\obiee$ and on the application server that OBIEE is installed, it's mapped to Z:\. In Development, our share can be accessed via…
-
Text file as a Datasource in obiee12c
Hi, Can we have text file as a data source in OBIEE12c ? if its possible , how this will work in case of incremental load. Thanks Raj
-
OBIEE 12c System Default Settings - Prompt and Downloads link
Dear OBIEE experts, I'd be grateful if you can help me answer these 2 questions: 1. The downloads like after each report. I have a requirement to move it on top of the report rather than at the bottom. Can we do that ? If yes which system files and what needs to change in them ? Thanks in advance !! 2. The prompt : The…
-
Trouble finding the RCU schemas in OAC
I have created a new database in Storage Classic, and then installed OAC and pointed to that database. Let's say that the IP address for that database is 123.456.789.012, and the OAC instance is 234.567.890.123. One of the options in the OAC installation is the Schema Prefix, in which I entered OAC01. I created a SQL…
-
Data as subject area?
I heard there was a means of using a file as a subject area in 12c, anyone point me in the direction of it please?
