Insights (Business Reporter and Analysis Models, EOI)

Good Afternoon - We have a case where an employee is not appearing on the Holiday Quick Reports, we have checked his Position and employee set up, however we cant seem to access his details within the Detail or Summary Quick Reports! Any advice welcome Thank you

We have created a quick report in IFS Aurena. We need to display the updated records as well as the old records on the same report. How can we accomplish this? Currently, the History Log only show the meta data but not the actual changed value. We need to display the actual changes and the old value.

I am having an issue with saving/publishing BR Reports in customers on prem IFS Cloud environments. Versions:IFS Aurena framework version: 21.2.2.20211215045945.0IFS Aurena client version: 21.2.2.20211215045945.0IFS Business Reporter Client:  21.2.0 Even with AppOwner account with all the permissions cannot save or publish BR reports. Anyone knows a solution for this? Thanks in advance.

Hi,Requirement: We are printing a report using a RMB. When it gets printed, it must print 2 copies.In general, when we print an order report from any screen using RMB, then the print dialog gives us an option to input the number of copies we need.When I am trying to perform the same from the backend using below code, only one pdf is getting generated. Does this mean that the COPIES() will not work from backend?DECLARE  conf_attr_           VARCHAR2(4000);  ordrsp_site_         VARCHAR2(5);  change_online_     VARCHAR2(4000);  media_code_          VARCHAR2(40);  report_attr_        VARCHAR2(2000);  parameter_attr_     VARCHAR2(2000);  attr_               VARCHAR2(200);  printer_id_         VARCHAR2(100);  result_key_         NUMBER;  print_job_id_       NUMBER;  delnote_no_         VARCHAR2(15);  count_              NUMBER := 0;BEGIN  Client_SYS.Clear_Attr(report_attr_);  Client_SYS.Clear_Attr(parameter_attr_);  Client_SYS.Add_To_Attr('REPORT_ID', 'SHIPMENT_HANDLING_UTILITY_REP', report

Hi, I’d like to put a date range for my SQL statement. Could you please advise? SELECT payment_address.Identity,SUPPLIER_INFO_GENERAL.Name,payment_address.Party_Type,payment_address.Way_ID,supplier_info_general.creation_date,payment_address.Description,payment_address.Default_Address,payment_address.Data1,payment_address.AccountFROM   payment_addressFULL JOIN SUPPLIER_INFO_GENERALON payment_address.IDENTITY = SUPPLIER_INFO_GENERAL.SUPPLIER_ID

As EOI is slowly begin deprecated from support I have seen and heard discussions of DTO and discussions on this the Statement of Direction; a lot of these discussion are quite old. For example the two threads below;Interaction of six box model and with value assessments created in EOI and with Scope Tool model? | IFS Community EOI | IFS CommunityWhere has this got in IFS Cloud 22R1; and where is DTO on the Roadmap? Has it been called something else now?Is there still the concept of Biz Map somewhere, or has this been sub-subsumed into DBVE and the Demonstration of the BVE from Actual Performance data after the Implementation. 

Is it possible to filter a design column or row without having a repeater?  Every time I try to do this, my filter gets wiped out.Here are the steps I’m taking: I create a design row with a repeater and add filter criteria: The design column name and filters.  I delete the repeater because I just want one column - I don’t want the data to repeat. The repeater that I originally had. After I deleted the “repeater”  I click out of the column and then come back to it - my filter criteria is gone. The design columns and parameters are gone. 

Good Afternoon - Can you please assist - I would like to set a users permission to allow them to access various lobby pages  - When they type Lobby at the top of the Navigator bar the option Lobby Overview is not available -Only Date Source and Element options are available. What permission set or profile change is required to allow the Lobby Overview option to become available on the Navigation menu.  Many thanks Dave  

How can i write an expression/query so it’s possible to search on multiple suppliers? Right now my Quick Report only works when one supplier is searched on. See image:Quick Reportselect sig.supplier_id          , sig.name AS "Supplier Account Name"          , sia.address_id          , sia.name AS "Supplier Name"          , sia.country          , sia.address          , sia.address1           , sia.address2          , sia.address3          , sia.zip_code          , sia.city          , se.buyer_code          , PURCHASE_BUYER_API.GET_NAME(se.BUYER_CODE) AS "Buyer Name"          , PURCHASE_CODE_API.Get_Description(se.PURCHASE_CODE) AS "Supplier Category"          , cm.name          , cm.description          , cm.method_id          , cm.value          , cm.method_default          , cm.address_default          , cm.valid_from          , cm.valid_tofrom supplier_info_general sig        left outer join supplier_info_address sia on sig.supplier_id = sia.supplier_id        left outer join supplie

What function do I use to create a functional parameter that replace for example business plan id F2022Q1 with F2022Q2, i.e. next courter?If the business plan id would be a number value I could use function ADD but business plan id is a string and I can’t use it as a parameter value as number?

What are some good resources for learning IFS?  I’m not able to attend IFS Academy due to costs.  I’m just wanting to know if anyone has good resources for learning.  I have gone through some of the e-learning available in IFS 8 but I was told it was not available in IFS 10.  Any tips would be appreciated.

Where do I find the Design Row Grouping in Business Analytics?

I am getting the following error while running  an IFS Business Analytics Report. I am using a custom SQL Source to get some Project Management info.  It was working perfectly fine for almost a year.  System.OverflowException: Not a legal OleAut date.at System.DateTime.TicksToOADate(Int64 value)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.ParseValue(Datatype type, String value)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportExecutionMgrOld.CreateDataSet(DsrdResultSet resultSet, ArrayList physicalDataSets, ReportGenerator generator, String separator, Int32& recordCount)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportExecutionMgrOld.PrintReport(Dsrd dsrd, XlrTemplate template, ArrayList physicalDataSets, Exception& exception, Int32 lastDataSetId)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.ExecuteReport(Exception& exception, Boolean cacheEnabled)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.

I’ve made a quick report for a user however, they want to be able to right click each row and click view case. How do I make this an option on a quick report?  Thanks!

Hi All,I need to show the text 'SUPPLIER' vertically in a report. I tried using Vertical Text(text) function that is available in report designed but didnt get desired output.It not showing full text during preview. Anyone have an idea how to show text vertically   

I have shut off the First page, but when I preview the report it still shows the Header and Footer on page one.  I only need the Repeat page.  

When creating a custom report in Report Designer 200.2.0000 is there a way to copy from a Standard IFS report?  If not can someone explain to me why this is not available?

Request help for the strange behavior of the BA report extracted from GL Balance fact . The data is filtered on a particular code part . The format (border) for  a column which does not appear if there is not data is set as Underline and for the totals (Operational revenue in below the border line is set as Underline. For some code parts the Underline just appears partially and does not show up for other columns. Below is the issue. Not able to figure out what is causing this issue.  The underlines should extend to the other columns as shwon in RED but NOT hapening 

I have a user request to add Part and Part Description to the Handling Unit Label.  I would appreciate if someone could point me in the right direction.

We have a new project admin who is granted the same permissions as the other project admins and have Business Reporter installed on their laptop.When running a report through Business Reporter, it’s fetched correctly with no issue. However when it’s run from IFS it loads just the following. This works fine for everyone else and only just this one person is having this issue. The reports we are trying to run are not new ones and have been used by other admins for long time now.IFS version - Apps 10 UPD 10 IEEHas anyone experienced anything similar? An advice or suggestions? Thanks in advance!

Hi, I created a new Relation for Fact to use in my Business Report. I want to add the new Fact to the Custom Attributes for Facts menu. To do this I need to Unpublish the Custom Attribute, but I ran into an Error Message. See the screenshot below. Is there a way to work around/solve this issue, without unpublishing and removing the Fact Items that are used in current Business Reports?   

Hi everyone, In Info Services - Archived Reports, some users can’t see reports generated by other users, although they are added in the correct DG as per the user model. What else could be the issue? I’m using IFS 7.5 I appreciate all of your answers.

I have a custom field on the Inventory Transactions History Screen which I want to use as Criteria within a lobby datasource.  (Product Family=’1000’) however I am getting error of Invalid Identifier.  When I select * in SQL Developer or in the SQL query tool this custom field also is not available. What would be the best way for the custom field to effectively show in the database so I can use the needed criteria? Many Thanks Kirsten

The requirement was like this:       CASE          WHEN SUBSTR(PART_NO, 1, 2) IN('XX', 'YY', 'ZZ')  THEN           SUBSTR(PART_NO, 1, 2)         ELSE           'SP'       END CODE,See also >>multiple values in case statement | Toolbox Tech

I am getting the error “Error in IFSCommandPLSql Unexpected error while calling server method AccessPlsql/Invoke ORA-20115:The ":UL" has already been removed by another user.” when trying to upload files using 3rd party tool integrated to applicant function in IFS application) . NLS_LANG is set to AMERICAN_AMERICA.AL32UTF8. customer is using French in IFS application. Can some one assist to resolve this issue ?