Insights (Business Reporter and Analysis Models, EOI)

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 in

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” 

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

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

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 ?  

BR - which settings are  necesary for running the report from the applications, and view the report directly instead of fetching it in Report Archive ?  

I created a BR report for project budgeting and forecasting with writeback on ETC. It works ok. However, I have enabled drill down on certain cells and all these drill down do not show any data. Not sure this is an issue or I am missing some set up. Please share any relevant info. 

Hi,any idea how to solve this?If I run the report in BR Server manually in the BR Client- then it works without any issue.  Template DREHPLAN_2 has design errors.View the trace data for more details.Exception from HRESULT: 0x800A03ECSystem.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC   at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)   at Microsoft.Office.Interop.Excel.PivotTable.set_SourceData(Object )   at Ifs.Application.Br.ExcelInterface.Vsto.ExcelPivotTable.SetSourceData(String sourceData, String sheetName)   at Ifs.Application.Br.Rendering.ReportExecutionUtil.CreateNonBaPivots(IExcelWorksheet excelSheet, ReportSheet reportSheet)   at Ifs.Application.Br.Rendering.ReportExecutionUtil.SortReportSheets(Exception& exception)

Dear community,I want to create a permission set without any write permissions in IFS Aurena.first step:second step: But my permission set is empty:If I grant write permissions then everythink is fine.How I can I create a permission set only with read permissions? Thank you

Hi,I’m trying to create a quick information source from the GENRES module to look at the resource activity load data. I can create the QIS, however it’s stuck in Draft status and I don’t have the option to “Create Information Source”, and I’m only given the option to create another draft. Is there a step I’m missing? Any ideas much appreciated Many thanks