Insights (Business Reporter and Analysis Models, EOI)

Is there any plan to build/release an Analysis Model for Request Management?

I have created an Income Statement report package in IFS Business Reporter that contains several sheets. The first sheet is a consolidated statement, then each subsequent sheet is for each division of the company (plus a few other more granular statements). I need to update the sheet for our Admin division so it will display everything except for one of our cost centers (CSG). When I add the filter criteria so Cost Center is not equal to ‘CSG’ like this:...it removes all CSG data, but it also removes data where the Cost Center is null. Cost Center is not a required code part value for us, so we have many transactions where this field is null.I have tried a few different variations in the Advanced filtering pane like this:...but that has not worked either. I get an error that says “Basic Repeater is not allowed as advanced criteria are used in Report Book, Report Sheet or current design row”.I experience the same issue on the GL Balance Analysis page in IFS, but I can resolve the issue

Hi  In-Place-Editor not visible on double clicking on text-oriented controls on Report Studio Report design (rich text, text combo, Label). I am on 25.2.3 with Framework service update 25.2.5 

Is it possible for end users to view a report created in Business Reporter from Order Report without having to install the BR add-on? The users already have the correct permissions, but when they try to export from Order Report, the report appears in blank and does not load any information, even in the PDF document.The report was saved with the “disconnect” option and the “generate PDF” option selected.Thank you!

Hi, is there any way to directly run a business reporter report from a lobby page? Thank you!

Has anyone successfully managed to retrieve Business Report data from IFS to an external application - through API/Projection (or using Boomi).Generate a BR report and then use that result as something that need to be transferred to an external application.Our scenario is that we need to create balance sheet/P&L and then transfer the result to a Consolidation system for the parent company. These reports are created in BR.I can find the created BR report in Excel_Report_Archive, as an Excel file but I have not managed to access the data. There doesn’t seem to be any generated API’s for Business reports either, for Quick Reports there are API’s automatically created that can be used to extract the data from IFS. Or maybe this has to be solved in Excel, through the generated Excel Sheet - to manually trigger a transfer with some sort of script?

Hi BR experts,I'm preparing a report in Business Reporter, and I've encountered an issue. When the customer orders the report, they receive an empty one, but when I order the same report, I receive a report with data.I tried to recreate this issue, but I couldn't do it until I turned on the debugger.When I turned it on, I received an empty report.Have you ever encountered an issue like this?Do you have any suggestions how to solve it, I mean how to ensure that when the customer orders a report using their credentials, they receive a report with data.I would be grateful for your assistance.Best regards,Adam

Hello,  Does anyone have any insight into what the colours mean on the dimensions within the information sources? I’m building a report with two that have the same dimensions, one is coloured green, the other is grey and I can’t filter on the gray one without showing nothing for that dimension. I’ve compared the config and they look identical Many thanks!Will   

Hi there, I am wondering if there is anyway to add data sources to workload jobs in batches rather than one at a time. I have hundreds to add to a workload job and want to avoid having to do this one at a time. Cheers

I am facing errors while testing connections in SSIS during the Power BI infrastructure setup in Azure for self-hosted BI. It shows empty once the test connection is completed. 

Hello!I am trying to create a new query with Cloud Query Designer to show orders for a certain sales group that were invoiced “Today”. I added a filter the the Customer Order Invoice date - but I can’t figure out how to set it as a dynamic value for “TODAY”. I’ve tried setting it as a Parameter as well, but then the query prompts me to enter a date to preview the data. This won’t work for us as the intent is to schedule the report to be emailed to a group of users on a daily basis. Is this possible to set the invoice date as a dynamic value of “TODAY” with Query Builder? I’m a novice at query building so any tips someone may have a greatly appreciated.  

 Encountered an issue when running a scheduled quick report in IFS Cloud 24R1. When the report is sent as an email attachment in Excel format, it contains extra spaces around the cells (except for the header row). However, when I run the same report and export it directly from the quick report/output window, it appears correctly without these extra spaces. Example - Scheduled quick report mail attachment: Output from Quick report window:Could you please guide me what configuration settings should be adjusted to prevent the extra spaces in the scheduled reports Excel attachment?Is there a specific setting related to the export format that might be causing these spaces?Any other suggestions to resolve this issue? Thank you!

While printing a specific report (Purchase Order), in a specific test environment, I get this message error in a popup:Error occured while running the report. Refer to Print Manager/Print Key XXXX  Going to the print manager, in the “Message” column, I get this message:The Print job can not be printed. The selected printer is not mapped to any Print Agent. But the selected Printer has a related logical printer. This is my config while trying to print the report:  And this is my Logical printer view:  Anyway, in other test and prod environments, with the same configuration I get no error. I still do not know what this error is related to, but we managed it by changing the Layout Type from “Report Designer” to “Report Studio - Designer” in the “Report Definition” view.  IFS Version: IFS Cloud 25R1

Is anybody aware about the depreciation plan for custom IALs in IFS.In 21R1 and 21R2 this was included in the deprecation plan, but 22R2 deprecation plan has not mentioned about IALs (It's available in 25R1 as well).We believe in the future it will phase out.Can we get some details on from which version this functionality will not be available in IFS? 

Hi,I’m getting following error when trying to activate a data mart,The following error occured while refreshing Information Sources; "Error while refreshing Data Mart Source (GL_TRANSACTION_MVT) - resource busy and acquire with NOWAIT specified or timeout expired"Is there a way to stop the previous job?

Hi,Do you know if it's possible to use a “select” as a quick report variable?Or to have the variables pre-populated?Regards

We have a report with Design Rows for a Income Statement that some expenses are defined by cost center and account number. Others are strictly on the account number and we’re using a basic filter for that but an advanced filter with cost center and account combination.We have a sheet repeater to have an income statement for each cost center. For cost centers that have a row with no data it is suppressing those rows where we have the advanced filter. On the basic filter lines we have the “all” checked.We want to do the same with the advanced filtered lines also, because we will in Excel create a summary tab to add all the cost center tabs together. The issue is the lines in each tab don’t match 1 for 1 because some tabs have rows suppressed and they have difference rows suppressed compared to each other. how can we get all rows, regardless if a NULL value in each repeated tab for the lines using an advanced filter?

Hi. What is needed to get a IFS certification to be added to MS Trust Center’s Trusted Publishers list to be able to run IFS BR on a local machine?All attempts on adding directories to Trusted Locations list on Trust Center are not adequate as the company policy requires this cert to exist. 

Hello All, Can somebody provide a good document/tutorial/work instructions on how to create a Business Report? I don’t seem to find any good manuals that describe the possibilities and ways that we can use business reporter. For example: - If I use a Repeater on a row, can I use this repeater and define this immediatley as a dynamic XLS table? - Can I make a Pivot table of this? - How can I create a bar chart that takes into account the dynamic range of the repeater? - How to add an additional ‘calculated’ column to the table? (Calculated = I just want the difference between 2 source columns). Thanks for your help! Best RegardsRoel

We are just beginning to use Business Reporter and some of our users are getting this error when attempting to open BR reports to edit:Microsoft Office Document Customization“This document contains custom code that cannot be loaded because the location is not in your trusted locations list:_____________________.  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.Others users can open any of the reports just fine.I know we can add a location to trusted locations, but to share reports for maintenance this isn’t practical for our purposes, and we would like to understand why this is happening for some users and not others.Has anyone else seen this and found a solution?  We are on Apps10 UPD6, although the same issue occurred on Apps 10 UPD4. 

Hello community,I am trying to install BR for APPs10 through the MSI file, but the following error message is displayedI can’t see nothing in my folder IFS Aplications related to ClickOnce version Also I have disable the COM Add ins just in case.I want to uninstall the CLickOnce and re-install BR through MSI file.THanks and regards

In Apps 10 there was an option to export data, including the output of quick reports, in various different formats. By default this included .xlsx, .xml and .txt (which would be formatted as a CSV) as well as there being a setting to enable more possibilities. Is there similar functionality available in IFS cloud? When pressing the export button it does not give a choice and always exports as a .xlsx. 

How to use the API for getting CFV columns?I'm creating a Quick Report,so I tried using the following API but it didn't work.・SITE_DISCOM_INFO_CFV_API.Get_Cf$_Ordermanager(S.Contract)However, by joining the views as shown below, I was able to retrieve the columns.SELECTSDI.Cf$_Ordermanager AS "ORDER MANAGER"FROM  SHIPMENT_CFV S  INNER JOIN SITE_DISCOM_INFO_CFV SDI   ON S.Contract=SDI.Contract

Hi heros,I am trying to implement the incremental data load for my tabular models. I know we must pass through the data mart, but my problems are that when I am trying for example to refresh my FACT_CUSTOMER_ORDER_LINE, I am getting the error bellow, and my data mart does not change to FRESH.VERSION: 25.1.5  

Hi everyone,We are currently running the setup script for the Script-Based Infrastructure setup in Azure for Self-Hosted BI. Everything worked smoothly until Step 3, where the general function tried to locate the params.json file in the following path:C:\Windows\system32\templates\…  Has anyone encountered this issue before or knows how to get params.json file?Any guidance would be greatly appreciated.Thanks!