Insights (Business Reporter and Analysis Models, EOI)

PhillBronsonSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Tabular Model : No data transferred after initial Data Load

I just went through a successful upgrade from IEE to 23r2 deployed On PremI have the provided IFS_INVENTORY, IFS_SALES, IFS_CRM, and IFS_PRODUCTION_PERFORMANCE models deployed for Data Mart and scheduled.I scheduled my Data Mart Refresh Category, Data Load, and Model Processing in a db task chain, these execute successfully, and I see my logs in both data and process runs.For some reason I don't see any data past the day I did the initial data load in SQL Server, the data is fresh in the MVT and BI tables.Can someone assist with this, if so, please let me know if more information is needed from me?

598

8 hours ago

CordiusDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Report how to use dynamic filter in pivot1?

Hello, (Also created in Framework and Experience)I'm struggling with making my report work to use a dynamic search filter under Pivot for part_no. Does anyone have experience with this? Note, I don't use pivot in SQL very often and tried different approaches.I tried creating a subquery for shop_ord without success. I've also tried using regex:part_no IN (SELECT trim(regexp_substr('&part_no','[^;]+', 1, level)) AS q FROM dualCONNECT BY regexp_substr('&part_no', '[^;]+', 1, level) IS NOT NULL ) I also tried to use query flags without any success. So, I'm a bit stuck and unsure whether this can be done. Does anyone have experience with this? My SQL:WITH weeks AS ( SELECT TO_CHAR(TRUNC(SYSDATE, 'D') + (8 - TO_CHAR(SYSDATE, 'D')), 'IW') + (LEVEL - 1) AS week_number FROM DUAL CONNECT BY LEVEL <= 21),data AS ( SELECT TO_CHAR(TRUNC(s.REVISED_DUE_DATE, 'IW'), 'IW') AS week_number, s.PART_NO, SUM(NVL(s.REMAINING_NET_SUPPLY_QTY, 0)) AS total_qty FRO

1 day ago

dritterSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Login Error

Hello,We have an issue surrounding business reporter that is causing frustration in its users. After initial login in Excel, we are able to use BR as needed. However, if we get timed out and attempt to login again, we get the error below. The only workaround we’ve found involves closing all instances of Excel and reopening the business reporter. This is a pain when working on many reports, or when we just have many different documents open. Occasionally this doesn’t even fix the issue and we need to restart the entire computer. Is anyone else experiencing these issues with BR? Anyone have a fix for it? Thank you,Dylan************** Exception Text **************System.Exception: Error while calling the projection BrClientAuthorizationHandler. ---> System.Security.SecurityException: IFS Business Reporter session has expired. Please re-login using the Login button. at Ifs.Application.Br.Authenticator.AuthenticatorService.GetOpenIdAccessToken() at Ifs.Application.Br.Authenticator.Se

1394

5 days ago

TopDeepaWSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Migrating IFS Business Reports from Apps 10 to IFS Cloud

Hi All, I am planning to migrate IFS Business Reports created for Apps 10 to IFS Cloud. Here’s the process I followed so far:Downloaded all the reports from IFS Apps 10 and saved them on my computer. Opened the reports in IFS Business Reporter for Cloud and attempted to save them.However, I encountered the following error during this process:I would appreciate it if you could help me resolve this issue. Additionally, I would like to confirm if this approach for migrating reports is correct, or if there’s a better way to proceed.Thank you for your support!Deepal.

201

22 days ago

Furkan ZenginSuperhero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Drill Down Not Navigating to IFS

Hello community,When trying to navigate to source from GL Balance Drill Down, it is trying to navigate to below path. I have read other posts on the community saying that BR system parameters must be set up with URL etc. However the parameter is removed from the page. I have read BR system parameters on the online documentation and it says basically the parameter is moved to system parameters and must be entered there.https://docs.ifs.com/techdocs/24r1/050_reporting/256_br_and_a/030_business_reporter/032_br_configuration/021_br_system_params/#url_navigation When I check the System Url parameter on the mentioned page the value is correct. Do you have any suggestion or alternative solution? The version is Cloud 24.1 Thanks

293

23 days ago

himasha.abeywickramaDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Tabular Models : Best practices

Hello,Is there a way to retain the following during an upgrade or prior to go-live?Tabular model deployments Created data load/process jobs Scheduled jobs Entity criteria for incremental loadingWhat are the best practices to follow during an upgrade or go-live process?Which information can be retained, and which ones need to be re-deployed?

324

24 days ago

himasha.abeywickramaDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Data Mart : Stop Previous Refresh Job

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?

152

24 days ago

ViitatiSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - The website’s security certificate is not secure.

Hi all, I try to log-on to Business Reporter, but I face strange error, which I have never met before: When I click “Refresh the page.” I get this error: I have installed this website’s certificate and this environmental works in browser correctly. I have also prepared IAM Client as it should: I have done this several times before for different environmental, and I have faced an errors when IAM Client or certificate is not defined correctly, but now I have done and defined them for this environmental at least twice.Certificate are stored on “Trusted Root Certification Authorities” -folder. I also stored them to different locations too, but did not make any difference. This environmental is working on 24R1 SU1.

562

26 days ago

JannetteCHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

QFACT views

Hello,How do I refresh a QIS, the ial that it is based on has 12000 but the QIS has only 10000 records ? Thanks

132

26 days ago

NecMayuIkSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Where is the Report Layout Migration Tool?

The documentation states the following, but I cannot find where to download the Layout Migration Tool in the Remote Deployment Guide.Can anyone tell me where I can download the Report Layout Migration Tool?https://docs.ifs.com/techdocs/24r1/070_remote_deploy/400_installation_options/005_operational_reporting/150_layout_migration_tool/--> https://developer.ifs.com/

2038

27 days ago

AnyDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Uninstall ClickOnce application

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

312

28 days ago

SYBMETHSHIKADo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Cannot login into IFS Business Reporter as a super user with basic authentication

Hi, When I'm trying to login into the Business Reporter using a super user username/password, it doesn't give any login error neither successfully load the reporter having closed the login dialog. When I choose the azure AD login option it says im already login. It seems something wrong with handling authentication code in the BR login dialog when even authentication happens successfully. Not loading after manually closing the login dialog too.Any workaround for this?This is IFS Cloud 24R1 Thanks!/Methshika

514

1 month ago

SachithaSidekick (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

Excel Add-In don’t work on Jump server

When logged into the Windows 2019 Jump server with a user with administrator rights, encountered an issue while attempting to initiate the IFS Excel Add-in.Upon starting Microsoft Excel and clicking on the IFS Excel Add-in icon, the Add-in launches successfully.However, when attempting to log in, encountered the following error: Web browsers are up-to-date and not working for both edge and chrome,versions installed on this jump server,Also installed WebView2, Would appreciate your insights on what could be the root cause of this issue

1716

1 month ago

DERYNGVE

asked in Insights (Business Reporter and Analysis Models, EOI)

Error when trying to open RDL in Report Designer

Hi all! We get the following error when trying to open and RDL in the latest version of Report Designer: We also have an older version installed and if we open the RDL in that version it works just fine. Any idea what the issue might be? Best regards

181

1 month ago

PhillBronsonSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Lobby Datasource Designer - Performance Issues 23R2

I have noticed a significant difference in the way Lobby Datasource page is loaded.Every refresh it retrieves all the available queries in the sudo-selector, and I usually end up waiting a full minutes before the page will respond. Has anyone else experienced this behavior?Is there any solution?

261

1 month ago

TopDeepaWSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Connect Business Reporter to IFS Cloud 24R1

Hi Everyone,Following error will appearing while connecting to the IFS Cloud instance. IAM client setup is done as per the technical documentation. Thank You.

823

2 months ago

setayeshDVDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Data Warehouse and ETL IN IFS Application

my main question is, Does the ifs application have a data warehouse service?

6396

2 months ago

RudolphVDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Reporter - Remove Old copies of a report

Is it possbile to remove / delete old reports from the database? Having tested various things in BR, there are now many unwanted reports visible. How would one go about removing or deleteing them?

301

2 months ago

ballmanDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

The public IP/FQDN should be internally resolved to the private IP of the SQL Server.

I am trying to setup my Analysis Models to populate to an on-premises server. The instructions are telling me :To achieve this scenario, where SQL Server needs to be accessed using the same IP address/FQDN both externally and internally, you can set up Split DNS or a Hosts file entry on the server running the SQL Server instance.I have tried to edit the host file by adding the external/public IP address as follows. Internal IP Exeternal IP or FRQN/Server Name 172.xx.xx.67 rs-IFS-biServer.domain.com 172.xx.xx.67 rs-IFS-biServer 172.xx.xx.67 170.xx.xx.245 Am I doing this right or do I have it backwards?

141

2 months ago

RutJWhalenSuperhero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

BPA Workflow - return count of records returned into recordset

Within workflow I am trying to get the total number of records returned into the record set so. Can anyone advise a way to do achieve this?

441

2 months ago

MspargoDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Information Sources Used

Hi, Does anyone know a way to see the information sources used in Business Analytics/Business Reporter reports. Essentially trying to work out which of our QFACTs are not being used. Thanks

271

2 months ago

ThejanJayDo Gooder (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

Question on loading data from IFS Cloud to existing Data Warehouse

A customer has custom data warehouse built in MS SQL server that they are using with multiple internal systems for reporting purposes. When using IFS Cloud they want to keep using the same data warehouse solution.What is the best way of loading data to their existing data warehouse from IFS Cloud at the database level?Is it possible to use Access Views for this purpose? if so are there any benefits of using access views for this rather than using Oracle views with direct DB connection?

2345

2 months ago

ADNANSidekick

posted in Insights (Business Reporter and Analysis Models, EOI)

Everything about the IFS 10 Lobby.

You can ask anything you wonder about IFS 10 Lobby. I can answer any questions you may have about IFS 10 LOBBY. Element design, data design, where patterns, references, page creation, authorization, etc. I would be happy to help.

940783

2 months ago

SHAUN_KERSLAKEHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Reporting and Data Warehouse

Afternoon,We are in the midst of upgrading to IFS Cloud 23R2 from Apps 10, and in parallel the business are reviewing our BI strategy. Currently we use IFS Lobbies, Quick Reports and Business Reporter within IFS, and externally use tools such as PowerBI and Qlik. All our reporting is based on the production IFS Oracle database through ODBC connections. We plan on using PowerBI as the primary tool for management reporting, whilst continuing to use Quick reports and Lobbies for operational reporting within IFS.We are therefore considering options for data warehouse solutions such as Microsoft Fabric and PowerBI. We are looking for information on what other IFS customer's are using for their BI strategy and data warehousing solution, along with some pros and cons. Thanks in advance

280

2 months ago

KiBriDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Report Designer - SQL query statement - NVL and subselect possible?

Hello,I would like to output a logo that is retrieved from the database via a select query and 2 parameters (company and language).Since it can happen that PNGs are not available for all combinations, I would like to output a standard logo for this case using the NVL function. The select statement works in PL/SQL-Developer.Unfortunately, no PDF is generated in the Report Designer Preview. Only the rendering cursor is displayed briefly, but nothing happens, no PDF, no error message.Is a nested select or the use of the NVL function not possible?Is there anything else to consider that I have overlooked?Or is there perhaps another way? Here is my select statement:SELECT NVL((SELECT image FROM Report_Logos_Tab WHERE SUBSTR(image_name,1,4)=:1 AND SUBSTR(image_name,-6,2)=:2), (SELECT image FROM Report_Logos_Tab WHERE image_name = '0000-Logo-en.png')) FROM dual; These are the parameters:tns:PURCHASE_ORDER_PRINT_REP/tns:PO_HEADERS/tns:

511

2 months ago

Page 1 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded