Insights (Business Reporter and Analysis Models, EOI)

Hi All, Can anyone please show an example of using NVL2 function parameter in a BR report?  I tried to use NVL but could not get what I wanted. And trying to use NVL2 function parameter, but  not sure what should I enter for the first argument (ValueIfNull). please see the image.&CodeB is a standard parameter for DIM_CODE_B.CODEThe requirement is to get all CodeB values including NULL when the &CodeB leaves blank and the selected CodeB values when &CodeB has a value.Example:when &CodeB = say '45' , the report will only show the records with code_b = 45when &CodeB leaves blank (NULL) then the report will show the records where the code_b of any value plus the code_b IS NULL  Thank you!

Hello Community, I have 2 questions about ifs business analytics.1-) When I want to run the business analytics report installed in IFS, a blank page appears when displayed in excel.2-) How can I view quick reports in IFS Business Analytics?

How can I add permissions for a user to can connects to see data in views by ‘SQL Developer’ tool (directly from the database Oracle) ?Currently, the user can see tables, but views can't - by SQL Developer. if I add IFSAPP perspective , then he connects but can’t see the data from view.-off course this view have the data :  here is an example that user has connect to the table: The issuse related with IFS 10.

Hi I have a quick question on crystal report on EDU environment APPS10. I cant seem to download the Crystal Runtime files from the add-ons, could someone please explain to me why this is the case?  

Hi Received the following error after BR client installation (MSI installer)MS Office 2019 

The supplier Check report has several layouts based on Banks. I want to select multiple bank checks and when I print, system will select automatically layouts based on banks.

Hi , I have a requirement where the lobby  must show the count when the reminder is due (from purchase order screen )and filter applied in reminder due as ‘ yes ‘ and on clicking the count it must navigate to purchase order confirmation reminders screen where it must show the data where the reminder due is yes . but for me it is showing the count for all the data in the page without recognizing the filter . if I add filter as reminder due is yes inside the navigation , it is not working properly .  PURCHASE_ORDER_LINE_ALL - View used in datasource PURCHASE_ORDER_API.Get_Contract(order_no)= ContractAND Purchase_Order_Line_Api.Get_Ord_Conf_Reminder(order_no , line_no , release_no) = 'Print Order Reminder'  - this is the SQL condition I have given page/PurchaseOrderConfirmationReminders/List - This is the navigation I have given in element designer for now . if I try adding reminder due = yes inside this navigation it is not workin

Trying to figure out how to be aware of new Business Reporter software updates? How do we get notification of new updates?

Is it possible to choose the colour of the graph in a lobby element ?  

Hi All, When I preview a SQL Quick Report in EE, it correctly shows titles in mixed case. However when I preview the same report in Aurena, it only shows first word in mixed case and others in lower case. If you have any prefix like ‘%’ it then even shows first word in lower case.Does anyone know a solution/workaround for this? EE  Aurena 

Hello TeamAfter configuring the watermark in the one of the Order report, i am not able to get the watermark image in my generated PDF file. I already copied the .jpg file in Application server’s folder still not working. Can anyone help on this topic.RegardsImran Khan

Hi there!We are running IFS APPS10 in managed cloud and I want to establish the data pipeline to our data warehouse. I want to use the Information Sources for this purpose. While everything that comes with IFS is fine so far I am missing some information that are standard fields (like “Coordinator” in customer order). I have gotten some information on how to add custom attributes to information sources but not how to add additional standard fields to a pre-build information source. Has anyone encountered the same challenge and overcome it? I am thankful for any advice or explanation on how to achieve this. If you need more information please let me know. Thank you and regards,Sören  

Background: Our users would like “Keyword Search's” enabled for Customers window, Quotes window, etc.…Problem: Each Keyword Search must have enabled “Search Domain” which contains three jobs: Synchronized, Optimized, and Rebuilt. The last job, Rebuilt, is failing. The Error Text is below (I’ve removed the App User ID from Error Text, as seen in blue highlight):ORA-29874: warning in the execution of ODCIINDEXALTER routineORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2025ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 508ORA-29960: line 1, DRG-10595: ALTER INDEX CUSTOMER_TIX failedDRG-

Hi all, I want to connect IFS Business Reporter with IFS Application 9 environment , Kindly guide  Regards

Where can I find the list of new information sources released with IFS Cloud 22R1 release. I checked the release notes and “22R1 Service Updates - Fixes” shared in the community and there is no information about list of new IS’s.

Dear All, We have a new search settings in Aurena . Wanted to know about this functionality and how it works in Aurena. Screenshot attached. Thanks in advance! Best Regards,HA  

Hello Every One Please AdviceVery Urgent 

I am a beginner with regard to the report designer and I can’t understand why the following function crashes the report (A report error doesn’t allow the report to render): vldtstr:strIFF(vldtstr:strCompare(tns:CUSTOMER_ORDER_CONF_REP/tns:DELIVERY_TERMS_DESC, 'FCA (Incoterms® 2020)'), tns:CF_PROMISED_DEL_DATE, tns:PRICE_UNIT_MEAS, tns:CF_PROMISED_DEL_DATE)

HiWondering if anybody else has encountered this issue - our IT department don’t want users to create a trusted location C:\users\username\dowloads to be able to view output of business reporter reports. Apart from BRES is there any other way users could view report output without creating trusted locationThanksGT

Hi Community, If we need to control access for users who try to get data via BI access views created using QIS in the IFS cloud 21R2, Is there any mechanism to handle it? Best regards,Thiwanka  

when i install ifs business reporter to any user it raises this error while running the report. sometimes it work but mostly user receive this error, specially with the user with fresh installation.   

When printing an order report, can we print it together with the pdf attached to the attachments? Waiting for your solutions.

A very simple question: How can I make only the selected text bold in Report Designer? Report Designer <strong> text </strong> parses incorrectly see the screenshot below.  Waiting for your solutions.

Hi, I need to schedule a BR to be sent by MAIL to a distribution list. when I setup a schedule via “Report Schedule”  this report is only available via Report Archive and nothing is sent by mail to the distribution list... even to me if I specify to be sent by Email when finished. what am I missing pleaseThanks