Insights (Business Reporter and Analysis Models, EOI)

553 Topics

MelTanyaSSidekick (Partner)

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

Business reporter value format - show revenues as positive values on BR

Hello to the community, I am using GL balance data set to create reports on Business Reporter; All credit values, revenues are shown as negative amounts and costs have positive values; I was wondering if I could switch this value format presentation somewhere in order to show cost with minus sign (-100) and revenues as positive amounts? Thank you for your help :) Tanya

2 months ago

tgriffinDo Gooder (Customer)

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

Crystal Reports Shop_Order.Operation_No report layout

Hi everyone, Having some issues with Crystal that I can’t seem to wrap my head around. I’m trying to pull through the list of operations on a Shop_Order as they appear within the view, however Crystal is splitting each onto a new page. No ‘keep together’ options are working to resolve this either… Am I missing something? I’ve attached a screenshot of what result I’m getting, VS what I’m TRYING to get to.Appreciate any insights!

2 months ago

InisrinipDo Gooder (Partner)

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

Rename Report Attachment in Email

Hi,We have a report rule setup for the report CUST_STMT_ACCT_REP which sends an email for users. we have renamed the attachment as below to take the customer no.Environment = Apps9 But the attachment name is not getting the customer no and we receive attachment name as below. Are we missing anything here? Any help would be appreciated.Thanks!

2 months ago

hrdilshanSidekick (Employee)

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

Is there any way to kep the Reports stay in the Reprot archive for 3-5 days.

Is there any way to kep the Reports stay in the Reprot archive for 3-5 days

2 months ago

Kaylsmuk1Do Gooder (Customer)

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

IFS Business Reporter Error when opening saved file

Since upgrading to Windows 11, we have been experiencing problems re-opening reports/files that have been generated using IFS Business reporter excel add-in with APPS10. Has anyone else had this error and been able to resolve?This error is received when no other files are open etc

2 months ago

Alex_MeeSidekick (Employee)

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

Escalation Handler

Hi, Has anyone ever set up an Escalation Handling rule in IFS? My team has tried to set up an Escalation configuration that would dispatch a “Case” based on criteria but we can’t seem to get it to trigger. Any help would be greatly appreciated.Note: We really have yet to see a single Escalation Trigger work in action. A simple example of an Escalation Handling trigger in action may be enough to get us to the finish line.Thank you,Alex

2 months ago

kpiorunDo Gooder

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

"Order Report" greyed in Operational Reporting / Reports

In IFS10 on ifspp account one of reports in Operational Reporting is not available (C_PAY_GRIDLOCKS_REP). It has greyed submenu options: Order report, Show Archived Reports, Schedule Report, View Schedules. Other reports are available for print. When I try to add it to Report Schedule I got message: Report “C_PAY_GRIDLOCKS_REP” is not available for scheduling for current User (IFSAPP). In solution Manager / Operational Reporting / Report Definitions “Domain” and “Category” boxes are empty.Where can I unblock this report?

3 months ago

AHOSZEBESTADo Gooder (Customer)

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

Business Reporter - 23R1 Update 7

Hi everyone, I’m a new user on IFS cloud and I can’t connect on Business Reporter. On my test environment everything is OK however on the production environment it’s impossible. I have this message “Oops! Something went wrong - Invalid parameter : redirect_uri”. Do you have an idea in order to help me.

3 months ago

baris.haliciHero (Customer)

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

Fillable Order Report

Can we create an order report with fillable fields like the attached PDF document using IFS Report Designer?

3 months ago

BeckyDo Gooder (Customer)

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

Lobby Data Source count greater than 1

I am trying to put together a data source where the column count only shows me results greater than 1. How can I do this?

3 months ago

cdczdenehDo Gooder (Partner)

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

Consume Information Source/Access View via REST API

There is any option how to consume Information Source/Access View via REST API?I know that Information Source can be used in IFS Business Reporter and Access View I can read from database via IFSINFO user.But there is any other option? I mean eg. wrap Access View to Projection Configuration? I tried it but Access View cannot be used in Projection Configuration.Is any chance how to publish Information Source/Access View via REST API only by tailoring, without programming standard customization?Thanks. BRZdenek

3 months ago

gianni.nevesSidekick (Customer)

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

IFS Cloud - Unable to find my custom view when create a new lobby data source

Morning,We are trying to create a new lobby, but we it come time to create the datasouce (using datasource designer), we are getting always the error “UNABLE TO FIND xxxxx View” (where xxxxx is the name of the view). I already change the grants in all ways possible, and I don’t thing the problem is it. Did anyone have the same problem and managed to fix? Thanks, Gianni

3 months ago

IniVismiMDo Gooder (Partner)

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

Business Reporter-How to add a chart

Hi,Can someone advise me on how to add a chart for a table (Column/Bar/Pie chart) in business reporter.Thank you.

4 months ago

Alex IvkovicDo Gooder (Customer)

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

Scheduled SQL report formatting

When we schedule a Sql report it comes through with a lot of unnecessary formatting that makes the resulting spreadsheet impossible to use. All of our financial number fields have a carriage return and spacing. The reports export fine within IFS. Is there a place to tell the system to send scheduled quick reports as data only? This was not the previous behavior in Apps10 We are 23R1 UPD7

4 months ago

PolashDo Gooder (Partner)

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

Business Reporter (BR) Reports Unable to open from IFS Cloud

Hi,I have prepared a report in BR and it is working fine from Business reporter itself. After saving and publishing the report i am unable to open it from IFS Cloud. getting the following error: ************** Exception Text **************Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: This document contains custom code that cannot be loaded because the location is not in your trusted locations list: TB1_REP_4108_20230320-110225.xlsx. If you trust this document you can save and open it from a location on your computer. For more information, see http://go.microsoft.com/fwlink/?LinkId=99104. Can any one help me here? Thanks in Advacne. Polash

4 months ago

al-vDo Gooder (Customer)

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

Is it possible to alter a standard report without Developer Studio?

[I’m very new to IFS, so apologies in advance for incorrect terminology / an obvious question / etc.] My company are moving to IFS Cloud, and want to customise some of the standard report templates. From the docs and this post, it looks like the process for this is:Install Developer Studio, and link it our IFS instance via IFS Lifecycle Experience, Azure VPN etc. Use Developer Studio to download the .rdf and .xsd files for the report we want to customise. Install Report Designer and edit the report template, creating a new .rdl file. Upload the new .rdl file to IFS Cloud, and link it to the relevant processes.Is there another way to do this? E.g. is it possible to download the .rdf and .xsd files directly from IFS Cloud, and edit in Report Designer; or better still, clone an existing report template from within IFS Cloud and edit that directly? [And if not, is there anywhere I can vote for that functionality?!]

4 months ago

TopDeepaWSidekick (Partner)

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

Import Information Source IFS Apps 10

Hi,There is an option already to export information source as .ins file. But I couldn’t find any option to import that file into same or another environment. I’m very grateful if anyone have idea for that. Thank you.

4 months ago

shafiuzzamanDo Gooder (Partner)

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

How do I print the logged-in user name in the crystal report?

When a user prints a crystal report, the report needs to show the user name. Application 10.

4 months ago

skgurram

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

Business Reporter login with IFSAPP - SSO Enabled

Hi, We have SSO enabled login mechanism and would like to login to Business Reporter excel add-in using IFSAPP.We don’t see the login page even if ‘Use Single Sing-On box is unchecked.Any ideas? Thanks,Sree

4 months ago

HSELEWUSidekick (Customer)

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

report parameters as lov and how to create it

Hi all, I have two questions. how do you create a new lov for a report? I know it is possible to create a parameter that has the lov deposited, how do you do that? thanks in advance,Lena

5 months ago

christianrothSidekick (Customer)

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

Anti-join in query designer/datasource designer

I am trying to create a data source in datasource designer based on a query that I am designing in query designer. The end result should be a list of all Work Orders with a Work Leader that is missing a specific competence.In Query designer, I am able to retrieve a list of ongoing Work Orders with Work Leaders and I am also able to retrieve a list of competence per Work Leader but I fail to remove the Work Orders for those with a Work Leader that has the specific competence.The filter in Query Designer seems to be applied as a final step which makes it hard to just get a list of the specific competence at hand, and eliminates the possibility to use left outer join and search for null values.Is there anyone that knows a good way to solve this challenge?

5 months ago

LeoDo Gooder (Customer)

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

BA Execution Server after update Windows Server

We were running the BA Execution Server on a Windows 2012 VM in three environments (Test, Acceptance and Production).In the Test environment we upgraded the Windows Server 2012 to Windows Server 2019 and the BA Execution Server was running like a dream.Unfortunately, after doing the same upgrade in the Acceptance environment (2012 to 2019), the BA Execution Server will start, but reports are not fully rendering. We get the same error message each and every time:Error occured when opening report: System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\IFS_BAES\Work\1064471\SER_1.xlsx'. There are several possible reasons:• The file name or path does not exist.• The file is being used by another program.• The workbook you are trying to save has the same name as a currently open workbook. at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPasswor

5 months ago

himasha.abeywickramaDo Gooder (Partner)

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

Power BI - Quick Reports

Hello,Is it possible to setup a Power BI report to run as a quick report in IFS Cloud?

5 months ago

Marcel.AusanSuperhero (Partner)

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

Schedule Business Reporter report - application message failed

IFS Cloud 23R1 SU4I’ve tried scheduling a Business Reporter report with the scheduling functionality introduced in 22R2.I’ve noticed the following:3 application messages are created for below settings the first 2 app messages I understand what they are and I get the email for these notifications The 3rd application message fails with NO ROUTING RULE FOUND. Also the input message only refers to data from report Archive.Does anyone have any idea how is this supposed to work? I don’t wanna have failed application messages. I could create a Routing Rule to catch this message and don’t do anything with it, but I’d like to understand what’s the purpose of the 3rd application message.

5 months ago

himasha.abeywickramaDo Gooder (Partner)

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

Analysis Models - Issue in setting up Tabular Models

Hello,I’m trying to set up tabular models IFS_INCIDENT_ANALYSIS and IFS_SALARY_REVIEW_ANALYSIS and it seems it’s missing Fact IDs referenced by above Tabular Models. It gives below error when trying to deploy tables and views to SQL Server, This environment does have some inactive components. Could you please explain the reason behind this behavior? what are the expected components that need to be active?

5 months ago

Page 2 / 23

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded