-
Issue with Datetime @ BI Publisher
Summary Issue with Datetime @ BI Publisher Content Hi everyone! I'm building a DM based on an SQL query which extracts an timestamp value. When I got data from it, the value is shown in UTC format. I need to be shown in my local timezone (America/Bogota -05:00). You'll say "Well! Use the FROM_TZ function!"... The thing is,…
-
BI publisher to Sharepoint using WebDAV. Error in DeliveryServiceImpl.deliverToWebDAV
Summary BI publisher to Sharepoint using WebDAV. Error in DeliveryServiceImpl.deliverToWebDAV Content Hi, We are trying to upload one of our BI publisher report to a Sharepoint site, but it fails with below errors: Delivery failed. [INSTANCE_ID=<host>.1443717846074] [OUTPUT_ID=1196] Document delivery failed…
-
RPD solution
Hi everyone, I have some question about approach to model schema in RPD. OBIEE 11.1.1.9 In physical layer I have model like: One fact table -> join with product dimension --> vehicles dimension has multiple others dimension. Bussines Model and Mapping How to model it in BMM? Which solution should I use? 1. Create model…
-
Integrating OBI reports with webpage
Hi Experts, In OBIEE10g we have incorporated the OBIEE report URL with our existing .net based MIS reports system using the NQUser & NQpassword method as shown in the following URL.The problem with this approach is the password is visible in the URL. Any updates on this in the 11g or 12c version or any other method?…
-
ODI 12c Certified with OBIEE 12c?
Hello, Our BI environment contains the following: OBIEE 12.2.1.3, OBIA 7.9.6.4, Informatica 9.5.x. We want to change Informatica to ODI. Is ODI 12c certified for our current configuration or would ODI 11g be recommended here? Will an upgrade of OBIA 11.1.1.10 be supported with ODI 12c instead? Any insight is appreciated.…
-
OBIEE Reports throws error but after clicking "Refresh" button it works
Hi All Few OBIEE Reports in our system throws error but after clicking "Refresh" button it works. Check1: Try to change something in report and resave the report, this should solve problem if not, try to get same report from previous release,code base or from backup using Catalog Manager bring the report to new development…
-
How to write formula in DV to get similar like sumif function in excel?
Summary How to write formula in DV to get similar like sumif function in excel? Content Hello, Can anyone help me to write sumif formula in DV to get the require output? Not able to get the right syntax/formula in calculation option? Thank you
-
The use of dynamic parameter dates in 12 BIP scheduler
Summary The use of dynamic parameter dates in 12 BIP scheduler Content Hi all, We are in the middle of migrating from OBIEE 11G to OBIEE 12C and have a number of BI Publisher schedules that require dynamic dates using {$SYSDATE()-1$} for example. Unfortunately, this doesn't seem to work anymore. Does anyone have any advice…
-
DV Desktop for macOS - High Sierra?
Summary DV Desktop for macOS - High Sierra? Content Hello, it looks like even the newest release of DV Desktop for Mac 12.2.4.0.0 is NOT compatible with Apples latest macOS High Sierra (10.13). Is there any information available when a High Sierra compatible version will be available for download? Kind regards, Stephan
-
Bug on Windows DVD - Query Live Mode
Summary Bug on Windows DVD - Query Live Mode Content When I try to select Query Mode: Live on DVD for Windows, I can't. Is it a known issue? This problem don't happen on MacOS:
-
Upload XLSX spreadsheet hangs ?
Summary Upload XLSX spreadsheet hangs ? Content Just getting started with DV. The welcome page says i can just drag and drop a file there to get it loaded. So I took a small spreadsheet of about 1000 rows and dropped it on the home screen. Nothing happens: the "Upload File" window just sits there with the rotating wheel. I…
-
Best way to send text output via email
Summary Best way to send text output via email Content Hi All, I have PLSQL stored procedure and displaying output in text format (fnd_file.put_line(fnd_file.output,v_statment1);) Now i want to send this output via email , what is the best approach to send an email? Apps R12.1.3
-
Calling BI Services From External Applications
Summary Calling BI Services From External Applications Content Hi Team, I want to return BI Publisher Report data via web service. Could you please help me on this. Regards, Ramanjaneyulu
-
Bursting control file to loop through the XML, possible?
Summary Bursting control file to loop through the XML, possible? Content HI : Can Bursting control file include a "looping" though the data from XML and put it into email body? Here is my situation. we are in EBS 11.5.10.2 with BI publisher 5. ( yes sorry, very old ) User has a requirement to put the following information…
-
BI Publisher for Desktop Acting Funny
Summary BI Publisher for Desktop Acting Funny Content When I change the borders of a table in the rtf to the way I want them to be, save and upload the template to XML Publisher, it works great. I close out of the rtf and when I open it back up, the borders are back. It's like I didn't change a thing. What am I doing…
-
Exception when running report with CLOB
Summary Exception when running report with CLOB Content Hi everyone, I created a data model that has a CLOB field. I tested the data model from within the BIP web console and it successfully returned data. I then created a report for it directly from the data model page. Testing the "interactive" format from the BIP web…
-
Can we get 'Report Job Id' from Scheduler, In After Data Trigger in Data Model ?
Summary Can we get 'Report Job Id' from Scheduler, In After Data Trigger in Data Model ? Content Hi OBIEE/BIP 12.2.1.3 I have a Report Definition with a Data Model Defined in the Catalog In the Data Model, I created a After Data Trigger to point to a PLSQL Function in a Package. Now, I want to schedule this Report using…
-
How to sum values with condition in current group bi publisher
Summary How to sum values with condition in current group bi publisher Content what is the correct syntax for this : <?sum(current-group()/SUM_COS_COSTED_VALUE_[../DEBIT_OR_CREDIT='C']) - SUM_COS_COSTED_VALUE_[../DEBIT_OR_CREDIT='D'] )?> I want for each CAK_SEGMENT2_ to sum the field (SUM_COS_COSTED_VALUE_) where…
-
Can't run an RTF layout as guest?
Summary Can't run an RTF layout as guest? Content Hi All I have an RTF layout in BIP and placed it and its data model in the Guest folder and enabled guest access. The RTF generates output OK when I am signed in, but when I try to run it as a guest I get the below - has anyone seen this before?? Unauthorized Access: Either…
-
BI Publisher Enterprise Edition merge different output
Summary BI Publisher Enterprise Edition merge different output Content Hi All Siebel calls different output all the day and burstin is working fine I have a requirement: Create a file for all the outputs generated and burst this final file at the end of the day Any idea how to achieve it ? Regards
-
BI Publisher - Detect change of page
Summary BI Publisher - Detect change of page Content Hi all, Is it possible to know or detect that the page has changed in the a report? I have a table generated with a variable number of rows based on the following data: <G_TABLE> <G_ROW> <INFO_1>42157777_1</INFO_1> <INFO_2>Blab bla bla_1</INFO_2>…
-
Oracle BIP - xdo/tmp
Summary Oracle BIP - xdo/tmp Content Hello. At us on the project every day the place in directories xdo /tmp grows. We have to remove files from there and restart the butt. Why would not the Oracle BI remove them? Maybe some cache settings need to be done? Any ideas?
-
Can we make 'XML Search and Replace' conditional ?
Hi, Is it possible to customize catalog manager feature 'XML Search and Replace' to replace certain columns/text only if another column/text exists in the report XML? Basically, I am looking to apply the changes only in some conditions. This is in OBIEE 12c. I looked into all the available options in the catalog manager…
-
Oracle BI: Create an Action Link towards selected value
Hi everyone I would like ask you for a request I have had from the customers I work for. I have a dashboard with three tab, in the first of them there is a summary report and it has got a column (column A for example) on which I have created an Action link which point to the BI content of the third tab. The customer would…
-
OBIEE12.2.1.3 upgrade - Encountered with java.lang.OutOfMemoryError: GC overhead limit exceeded
Hi, We are trying to upgrade OBIEE from 12.2.1.2 to 12.2.1.3 in windows servers. We have followed below oracle documentation to upgrade domain. OBIEE 12c: Quick Reference For Oracle Business Intelligence Enterprise 12c Upgrade From 12.2.1 to 12.2.1.x (Doc ID 2153433.1) OBIEE 12.2.1.3 is failing in reconfiguration wizard…
-
SQL Authenticator Configuration for OBIEE 12.2.1.0.0
Dear All, configuring sql authenticator in weblogic We are trying to configure sql authenticator to authenticate from a db table for that we have completed below steps. 1)Created a datasource to oracle db a)connection tested and succeeded and deployed it to the admin server and BI server as target 2)Created a…
-
How to avoid multiple application roles per user.
Dear All How to avoid multiple application roles per user. Followed the below steps. in Console (weblogic) 1)Created two groups a)SalesReporting b)CostReporting 2)Created two Users a)Created user SalesMan and assigned the Group SalesReporting b)Created user CostAnalyzer and assigned the Group CostReporting In Enterprise…
-
Complex Distinct Sum
Hi guys. I have a table with the following fields/values:…
-
Imported Smart View Table View into Powerpoint with Conditional Formating
Hi All I am just playing around with importing analyses/views from the OBIEE catalog into Powerpoint using Smart View and am quite impressed particularly with charts and the flexibility to format them. My only issue is with tables and conditional formatting. I can't figure out how I can bring a table in and have cells with…
-
Error initializing/loading existing Catalog
obiee- 11.1.1.7. While starting the PS , it throws this error in SAW logs.. Error loading \\?\UNC\NAS_PATH\DATA\prdanl\prod_catalog\EnterpriseOracleBIAnalytics\EnterpriseOracleBIAnalytics\root.atr[[ File:catalogimpl.cpp Line:1105 Location: saw.catalog.impl.read saw.catalog.local.checkforcatalogupgrade…
