Insights (Business Reporter and Analysis Models, EOI)

607 Topics

NMALKIHero (Customer)

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

Is it possible to have a schedule event that trigger BR

Hi Everyone,We were able to schedule BR and send it to users by mail directly, but our request now is to schedule a BR to be send to PMs of active projects (we have around 100 projects).If I do it via Scheduled Reports, I will have to create 100 schedule reports and keep updating them every time PM change, new project created or another one closed...Project_ID is a parameter for the business Report.Not sure if there is a way to schedule a database task that lunch a custom event and in the event to trigger/ call a Business report (which function to call?)… then maybe send a link to the report archive or attach it to the PM mail ideally. Any idea would be much appreciated.We are using APP10 , Upd 15Thanks

1200

1 year ago

techniceDo Gooder (Partner)

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

IFS Cloud - Inside Powerpoint or other presentation viewer

IFS Cloud - Is there an inside Powerpoint or other presentation viewer to use directly in lobbies?

1711

1 year ago

sherryDo Gooder (Customer)

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

ask for sql query tool training document

Does someone has any document for the sql query tool, i’m new for this area, want to get started.

722

1 year ago

JacJLDo Gooder (Customer)

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

Error using Custom Dimension LoV

Hello, I am currently trying to set up a ‘Custom Dimension LoV’ from a Dimension I have created. When I go to publish I am presented with the following error: I am unable to find anything on why this is happening, any help is appreciated!

1432

1 year ago

TimSidekick (Customer)

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

How to delete entries from XLR_REPORT_RESULTS_TAB

APPS9We have been advised that XLR_REPORT_RESULT_TAB is consuming a large amount of disk space on our database.It looks like this is added to when a BA report is scheduled or manually run.How can we flush out/delete records from this table? We can see records going back to 2020 which we don’t need. Thanks

971

1 year ago

durasrbDo Gooder

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

IFS Report Designer for IFS Apps 8.0 (SP-0)

Hello all, i would like to start using IFS Report deisgner, version of IFS which i using is IFS Apps 8.0 (SP-0) , i could not find any exe file to download, could anybody help about this issue and send me instalation file with report designer.Thank you in advance

380

1 year ago

Manish VermaDo Gooder (Customer)

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

Event Builder - Data Corruption

We have existing Event Builders at Product Level. Everything looks good in Database, but on Support Portal it is showing wrong information.Instead of Product Level, it is showing Item Level and next field is blank: We are having this issue with a large number of Event Builders. Is there is a quick fix? Updating these manually is very time consuming.

110

1 year ago

HousseinySidekick (Customer)

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

Avoiding duplicate values when combining two views SQL

Hi, I have the below two tables with the mentioned fields and sample rows. Table GL_Ledger X has got a lot of actual details down to GL rows while table Budget Y has got budget amounts by Activity_Seq. I need to come up with one report where I have all fields of table X and one additional field for “AMT” coming from budget using the common filed Activity_seq. Two issues in my result:Duplication of budget amounts (in A1 rows). Missing budget for A3 and A5In other words, want to keep all details and rows of table X and pick up all records from table Y with no duplicates.Any clues on how to solve this issue? Also if I will use union all, is there an easy way to copy all table X columns properties to table Y and how to do it if that is the only solution.

1314

1 year ago

SKA123Do Gooder

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

Modify RDF PLSQL in IFS Cloud 22R2

Hello community,Please I want to modify RDF PLSQL in IFS Developer Studio, but I can’t find in Cloud 22R2 any report files for *.RDF and *.Report: Thank you for your help.Best Regards.

1671

1 year ago

jzouaouiSidekick (Customer)

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

disabling Report printed automatically by the sys

Hello ,i have a report that is automatically printed by the system. and I want to disable automatic printing but I don't know where I should go in the set up .Report name : inventory order report Report ID : INV_PART_ORDER_PNT_REP_REPI think the report is printed when the Mrp is started by a scheduled task . but im not sure Report archive : Thank you in advance .

1498

1 year ago

HousseinySidekick (Customer)

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

what is SQL View of posting proposal history

HiWhat is the view of posting proposal history? need to retrieve some columns in SQL query. Any clues??RegardsHousseiny

612

1 year ago

SKA123Do Gooder

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

Text translation in IFS cloud

Hello everyone,I’m trying to change translation for customer order report fields, but I can’t find it:I think it’s a problem of permission sets, do you know please what permission I need to work on reports ?Thank you,Regards.

1162

1 year ago

lemantDo Gooder (Customer)

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

IFS Support of SQL 2022

Do we know when IFS will support SQL 2022? Thank you!

110

1 year ago

nahidDo Gooder (Customer)

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

IFS Report Crystal error

The problem is described in the attached doc file.Please find the problem description in that doc file.

1263

1 year ago

JacJLDo Gooder (Customer)

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

New line not being created in Business Reporter

Hello, I am working on creating the ability to insert a new row in Business Reporter and have it wrote back to IFS.I am given the normal pop up to insert a new row, I enter the information and press ‘OK’ and occasionally the new line will not be created. There is no error message that is given and nothing happens.Insert New Values ScreenAny advice on why this may happen or how to trouble shoot would be appreciated.

633

1 year ago

JacJLDo Gooder (Customer)

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

Business Reporter Writeback 'Existing state of has been invalidated'

Hello, I am currently trying to use the writeback functionality in Business Reporter.When I am working on creating the Procedure for the the writeback, if I update the API package and try to use the writeback functionality again, I am returned with this error: ‘Existing state of has been invalidated’. I have refreshed my cache, logged out and back in, and nothing changes it. The API works normally from inside SQL Developer. I am unsure of how to solve this error, any advice is appreciated.

722

1 year ago

Sadeepa GamlathDo Gooder (Partner)

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

Send Business reporter files via schedule job

Hi, I have a customer who wants to schedule job to send customer statement of account (New report created using BR). Is it possible to send BR reports via schedule batch job? Sadeepa

772

1 year ago

bpamlinDo Gooder (Customer)

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

how to handle multiple data sources in the lobby data source designer

How do you implement 2 data sources (views) into the lobby data source designer. I want the following code to return the count in the data source.select distinct(sp.catalog_no)from lora1app.sales_part sp, lora1app.sales_price_part_join splp where splp.catalog_no = sp.catalog_no and splp.SALES_PRICE_TYPE_DB = 'SALES PRICES'and sp.activeind_db = 'Y' and (splp.part_valid_to_date >= (sysdate) or splp.part_valid_to_date is null)and splp.valid_to_date >= (sysdate) --currently I have gone about it the following way seeing that the data source cannot handle two views:select distinct SALES_PART.Catalog_NO from SALES_PART where SALES_PART.activeind_db = 'Y' and SALES_PART.Catalog_NO in (select catalog_no from sales_price_part_join where sales_price_part_join.catalog_no = SALES_PART.CATALOG_NO AND sales_price_part_join.SALES_PRICE_TYPE_DB = 'SALES PRICES' and (sales_price_part_join.part_valid_to_date >= sysdate or sales_price_part_join.part_valid_to_date is null) and sales_p

5403

1 year ago

ashen_malaka_ranasingheHero (Employee)

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

How to optimize a slow running SQL type Quick Report?

Refer to following “Quick Report” query which is taking 10+ minutes or even timing out on some occasions. Any ideas on increasing performance of this SQL query? SELECT DISTINCT sp.activeind, sp.catalog_desc, sp.catalog_no, sp.cf$_last_modified, sp.contract, sp.gtin_no, sp.List_price, sp.List_price_incl_tax, sp.sales_price_group_id, sp.sales_unit_meas, spc.cf$_last_modified AS char_lastmodified, spl.last_updated AS SalesPrice_LastUpdated FROM Sales_part_cfv sp LEFT JOIN Sales_Part_Characteristic_cfv spc ON sp.contract = spc.contract AND sp.catalog_no = spc.catalog_no LEFT JOIN SALES_PRICE_LIST_PART_PRICE spl ON sp.catalog_no = spl.catalog_no WHERE sp.contract = '201' AND (sp.cf$_last_modified >= '&datestring' OR spc.cf$_last_modified >= '&datestring' OR spl.last_updated >= TO_DATE('&datestring2', 'yyyy-MM-dd'))

3107

1 year ago

HarikrishnangrSidekick (Customer)

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

How to create Custom event action on custom field table to save data to the same table for other records

Hi All,Requirement:In ‘Receipt’ screen ‘Receipt reference’ is an IFS standard field and ‘Gate Entry Reference’ field is a custom field (persistent type). (Please check image1, fields highlighted in red boxes, ignore the blue boxes 😊 )image1 I need to create an event when user enters value(add/change/delete) to ‘Gate Entry Reference’ custom field. then the same value should be updated to ‘Gate Entry Reference’ field of other records having same ‘Receipt reference’ field value.Please help me to create this event (the event action) Thanks in advance.Best Regards,Hari

7154

1 year ago

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).

1102

1 year ago

ChandraSekharDo Gooder (Partner)

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

IFS 10 Apps Report Layout no Multi uncheck

Please could response for my query, i.e If it is in IFS 10 Apps Report Layout no Multi uncheck and what kind of Favours and un-Favours. Kind regards,Chandra Sekhar

130

1 year ago

HowardSlinnDo Gooder (Customer)

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

Aurena Order Reports SQL type

We use Aurena only, Apps10 Upd13 (soon to be 14) and on a regular basis one or more or all of our SQL order reports start giving errors to all users. But only sql reports, crystals and operational reports are fineThe report in EE works fine, even when in Aurena failsapart from a server restart, this seems to continue for a few hours, then resolves itselfIt feels like were running out of some cache or disk but no one has been able to adviseRunning a refresh server cache sometimes fixes the issue, but not alwayserror:An internal server error occurred. Contact administrator.Url: https://----/main/ifsapplications/projection/v1/QuickReports.svc/QuickReport_844567()?$skip=0&$top=25Request Id = 46e2c0fe-2ce6-4e79-8e0b-09cdeb2b7c37Date = 2022-01-13T12:15:14.661ZClient version = 10.14.123.0

10029

1 year ago

PennyBSidekick (Customer)

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

IFS Business Analytics Add-In - can't reopen file after saving on server

We have recently started having issues opening excel files saved on to the server, which are based on a IFS BA Report. (See error message attached).> If we save the file onto our PC’s desktop, we’re able to open it.> Only affecting users on Windows 11 (and only recently), Windows 10 users can open the file> If IFS BA Add-in is uninstalled completely, the file can be opened

540

1 year ago

HarikrishnangrSidekick (Customer)

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

How to get SQL code behind Order report

Hi All, How can I get SQL code behind this order report. (Please find screenshot below)Thanks in advance.IFS apps 10. Best Regards,Hari

5418

1 year ago

Page 8 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded