Insights (Business Reporter and Analysis Models, EOI)

Refer to following “Quick Report” query which is taking 10+ minutes or even timing out on some occasions. Any ideas on increasing performance of this SQL query? SELECT DISTINCT sp.activeind, sp.catalog_desc, sp.catalog_no, sp.cf$_last_modified, sp.contract, sp.gtin_no, sp.List_price, sp.List_price_incl_tax, sp.sales_price_group_id, sp.sales_unit_meas, spc.cf$_last_modified AS char_lastmodified, spl.last_updated AS SalesPrice_LastUpdated FROM Sales_part_cfv sp LEFT JOIN Sales_Part_Characteristic_cfv spc ON sp.contract = spc.contract AND sp.catalog_no = spc.catalog_no LEFT JOIN SALES_PRICE_LIST_PART_PRICE spl ON sp.catalog_no = spl.catalog_no WHERE sp.contract = '201' AND (sp.cf$_last_modified >= '&datestring' OR spc.cf$_last_modified >= '&datestring' OR spl.last_updated >= TO_DATE('&datestring2', 'yyyy-MM-dd')) 

Hi All,Requirement:In ‘Receipt’ screen ‘Receipt reference’ is an IFS standard field and ‘Gate Entry Reference’ field is a custom field (persistent type). (Please check image1, fields highlighted in red boxes, ignore the blue boxes 😊 )image1 I need to create an event when user enters value(add/change/delete) to ‘Gate Entry Reference’ custom field. then the same value should be updated to ‘Gate Entry Reference’ field of other records having same ‘Receipt reference’ field value.Please help me to create this event (the event action) Thanks in advance.Best Regards,Hari

We have a report in IFS Apps 10 under IFS Business Reporter that was designed and and implemented over a year ago and up until the beginning of the month work correctly. Now, no matter whether you “Order” the report from within IFS, or launch IFS Business Reporter through Excel, as soon as the report is “run”, the “Conditional Formatting” rules within the Excel worksheet move from “This worksheet” into “Hidden:sheet_1”, even though there are no “hidden” sheets. This only happens when pulling the data from our production system. If we run the same worksheet through BR against any other environment (DEV, TEST etc.), the “Conditional Formatting” rules remain and the selected data that matches the conditions are highlighted as designed. This does not appear to be related to any IFS UPD levels, as we have had it succeed in both UPD8 (TEST1) and UPD12 (TEST2), but fail consistently in UPD8 (PROD).

Please could response for my query, i.e If it is in IFS 10 Apps Report Layout no Multi uncheck and what kind of Favours and un-Favours. Kind regards,Chandra Sekhar 

We use Aurena only, Apps10 Upd13 (soon to be 14) and on a regular basis one or more or all of our SQL order reports start giving errors to all users. But only sql reports, crystals and operational reports are fineThe report in EE works fine, even when in Aurena failsapart from a server restart, this seems to continue for a few hours, then resolves itselfIt feels like were running out of some cache or disk but no one has been able to adviseRunning a refresh server cache sometimes fixes the issue, but not alwayserror:An internal server error occurred. Contact administrator.Url: https://----/main/ifsapplications/projection/v1/QuickReports.svc/QuickReport_844567()?$skip=0&$top=25Request Id = 46e2c0fe-2ce6-4e79-8e0b-09cdeb2b7c37Date = 2022-01-13T12:15:14.661ZClient version = 10.14.123.0

We have recently started having issues opening excel files saved on to the server, which are based on a IFS BA Report. (See error message attached).> If we save the file onto our PC’s desktop, we’re able to open it.> Only affecting users on Windows 11 (and only recently), Windows 10 users can open the file> If IFS BA Add-in is uninstalled completely, the file can be opened   

Hi All, How can I get SQL code behind this order report. (Please find screenshot below)Thanks in advance.IFS apps 10. Best Regards,Hari

Can I hide a field in a header with a visible condition in the report designer?e.g. I want to hide discount in the header when the value is 0,00% Thank you in advance!

I am trying to build a quick report that will pull all of our rework operations that we label with an “R” in our operation description. I cannot get this report to match shopfloor_clockings. It does not pull all of the same shop orders and operations. I started trying to test the database tables individually, but I need a left join in order to filter the content in the operations_history down to the operations with the operation_description found in the shop_order_operations so that I can see that they are working. I get the error that you can see in the screenshot and cannot find a way around it.

We are trying to install the Bi solution. In the tech documentaion it is refered to a Main.cmd that you should request from and IFS Consultant.https://docs.ifs.com/techdocs/23r1/050_reporting/450_self_hosted_bi_int/010_create_azure_resources/#upload_odac_installation_files_to_the_blob_storageAnyone that know where to get the Main.cmd. We have tried a support ticket without any luck. Have now been waiting for 14 days….

Dear Community,I have a quick report (sql statement) the report retrieve many columns but the report is very slow take time to load data when user open it from order reportcan I do something for that ? 

It is needed to add dynamic images into the report for each part. The image is not store in the database or an an attachment, it needs to be fetched from an external image URL.

Is there any recommendation to select the SQL server version for IFS AM?. I needed to install IFS AM for APP10. Can we go with Standard edition without Enterprise?      

why multiple  same file is coming? what’s the logic behind that?  

Hi,We need to login to the business reporter using SSO with IFS Cloud. Can you let me know how to enable SSO for BR?

hi everybodyI try to one value rotate on report with rotate text function, but when I use that text dont wrapdo you have any solution for that?

Hi,I have seen announcements on that external data sources can be connected to Lobbies, since this is still new I have not found anyone who would have knowledge on how this is actually done. Is this for PowerBI lobby elements only or can it be used for all lobby elements? How do you set up an external data source for a lobby? Any advice is welcome.BR, Jukka

We are wondering if you can directly from running a quick report in IFS export it into PDF format instead of exporting it to Excel as per usual. The background is that the Swedish Maritime Administration wants to be able to issue quick reports to its auditors and then assure them that the data has not been manipulated. The customer is running Cloud 22R1. If it is not possible to do this, which is the best solution for PDF reports directly in the system, do only the resource-demanding report designer reports apply or is there another alternative?Use case the customer wants to build his own report where he/she himself chooses which data should be in the report and then he/she wants to run it in PDF format directly in the IFS system  

Hi Community,I have one problem. I have a report in BA (IFS9). The report is stored in IFS and is scheduled for automatic startup. Usually the report generates fine, but occasionally returns the error: "CreateExcelePortwithdsrd: EJB Exception: ORA-20105: WebServicesutil.utl_http_fault". Please, do you have any experience with such a problem? Or some idea, what can I check?

SSRS report is working when open from SSRS reporting server but when try to view it within IFS Cloud it’s blank.Followed cloud documentation and done followingConfigured SSRS parameters. IAM Client IFS_ssrsor_integration created as it was documented. Done SSRS data source setup,  it is connected successfully.Does anyone came across similar issue in IFS Cloud?

All in Apps9 is there a way to use more than one view when creating a data element for a lobby? I’ve used the SQL rather than query builder as it’s a custom view I need to use along with another standard view.

Hello, We have created several custom Quick Reports to our IFS Apps 10 UPD 12 instance. I can see them in Order Report on Aurena, however, I do not have any options to configure the report parameters prior to running. Do QRs created for IEE need to be recreated in Aurena, or can they be run and parameters specified?Thank you!

I am trying to create a simple Project Cost Report using the Project Activity Information Online Source as I done before.I keep getting a The Given Key was not present in the Dictionary. What key, which dictionalry but how would I fix it ? Probably user related as I get it in APP10  nd IFS Cloud 21R2  but user not smart enough to figure it out (ie me) 

We have a quick report that outputs different results when it is sent via a scheduled data base task compared to when it is run manually. These sums are done using simple “select sum() from table where X” and are listed in rows using union. As you can see in the table. Only sum 7 and sum 8 are inorrect when using the scheduled quick report. The others are correct. Any ideas why this might be happening? Manual output: sum1 1263584 sum2 8608567 sum3 4872151 sum4 55863 sum5 6525876 sum6 3413890 sum7 4532101 sum8 9021000 sum9 7553101  Scheduled Quick Report:sum1 1263584 sum2 8608567 sum3 4872151 sum4 55863 sum5 6525876 sum6 3413890 sum7 8428850,52 sum8 9021000 sum9 11449850,52  

The following error occurs while opening IFS BR (Office 365)