Insights (Business Reporter and Analysis Models, EOI)

I am trying to run a report out of Business Reporter, using the GL Transaction info source. If possible, I would like to use the Light Item - Entry Date as a repeater, but only by the day. The system is currently repeating each time stamp. Example, I would like everything by “8/30/24 and 8/31/24” and not “8/30/24 1:23:01PM, 8/30/24 1:23:14PM, 8/30/24 1:25:57PM”.

Hello everyone, We’re running into occurrences where we make a minor change to a business report previously published in the database removes that report projection from all permission sets other than the permission set “BR_FULL_REPORT_ACCESS”. This is requiring permissions to be modified each version of the report to restore permissions back to where they were prior to unpublishing the active report. Is anyone else running into this issue? Would love to hear how others are managing permissions related to IFS Business Reporter around changes to existing reports. We’re working off the technical documentation here.

I want to add a new field named zip_code in the IFS Report Designer. To do this, I have already added a function and XML in the RPI file. I tested the function and its parameters in SQL, and the zip_code result was returned correctly. However, after saving the RPI file, the zip_code field still does not appear in the IFS Report Designer. I have saved the changes, and there were no error indications. At this stage, I also downloaded the schema in IFS CRP and tried to add it in the IFS Report Designer, but there is no layout available to display the zip_code. Did I miss a step that is causing the zip_code field not to appear when I try to add it?

I get an error when previewing a Report Studio - Designer layout in Build Place. IFS Cloud Version 24R1SU0 Can't I use a Report Studio - Designer layout in Build Place? Error:The Print Job can not be printed due to Redis queue failure. Contact System Administrator The capture below is Report ID:MODULE_REP.

Does anyone know how to build IFS Cloud specific user related RLS into the Tabular models?

I'm testing a Business Reporter , and I've encountered an issue. they receive an empty one. I would be grateful for your assistance

hello, We have a business reporter with 2 parameters: year and period. We will use the scheduled reports option to schedule this report and enter context variables (e.g. #year#, #last month#). using function parameters, we need to figure the year period (yyyymm) which will be used to filter on various report columns (e.g. last period, last year current period etc.). The issue is that if we enter year:2024 and period:7, how can we get business reporter to convert these 2 parameters to year-period value 202407 instead of 20247. Any suggestions? This is in Apps 10 (version 5.0.27).

I have noticed, when trying solve a users acccess issue for a BR report, that while in IFS Explorer, users can only see and run BR reports that their IFS access allows them to.However, if someone logs in with the standalone Business Reporter client on their PC, they can access and run all the BR reports in the system, regardless of their IFS user security settings, so the security settings are bypassed altogether.Is this a bug, or is there something that needs configuring in the system to ensure they can only see and run the same reports in the BR client that they have access to in the IFS Explorer client?IFS Explorer client version: apps 10 update 14, in house installation. Business Reporter client: Apps 10, version 5.0.24 Thanks

BR Reports refuse to be rendered as a PDF although these settings were done: There was an issue with PDFs which should have been resolved by BR version 23.2.0 (EIZBR-2617), but I am using version 24.1.1 in this case and still I am getting would-be PDFs as ordinary Excel workbooks.

Hi All, One of our customers would like to connect an existing SQL server data warehouse to their IFS Cloud. What would be the best approach to do this? We are looking into solutions like, using the APIs, information sources or using IFSINFO user combined with IALs but haven’t figured out a recommendation from IFS to do this. Thank you all for your input.

Hello experts According to the IFS Business Reporter designer’s guide we have a helpful functionality called “Highlight” in the Business Reporter. It should highlight the design rows, column and cell criteria with the press of a button and therefore assist during the report creation. Before: ​​​​ After: Problem: When I try to use the highlight functionality it doesn’t work. I am in the Design Mode and click on the Highlight button, but nothing happens: Does anyone have an idea what the issue could be? It happens to me on Apps 10 as well as on IFS Cloud. Many thanks in advance! Best regards, Lukas

Hello, We have a report we developed but has a strange column pulling no data, but cannot figure out how to eliminate the unnecessary column

Hi, A custom filed is used as a business report parameter. LOV of the custom filed is visible when running the report in Business Reporter. However, once the report is published in IFS Cloud, LOV of the parameter is not appearing. Any idea on this issue? Thank you

Hello All, I am modifying quick reports trying to get the enumeration/reference lists to appear in the parameter list. I have gotten the list to appear, but I have one custom field that doesn’t show the prompt. It has a prompt in the custom enumeration and on the custom field, so it isn’t simply missing. All I get is the semi-colon “ : ”. See below: Either overriding it or getting the correct prompt to show up would fix this problem. I have another report where the entry parameters are to be excluded from the report, so the normal prompt will not work. In this case I would like to override the normal prompt for only that report. So it would be something “Exclude These Group ID’s” where the normal prompt is “Group ID”. Thanks, RonV

Starting on July 13, 2024, our data loads started having issues. We did not have any patching or updates or changes that I can find. Prior to this they were running successfully since deployment for over 6 months. The data load itself has a status of executing with errors. Each data source shows as Executing, Failed, Success or Submitted. Most were showing as Submitted. The BI server errors looked like they were deadlocking them selves. I put sequential IDs and sequences on all of the data sources and now most show as Success. If I run a data source by itself, then there are no issues. Any help or ideas would be great. Here is the IFS screen examples: Here is the SSIS log for the DIM_Account: Fetch Data Load Run Data Source Info:Error: Executing the query "EXEC [TABULAR_CREATE_AND_FETCH_DATA_SOURCE_RUN_INF..." failed with the following error: "Transaction (Process ID 65) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock vic

Hi BR experts, Could you please advise me on the following issue?When the customer orders the BR report, they get an empty report.But when I order the same report I get the report with data.To investigate the problem, I removed filters from the report one by one, until only the company filter remained. The filter looks like this: DIM_COMPANY.CODE IN &CompanyI defined it with a parameter Company with the default value: 8031,8111,8114,8115. The report appears empty, but when I change the filter to:DIM_COMPANY.CODE IN '8031','8111','8114','8115'with hardcoded values, the report shows data. Have you encountered such an issue? Do you know any solution or workaround on how to define a filter with a multi value parameter so that the report displays data?I would be grateful for any suggestions.Best regards,Adam

Hi I am getting this error message in Aurena “Invalid datasource definition” and not in IEE. I checked permissions for both the design and source element and all the permissions were granted.

Morning! We would like to know any functional enhancements in Business Reporter between Apps 10 (Upd18) and IFS Cloud 23R2? Please can you provide direction to where we can find this summary. Thanks

Hello,1) How could i add the 3 IFS fields into the information source “QFACT_CUSTOMER_ORDER_INVOICE_LINE” please. ​​​​​​​ Is there a solution to use them in my BR with my information source “QFACT_CUSTOMER_ORDER_INVOICE_LINE” please Thank you !

Designed Repeater in Rows 7-8​​​ Repeater information My company has been in IFS for a year now, and we have learned a lot about IFS and Business Reporter. I’ve been recently tasked to start making some of our reports more presentable. In the screenshot above, we have a row repeater over Rows 7-8. We no longer need columns A-D, or current rows 3-6. When I delete any amount of rows above, the repeater stays in row 7-8, but the fields [Structure Node] and [Account] move up, meaning the row design has broken. Deleted the above rows 3-6 After deleting the above rows 3-6 I thought maybe running the report would help the program to reset itself, but it does not. I have found once a file has this issue, it will always have this issue (to my knowledge). I have also seen it in Column Repeaters. We are still relatively new but are having a hard time with editing current reports at times. Is this a bug, or should we be deleting/adding rows/columns differently? I CAN manually edit the start/stops

How to enable turn on

Issue Reports created using "GL BALANCE" information source are unable to use "Zoom In" and/or "Drill down" feature. When IFS create a new report using "GL Balance" information source, it works fine on customer's end but when customer creates a new report using the same information source it doesn't work when trying to use "Zoom In" and/or "Drill down" feature. Only difference between the reports created by customer and IFS is the "Project" in the Document Actions is missing. In the "Dimensions" page, "DIM_PROJECT_CODE" is missing in the customer's environment. Environment RWGE-CLD-CFGProduct Version: 22.2.10 Cause Further investigations found that the reason for this error is Project component is not activated in customer's environment. Resolution IFS Fixed Version: 22.2.20 - 22R2 SU20, 23.1.13 - 23R1 SU13, 23.2.6 - 23R2 SU6, 24.1.0 - 24R1 GA, 24.2E.0 - 24R2 EA https://ifsdev.atlassian.net/browse/EIZBR-2731

Hello,We are using IFS v10 and I want to add media or documents to the pdf report. When we want to print a report on the Work Order screen, it gives us the option to add the added media or document, but even though I add the document, I cannot see the added media in the pdf report it creates.Can you help me

Hi everyone, I’m a new user on IFS cloud and I can’t connect on Business Reporter. On my test environment everything is OK however on the production environment it’s impossible. I have this message “Oops! Something went wrong - Invalid parameter : redirect_uri”. Do you have an idea in order to help me.

Hello, I am running a tabular model deployment for one of our customers and i get below error, i think the issue is due to the fact that they have multiple instances in their SQL Server and the Environment Parameters are set up like below, SQL_SERVER_NAME 12.1.2.12\IFSPRODBI and it finds the backslash as an escape character. Is there a workaround for this? Does IFS support multiple SQL Instances setup like above?