Insights (Business Reporter and Analysis Models, EOI)

This will include the questions related to Business Reporter and Analysis Models, and Enterprise Operational Intelligence.

  • 556 Topics
  • 1,568 Replies

556 Topics

K4uLinalM
Sidekick (Partner)
K4uLinalMSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to adjust the days limit of the archived reports we want to keep?

Hello, I want to keep the reports archived for 30 days instead of 7 days. I changed the setting in the capture below but it doesn't work. Is there any other setting I should change?Thank you very much. 

2
K4uLinalM
Sidekick (Partner)
1 year ago
Chanodhi De Silva
Do Gooder (Employee)
Chanodhi De SilvaDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))

Hi all,I am getting the following error while opening the Business Reporter. Any suggestions to resolve this issue? ************** Exception Text **************System.Runtime.InteropServices.COMException (0x80004004): Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))   at Microsoft.Office.Core.COMAddIn.set_Connect(Boolean RetValue)   at Ifs.Application.ExcelReporter.AddInManager.GetConnectionAddInObject()   at Ifs.Application.ExcelReporter.AddInManager.SetConnectionAddInProperty(String name, Object[] values)   at Ifs.Application.ExcelReporter.ReportLoaderOperations.PerformBasicValidationOnLoad()   at Ifs.Application.ExcelReporter.ReportLoaderOperations.LoadReport(IUiCallback uiCallback)   at Ifs.Application.ExcelReporter.MainWorkbook.ThisWorkbook_Startup(Object sender, EventArgs e)   at Microsoft.Office.Tools.Excel.WorkbookImpl.OnStartup()   at Ifs.Application.ExcelReporter.MainWorkbook.FinishInitialization()   at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator

2
B
Sidekick (Partner)
1 year ago
H
Do Gooder (Customer)
hweerasingheDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Report issue when column headers are more than 32 characters

If I try to create a SQL statement QR (IFS10) with column titles longer than 32 characters, it will give an error. Has anyone seen this before? Is there a workaround to this problem please? ThanksHiroshan

5
Kelum Pradeep Kumara
Superhero (Employee)
2 years ago
J
Do Gooder (Customer)
jaylee78Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

is there a way to set up a history log Attributes for permission set change (grant and revoke an object or method)?

Environment: Aurenais there a way to set up a history log Attributes for permission set change (grant and revoke an object or method)?

1
Charana Udugama
Superhero (Employee)
2 years ago
K
Do Gooder (Customer)
Kandi GeorgeDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter insight

Who can I contact to learn more about Business Reporter? 

3
V
Hero (Employee)
1 year ago
Raleigh_638
Do Gooder (Customer)
Raleigh_638Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Report Development Document

Hello All, I am brand new to IFS and  I have been tasked to develop new and update old reports. Is there a definite document on how to do this?

2
Kelum Pradeep Kumara
Superhero (Employee)
2 years ago
J
Do Gooder (Customer)
jaylee78Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Report_Display the updated records as well as the old records

I have created a quick report in IFS. I need to display the updated records as well as the old records of Vendor bank details on the same report.Currently, the History Log only show the meta data but not the actual changed value. And If I run payment table, it only shows changed value.Is there any way I can display the actual changes and the old value?Is there any table/db that holds the original data?

2
J
Do Gooder (Customer)
2 years ago
J
Do Gooder (Customer)
jaylee78Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

getting updated/deleted/inserted records using History Log

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.

0
J
Do Gooder (Customer)
2 years ago
M
Sidekick (Partner)
MounikaSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

1. Unable to print multiple copies of an order report

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

2
M
Sidekick (Partner)
2 years ago
D
Sidekick (Customer)
dmooreSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Holiday Quick Reports - Employee not visible

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

1
Rusiru Dharmadasa
Superhero (Employee)
2 years ago
M
Sidekick (Partner)
MounikaSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Unable to print multiple copies of an order report

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

9
M
Sidekick (Partner)
1 year ago
J
Do Gooder (Customer)
jaylee78Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Report, parameters, date range

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

2
J
Do Gooder (Customer)
2 years ago
Mark.Feldpausch
Sidekick (Customer)
Mark.FeldpauschSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - Filter Design Column without a Repeater?

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. 

3
Mark.Feldpausch
Sidekick (Customer)
2 years ago
AlexSharp
Sidekick (Partner)
AlexSharpSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

DTO and level of EOI Functionality available in IFS Cloud

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. 

2
R
Do Gooder (Employee)
2 years ago
D
Sidekick (Customer)
dmooreSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Lobby Overview

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  

2
D
Sidekick (Customer)
2 years ago
Timmermans Roel
Hero (Partner)
Timmermans RoelHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - How To?

Hello All, Can somebody provide a good document/tutorial/work instructions on how to create a Business Report? I don’t seem to find any good manuals that describe the possibilities and ways that we can use business reporter. For example: - If I use a Repeater on a row, can I use this repeater and define this immediatley as a dynamic XLS table? - Can I make a Pivot table of this? - How can I create a bar chart that takes into account the dynamic range of the repeater? - How to add an additional ‘calculated’ column to the table? (Calculated = I just want the difference between 2 source columns). Thanks for your help! Best RegardsRoel

9
V
Hero (Employee)
1 year ago
W
Sidekick (Customer)
woprhoweSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR Report loses "Conditional Formatting" upon run

We have a report in IFS Apps 10 under IFS Business Reporter that was designed and and implemented over a year ago and up until the beginning of the month work correctly. Now, no matter whether you “Order” the report from within IFS, or launch IFS Business Reporter through Excel, as soon as the report is “run”, the “Conditional Formatting” rules within the Excel worksheet move from “This worksheet” into “Hidden:sheet_1”, even though there are no “hidden” sheets. This only happens when pulling the data from our production system. If we run the same worksheet through BR against any other environment (DEV, TEST etc.), the “Conditional Formatting” rules remain and the selected data that matches the conditions are highlighted as designed. This does not appear to be related to any IFS UPD levels, as we have had it succeed in both UPD8 (TEST1) and UPD12 (TEST2), but fail consistently in UPD8 (PROD).

2
W
Sidekick (Customer)
11 months ago
C
Sidekick (Customer)
Christian CordiusSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Report how to search on multiple suppliers

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

3
C
Sidekick (Customer)
2 years ago
A
Do Gooder (Partner)
AddOscarCDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

BA - Design Row Grouping

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

1
B
Superhero (Employee)
2 years ago
A
Do Gooder (Partner)
AddOscarCDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Functional Parameter BR - Next Business Plan ID

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?

3
B
Superhero (Employee)
2 years ago
D
Do Gooder (Customer)
DMGERBERDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Drill Down not showing Query Voucher hyperlink

So I’m currently in training for Business Report and have activated Drill Down, but when I select a row from the ‘drill down’ temporary worksheet I don’t get the hyperlink to Query Voucher Rows or Details?

3
D
Do Gooder (Customer)
2 years ago
M
Do Gooder
MadushiDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Non Logo images in Aurena Report Images Folder

Hi, I am trying to add an image to a report layout using Report Designer Tool. The image is saved in the Report Images folder in Aurena client. I have used the option ' Dynamic Image Stored on the database ’ and wrote the  sql query  below.select image from ifsapp.report_images where image_name =:p1and passed the image_name as the Bind Variable.But the image is not showing in the layout. Can anyone explain me how to add this image (which is saved in the report images folder) to the report layout. 

1
P
Do Gooder (Partner)
1 year ago
J
Do Gooder (Customer)
Jan-RuneDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Error: "Startindex cannot be larger than length of string" while validating report

Hi,We recently upgraded our IFS to IFS10, and am attempting to use the Business Reporter functionality in our test version of the application.Using the setup guide provided I was able to set up a simple and basic report.Nothing more than using the GL Balance Information SourceVariables used in the sheet itself: Year, Account, Balance            Adding simple text header to the above variables.Filtering the design row to year 2022Repeater on year and account  Here I can save and publish without any issues. But then I run into the following issues:When I attempt to Load Report it opens up an empty excel sheet without business reporter. When I look into IFS it does not show up under “Order Report” When attempting to “Download & Validate” I receive the following error: “StartIndex cannot be larger than length of string. Parameter name: startIndex”.  I have attempted with multiple different reports and I get this error message each and every time. Is this a known issue that anyone else

2
V
Hero (Employee)
1 year ago
I
Do Gooder (Customer)
ioana.ionescuDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Unexpcted error in IFS Business Analytics Report: System.OverflowException: Not a legal OleAut date.

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.

3
S
Superhero (Customer)
2 years ago
C
Sidekick (Customer)
craryitSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Report View Line Option

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!

1
Kelum Pradeep Kumara
Superhero (Employee)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings