Insights (Business Reporter and Analysis Models, EOI)
This will include the questions related to Business Reporter and Analysis Models, and Enterprise Operational Intelligence.
- 426 Topics
- 1,230 Replies
Business Reporter (BR) Reports Unable to open from IFS Cloud
Hi,I have prepared a report in BR and it is working fine from Business reporter itself. After saving and publishing the report i am unable to open it from IFS Cloud. getting the following error: ************** Exception Text **************Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: This document contains custom code that cannot be loaded because the location is not in your trusted locations list: TB1_REP_4108_20230320-110225.xlsx. If you trust this document you can save and open it from a location on your computer. For more information, see http://go.microsoft.com/fwlink/?LinkId=99104. Can any one help me here? Thanks in Advacne. Polash
Business Report - Is it possible to supress rows with 0's in the values
Hi All, I am just having a play with the GL Balance information source and wondered if I can supress rows with 0 balances I currently have the 3 elements below with a row repeater of account There seems to a few account that has a 0 balance. I was wondering if i could exclude that from showing in the report. I have tried setting row filters and cell filters.(Is not Null and not equal to 0 ) doesn’t seem to get rid of them. Is there something obvious I am missing here ? Any advice is appreciated ThanksCameron
IFS Business Reporter Error when opening saved file
Since upgrading to Windows 11, we have been experiencing problems re-opening reports/files that have been generated using IFS Business reporter excel add-in with APPS10. Has anyone else had this error and been able to resolve?This error is received when no other files are open etc
The image used as standard logotype (ifslogbw.gif) overrides other images in the reports
In my report where I have issues with images I have the standard logotype in the report. It has been added via the Aurena Interface under the tab LOGOS. Furthermore I have added another image to the report. This has been added “IMAGES” with another name.When running the report with the standard logotype in the database the image for the standard logotype is displayed both in the area of the standard logo and in the area of the other image.If I remove the standard logo from the database the other image will be displayed as expected, but I also want to have the standard logo in place, but the standard logo seems to replace other images when it’s stored in the database.Has anybody experienced this issue. Is it a bug?
How do you add an external data source to a Lobby?
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
PDF conversion of Quick report in Cloud 22R1
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
IFS BA error ORA-20105: WebServicesUtil.UTL_HTTP_FAULT
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 Quick Report not loading within IFS Cloud 21R2
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?
Aurena Quick Report parameters
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!
Project Structure Report Business Reporter The Given Key was not present in the Dictionary
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)
Quick Report gives wrong output when scheduled
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
Already have an account? Login
Login to the community
No account yet? Create an account
Login as an IFS Employee
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.