Insights (Business Reporter and Analysis Models, EOI)

Evening i am looking for SQL help with my quick report. I’m pulling a date column in which i am truncating to split out the time. I want to create a selection box for the user to put a from and to date allowing a range to be displayed. Would it be easier to pull a single selection box which the user can use the between dates function?i’m starting withAND TRUNC(PROMISED_DELIVERY_DATE) BETWEEN DATE '2023-06-22' AND DATE '2024-06-22'But i need to make the user select the required dates

Hoping some one can help, when I run the following code in PL/SQL developer it runs without an issue - however when I put the same code into an IAL no records are created.  Why would that be please ? With Rowsnum As (Select to_char(dt,'dd/mm/yyyy') dt, row_number() Over( Order by dt) rnFrom (  SELECT ifsapp.cd_user_util_api.get_previous_period_end_date(sysdate) -366+ level dt  from   dual connect by level <= ifsapp.cd_user_util_api.get_previous_period_end_date(sysdate)       - (ifsapp.cd_user_util_api.get_previous_period_end_date(sysdate)-366)) rws where  to_char ( dt, 'fmday', 'nls_date_language = English'  ) = 'monday'),RqdParts As (select part_no, ifsapp.Inventory_Part_API.Get_Description(CONTRACT,PART_NO) part_description, ContractFROM ifsapp.Inventory_Partwhere contract Not In ('CPH','CTM','VMS','CGP') --and part_no In ('WMPI10067','500086536','WSBB10501','WMVA10007')and Nvl(Substr(ifsapp.Inventory_Part_API.Get_Accounting_Group(contract,part_no),1,2),'Y') Not In ('IS','PH'))sel

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?

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

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/  

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

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

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

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?

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

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?

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?

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

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?

 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.

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:

Hello,I am curently using IALs views with Quick reports in crystal. this works fine but when I try to use the IALs views in crystals layout in IFS these doesn’t work. I saw in a doc that sometimes it is better to create customs views in IFSAPP instead of IALs in IFSINFO (like IALs) so could you please give me an advice ?ThanksFrédéric

I’ve connected Tableau to IFS using the Oracle connector but I only see partial data once connected. Not sure what I am doing wrong and any help would be much appreciated. Cheers, 

Hi,One of our customers getting the following error when trying to log in to the IFS BR.In his PC VS 2020 is installed and trusted locations are defined.What can I do to resolve the issue?Thank you in advance. 

Dears, I create a new crystal report, but when I try to order report show blank page:is there a missing step?

Is there a way to restrict a report only to print the 1st page ?

Hello everyone, Looking for some insight on the title. Customer requires BR to generate in CSV format: Report is as follows: They required all approved expense sheet details grouping by Payroll ID and Rate. We had the ability to create an IAL for this data including the grouping as well. The Start and End dates are taken from the same field, Expense Date in IFS where Start Date shows the date for the oldest expense sheet and end date shows the newest expense sheet. However, where we hit a wall was the search parameters were based on the ‘Approve date’ which can carry many different dates so the grouping in the SQL did not work. We decided to create an IAL bearing all the data in the table plus the approve date and decided to perform all the other functions using Excel and it was a success. The report however now contained multiple worksheets and hidden cells of course due to the functions.The current solution we provided was to move all visible cells into a new workbook and save it as

We have a customer on 22R2, hosted in IFS cloud, looking to use Power BI.We’ve read the instructions here https://docs.ifs.com/techdocs/22r2/050_reporting/400_power_bi_int/010_setup_pbi_int/but not sure what customer would do and what would need to be done by IFS managed cloud team.Has anyone done this?Thanks.

Supplier Payment screen (Screen shot below) is missing from Cloud verison.I have below doubts -Although, the related business transaction can be done through mixed payment but what is the reason to discountinue the process.  How previous transaction can be seen in upgraded environment.  Note: Similarly, corresponding screen for customer, names - Customer paymeny is also discontinued.

Hello,I’m having a problem where Custom Field data is not getting transferred over to SQL database. Here’s what i have done,1. Relations for Facts      2. Custom Attributes for Facts  3. Access View  4. Data Source  5. Deploy to SQL Server Db6. Data Load Run 7.  FACT_BUSINESS_OPP_BI_TAB table shows as NULL for CF$_EC_NEXT_STEP  8. Querying for ‘SELECT * FROM FACT_BUSINESS_OPP_BI’ shows below, Any idea why it’s not transferring any custom field data to SQL Server?