Insights (Business Reporter and Analysis Models, EOI)

607 Topics

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

4778

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

301

11 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

490

11 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

6345

11 months ago

al-vSidekick (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?!]

2522

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

928

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

3992

1 year 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

4356

1 year 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

1573

1 year 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?

570

1 year 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

851

1 year 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?

600

1 year 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.

461

1 year 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?

1312

1 year ago

himasha.abeywickramaDo Gooder (Partner)

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

Analysis Models - Data Load Run Error

Hello,Below error is received when running a data load run,DataLoadScriptORAToSS - Copy Data from Oracle to SQL Server - 2 - ERROR: ORA-28000: The account is lockedAny idea why?

1352

1 year ago

SshirleyDo Gooder (Partner)

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

Business Reporter - Year to date for designated period; Prior Year to date

How can I create a column for Year to date and Prior Year to date for a designated period. for example I want YTD thru period 7. this is what I tried but the totals aren’t correct.

1709

1 year ago

Chamaka WimalarathneHero (Partner)

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

Can we sort the devtool network tab by Time

For performance issues it is better if we can sort the columns by time . but how can we do it in the Dev Tool ?

160

1 year ago

NMALKIHero (Customer)

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

Macro with Business Reporter

Hi ,Can Macro be used in Business Report. looks like it is not saved when I save the report.I need to hide a column based on it’s value. Thanks

512

1 year ago

Christophe BUSSISidekick (Partner)

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

How to access to IFS data from POWER BI

Hi,We use IFS Cloud 21.2.11 on Managed Cloud and Power BI desktop connect to Power Bi Cloud.Is it possible to read IFS data from Power BI ?If yes, do you have a documentation ?Regards, Christophe

20305

1 year ago

jzouaouiSidekick (Customer)

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

How to Print Pdf report automatically

Hello, I need to get Pdf report sent to the default Printer .when the shipment’s status change to Closed . Thanks,

48914

1 year ago

SKA123Do Gooder

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

Quick report default values in parameters

Hello community,I need to set a default value in quick report parameter.Here is my query in quick report: “ select * from customer_order where order_no = '12345' and customer_no like '&customer_order.customer_no' “Result of “select * from customer_order where order_no = '12345' “ in SQL :When executing on ifs, I got the list of all customers, it doesn’t take the filter into consideration : Is there a solution for this please?Thanks in advance!

3101

1 year ago

WellactuallyjustBennyDo Gooder (Customer)

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

Custom attribute for fact from &AO.[...]API.Decode(&AO.[...]API.[...](Parameters)

A beautiful good afternoon, I am currently trying to add a column from the receipt_Info view that seems to be somewhat customized. Usually I would use the “SQL Column” from the “System Info” Panel.But this one is not a regular term like “STATE” that can be used there but instead “&AO.[...]API.Decode(&AO.[...]API.[...](a list of parameters from the view)”.Can I integrate that column somehow into the information source and if so how?Best regards,Benny (Edit: typo)

1471

1 year ago

JannetteCHero (Customer)

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

Quick report export to excel error

Hello all, When I try to export to excel my report I am getting the following error - what does this mean please ?

1761

1 year ago

VsoMdsaiIDo Gooder (Partner)

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

Business Reporter - balance Current Month, Last Month/Year

Dear All,Can anyone tell me how to Set/show GL Account balance in three column cuurent month Balance, Last month Balance, Last year Balance in business reporter?

2282

1 year ago

SshirleyDo Gooder (Partner)

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

Business Reporter - exclude multiple accounts

In the filter Criteria, I would like to include all Revenue accounts except 3034, 3037, and 3040. however, I’m finding it only allows me to exclude one account. Is there another way to accomplish this?

752

1 year ago

Page 5 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded