-
Issue with Full Outer Join in OBIEE Physical Query
I am trying to build a report with multiple fact columns. The report generates two physical queries and then does a full outer join dimension columns as below - SAWITH0 D1 FULL OUTER JOIN SAWITH1 D2 ON SYS_OP_MAP_NONNULL(D1.c2) = SYS_OP_MAP_NONNULL(D2.c2) AND SYS_OP_MAP_NONNULL(D1.c8) = SYS_OP_MAP_NONNULL(D2.c8) AND D1.c4…
-
Connection Test Failed(DB Authentication)
Hi Team, I'm trying to do DB Authentication in OBIEE 12c but I'm facing below issues so please guide me to configure DB Authentication in OBIEE 12c.I'm able to connect DB through SQL developer. Message icon - Error Connection test failed. Message icon - Error IO Error: The Network Adapter could not establish the connection…
-
different header part in every 2nd , 3rd and last page
Summary different header part in every 2nd , 3rd and last page Content Hi All, I am developing EBS rtf template to print in PDF output. So ,i need to display different header part in every 2nd , 3rd and last page. how to do this ? Thanks
-
Install R Advanced Analytics for DVD in MacOS High Sierra
Summary Install R Advanced Analytics for DVD in MacOS High Sierra Content Hi guys, I am executing Oracle Data Visualization Desktop Configure R.app to install the R option for DVD on a MacOS High Sierra but it does not seem to work. I have installed R 3.2.1 and have installed all the required libraries for some of the…
-
Fusion integration with bics stored procedure problem
Summary Fusion integration with bics stored procedure problem Content I have an issue in working with fusion with bics i follow this link :http://www.ateam-oracle.com/integrating-oracle-fusion-sales-cloud-with-oracle-business-intelligence-cloud-service-bics/ but i always face error in the last step ORA-01403: no data found…
-
Busiest Airports sample fails when filter is set to TOP 20
Summary Busiest Airports sample fails when filter is set to TOP 20 Content I downloaded the "Busiest Airports" example project and ... it failed: all visualizations fail with this error. Error generating view. Error getting cursor in GenerateHeadOdbc driver returned an error (SQLExecDirectW).State: HY000. Code: 10058.…
-
How to create a Data Connection with Eloqua E10?
Summary How to create a Data Connection with Eloqua E10? Content What is the best approach to using the the Data > Create Connection workflow to linking our Eloqua (E10) install to Data Visualizaiton Desktop? Oracle Eloqua Support unable to assist.
-
OBIEE 12c - Port 80 Configuration in UNIX
Hi, I have configured port 80 in OBIEE Unix using when I log into analytics root.atr, logs are pointing root user. I started services following order. 1. NodeManager - sudo ./NodeManager.sh 2. WebLogic - started with Normal user 3. BI_SERVER1 - Start in Console 4. OPMN - started from EM When I tested sawserver is pointing…
-
Configuring SSL on OBIEE 12c cluster
Hi all, I am having some trouble getting SSL configured on a 2-node horizontally scaled cluster. I have followed a guide by clearpeaks (https://www.clearpeaks.com/configuring-ssl-obiee-12c/ ) and have had to work out a bit for myself given the guide is for a single node install only. Steps Followed I have created a new…
-
BI publisher (Pixel perfect publishing in OAC) against Essbase
I looked through the forum but did not see anything I could use. Is there a good tutorial or blog on creating BI Publisher reports(or OAC-Pixel Perfect reporting) from an Essbase (OAC) source. Thanks Glenn
-
OBIEE multiple row values in one row
I am trying to find out a solution where I can get the next three values of a column and add them in another field within the same row. So I found the LISTAGG function but its not working for me. Here is the function that I am using: CAST(EVALUATE_AGGR('LISTAGG(%1,%2) WITHIN GROUP (ORDER BY %3 DESC)',"Measures"."Strm",',…
-
How to remove one of the alternate hierarchy in rpd
I have 2 hierarchies in calendar logical dimension. Both Gregorian calendar and fiscal calendar share the same lowest level which is day level. Now I want to remove the Gregorian calendar from this alternate hierarchy. The issue here is that once you remove the Gregorian hierarchy, the day level in fiscal calendar…
-
Pie chart: no number format and topN yields odd legend
Summary Pie chart: no number format and topN yields odd legend Content Hi, We're using the online version of Visual Analyzer 12c. We created a simple pie chart with one fact and one filter. Then we added a TopN calculation: TOPN("Total number of incidents", 5). The only way to obtain the correct results is to have the…
-
Dynamic Linking in BIP
Summary Dynamic Linking in BIP [Supported in Layout View (Not RTF)?] [BIP 11.1.1] Content Hello, I was trying to create two reports, with a link in one that passes to the other, based on multiple parameters in a row. I've realizes you could do this via RTF templates, utilizing something such as:…
-
BLOB image in repeating groups
Summary BLOB image in repeating groups Content I am trying to generate a table report for all the employee with their photo. I am using rtf template. The query is like below- select EMP_ID EMP_ID, EMP_NAME EMP_NAME xxgetbase64(EMP_PHOTO) PHOTO, from hr_emp_mstr; in PHOTO field i use code <fo:instream-foreign-object…
-
Bulk remove projects, data sets, connections etc
Summary Bulk remove projects, data sets, connections etc Content Hi experts, Is there a simple way of bulk removing content from DVD v4? I can only find a way to remove data sets, connections, projects, data flows etc one by one. This is very time consuming. I tried uninstalling DVD and installing again but all the content…
-
Column Width Not Displaying Properly in RTF
Summary Column Width Not Displaying Properly in RTF Content Hi All, I have a report in Ms. Word RTF format that require the data to be printed horizontally and I managed to do that. The only problem is the width of the column cannot be fixed even when I have set it to Fixed Column Width. This is what it supposed to be. And…
-
I have an rtf template, where a table has 6 fields to display in each column. If the first two field
Summary I have an rtf template, where a table has 6 fields to display in each column. If the first two field have repetitive data, it has to be displayed only once in each page. Content I have an rtf template, where a table has 6 fields to display in each column. If the first two field have repetitive data, it has to be…
-
how to create an administrative report
Hi all, Is there a way to create a report that shows when a report or analysis was created in OBIEE 11g and list of agents that run successfully during a time period?
-
Not able to fit values into bar charts
Hi All, I opened a few days ago ... which was answered accordingly. I now have a follow-up to it ... There are some graphs/bar charts which don't display enough visible area to fit any values (very small "slices", proportional to the other columns). What are some of the options we have to show some kind of a value for…
-
Please Help - Action Services Taking Long Time
Hello, I am working in a large supply chain management project. We have used Action Links in our reports where a report is connected with another one via Acton Link (Navigate to Web Page). There are few reports where it is taking lot of time for Action Link to appear. This is what happens: 1) Open Report 1 2) Select the…
-
How to adjust X axis scaling in line graph OBIEE
Hi All, I have such type of line graph where extra space is coming along X axis after Feb'18. I want the line to end at Feb'18 and remove the extra one. I have tried some options in Graph Properties to do so, but not able to achieve this yet. Can anyone please help me regarding the same? Thanks, Dolly
-
Analytics page not displaying properly for Oracle business intelligence enterprise edition 11.1.1.9.
Hello Experts, We are facing issue with the OBIEE analytics after logging. We have applied latest OBIEE patchset bundle 27281232 (11.1.1.9.180116) one of our environment (version: 11.1.9.5) as recommended by Oracle. Oracle suggested to apply this patch to current environment to resolve known/unknown bugs fixes and we are…
-
Unable to create connection with Hyperion Planning 11.1.2.4 in OBIEE 11.1.1.9.5
Hello all, We are facing issue while trying to create connection with Hyperion Planning (11.1.2.4) using OBIEE RPD 11.1.1.9.5 . As Oracle recommended we have already tried below steps to resolve this issue but still issue persist. 1. Copied and test for HspAdm.jar, ap.jar & HspAdm.jar files from Hyperion planning…
-
Why VA asks for username and password again even after I logged into OBIEE 12c?
Summary Why VA asks for username and password again even after I logged into OBIEE 12c? Content Why VA asks for username and password again even after I logged into OBIEE 12c?
-
Configure Dedicated bi server for Specific Folders in catalog
Summary Configure Dedicated bi server for Specific Folders in catalog Content Hi All, We have a requirement to install bi_server3 to allow specific reports in catalog. We would need to allow only the reports in the particular folder in catalog. We should not allow this reports from bi_server1 and bi_server2. Please let me…
-
OBIEE Agents Question
Can we have the current date as part of the file name when it is sent.File name with the date appended to it. I have some new reports for a user he wants to get the reports every Monday and would like to have the date part of the file name just wasn't sure if that was possible or not
-
While trying to run Agents (ibots) getting error
Hi All, I am getting following error while trying to run Agents(Ibots). Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Unknown authentication schema: Impersonate-delivers Error Codes: GPA2Z36E Location:…
-
how to security works in OACS
Summary how to security works in OACS Content Hi, in biserviceadministration , how to assign roles & application roles to groups? Or Do we need to assign roles to all the users on individually basis.
-
OBIEE 12.2.1.3.0 Result of Answers Request in a XML format is incorrect. The Filter condition “is pr
To get the data of the Answers Request in a XML format, we are using URL like these: http://host:port/analytics/saw.dll?Go&searchid=ValuOfSid&format=xml&NQId=ValueOfNqid If the Answers Request contain only hardcoded Filtervalues e.g.City=London, its work fine. If the Filter is changed to “is prompted”, the chosen value of…
