Insights (Business Reporter and Analysis Models, EOI)

607 Topics

ALHKESTSidekick (Customer)

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

Not possible to drag and drop lobby elements

Hi,When adding a new lobby element it always end up in a new green box, which I can not move, neither can I move the lobby element to another green box with empty space. Earlier this has worked just fine. My colleagues with the same permission sets can do it. I do not get the green arrow which indicates that the element is movable to appear.Does anyone know how to fix this?Thank you in advance!/Kerstin

1213

3 years ago

Thiwanka SandaruwanHero (Employee)

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

BR report level execution parameter - enable optimizer features

Hi All,To increase the performance of the published BR report, we can enable optimizer features for the SQL statement by using the BR report level execution parameter window’s hint field. I have tested the performance of a BR report that is available in a production environment. It seems the report will execute quickly after enabling optimizer features. Without that, it took more time. By using the database, I have compiled the SQL statements with and without query optimizer statements. In there also the statement which hasn't optimizer hint was consumed more time to run. A screen shot from non-production environment When I trying to order the same report from a non-production environment, it takes more time. But the same optimizer feature statement is there. I suspect that the existing oracle release number of the optimizer feature statement(10.2.0.5) is not compatible with the non-production environment. Here also I have checked the SQL statement by using the database. But it was ver

1410

3 years ago

KarrySchuppDo Gooder (Customer)

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

Excel Plug-in Template - SQL

Does anyone know if you can use two or more tables in creating an Excel Plug-in Template?

1370

3 years ago

BZNSIMONSidekick (Customer)

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

Business Reporter not able to run report due to item 'probability'

Hi, I ran into an issue with Business Reporter. I use the data source Business Opportunities. But Business Reporter gets stuck when I try to run my report. There is no error message or some sort, just the screen below which gets stuck. By trial and error, removing items and then test run the report, I discovered what caused the issue: it is item ‘Probability’ and ‘Description’, both under item Probability. When I remove that Item, my report runs without problems. But I do not know how I can resolve this issue? Help is highly appreciated because I want to display the item Probability in my report. Kind regards,Simon

1204

3 years ago

mzislamSidekick (Customer)

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

Want to use multiple layout in supplier check

I want to use multiple layout to print supplier check. Like one check with “AC PAY ONLY” in the left top corner of the supplier check, another one will be without “AC PAY ONLY”.How I can do it?

1451

3 years ago

Thiwanka SandaruwanHero (Employee)

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

How to get GL balance from GL cube when having an opening balance?

Hi,I have an unclear area on the General Ledger cube in APPS9. When we have an opening balance for any year it will insert under the 0th accounting period key. And If we want to take the value for the opening balance from the “Dm_FACT_GL_BALANCE” table we will have to use the 'BALANCE_OB' field instead of the 'BALANCE' field.Assume we have an opening balance for a company in 2019, My question is when I need to get the GL balance for the 2019 year what is the measure I need to be used? It seems the balance measure gives the wrong value.If you have any information regarding this matter please let me know. Best Regards,Thiwanka Sandaruwan

1441

3 years ago

manjareedDo Gooder (Partner)

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

Advanced Criteria for Design Row is disabled in IFS Business Reporter

Hi All, I was trying to add a Advanced filter on the design row #1 but it does not allow.Do you know why the Advanced Criteria for Design Row is disabled as in the below screen shot? BR Client used: I can only add advanced filter in cell only. Thank you!Disna

1512

3 years ago

ZTC ZTC JGOTAHero (Customer)

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

Could I used IFS APIs in Crystal report? or Do I need to create only IAL?

I am new to Crystal Reports.Could I call APIs functions to create Crystal Reports or build my own custom API and call it in a Crystal report? or do I need to build only IAL? Another quick question. Our system has many IALs built by our old developer. How could I see the SQL written to build the IAL? When I access the IAL Object Developer I cannot populate the code. See screenshot 1 for more details.Screenshot1.- However, I can see in IAL Configuration that we have 89 IALs. How could I see the code for each one of the IALs? See Screenshot 2 Screenshot 2

5382

3 years ago

ronhuHero (Customer)

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

BR - Aging Report

almighty community, i am trying to build an inventory aging report using IFS Business Reporter. i am trying to use Receipt Date this column in Inventory Part in Stock window as a calculation base. but i cannot find this field any where in below 3 data sources.Inventory Transaction History Inventory TurnOver Total Inventory Valuekindly advise. Thank you.

4224

3 years ago

RutJWhalenSuperhero (Partner)

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

Creating Email alert when the IFS BR Execution Server stops

Does anybody know whether it is possible to create an email alert that should fire when IFS Business Reporter Execution Server status stops. I tried to create an alert on XLR_BAES_TAB when Active = 0 but when the Business Reporter Execution Server stops on the Report Server the XLR_BAES_TAB Active column isn’t changing from 1 to 0. Any advice would be much appreciated.

771

3 years ago

PD.Ryan.KerrSidekick (Customer)

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

Crystal Reports Customer Order - File Name Apend

Hey all, We have a crystal report that handles our Customer Orders (Report Definition: CUSTOMER_ORDER_IVC_REP). I’m just wondering is it possible when a user uses the print dialogue box in IFS to email a Customer Order to themselves that the PDF has the invoice number in the title?E.g in the box below:ExampleKind Regards,Ryan

2595

3 years ago

SrikanthSuperhero (Partner)

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

BR Execution Server error

Hi,Version - Applications 10 Update 8We recently configured BRES by closely following IFS Documentation. The excel report is getting rendered but without any data. I see the following errors in the BRES log:I tried all workarounds incl. the one for COM Factory Class error but no luck so far.Any direction in this regard is very much appreciated.

2454

3 years ago

provenkagDo Gooder (Partner)

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

IFS Reports

Hi all,Layout name: ShipmentPackingList IFS Standard ReportWhere should I put the break point for printing the One Handling Unit per page(For example each Handling Unit print for Next page)I have put the below mentioned page break in report layout, but it is not working properly.Kindly help me on this. Thanks in advance,Venkatesh.

1522

3 years ago

ronhuHero (Customer)

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

IFS Business Report 10 Tutorial needed

Community,we just installed the IFS Business Report 10, any tutorial material available?appreciate your feedback.Thank you.

5517

3 years ago

SohailSidekick (Customer)

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

SQL query trainning

Is there any way to train oneself to creating SQL queries? for non IT person like me.

9693

3 years ago

USLA

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

Navigating to IEE from Business Reporter

Can we create a new navigating to IEE from Business Reporter? Something like core function in below

1252

3 years ago

ronhuHero (Customer)

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

IFS Business Reporter Refresh Data Mart/Materialized View

almighty Community,We just installed the IFS Business Reporter, and we know in order to have an accurate report, you have to refresh the background data.we see a list of pre-defined database task (see screenshot attached), but not sure which one should be scheduled first? shall all of them be scheduled ?shall they be scheduled at the same time? Thank you.

1833

3 years ago

SSMARAMUSDo Gooder (Customer)

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

IFS Blacked out fields

Hello, I have one strange thing happening with IFS. Sometimes fields in Shop Order screen are blacked out. (See screenshot.) the user can see the information if is clicked on the cell. Any idea how I can fix this? We’re still under Apps8 With respect, Andre

2687

3 years ago

hhy38Superhero (Customer)

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

App 9 - Web Lobby data and image problems.

We are using app 9 and we made lobbies. There is not any problem with data or images from the desktop. But in the web lobby, some of the data of elements are not seen. On the mobile side, Android phones show images but, iPhones are not. Also, mobile devices not shown some of the data of some elements. Has anyone faced this?

800

3 years ago

ZTC ZTC JGOTAHero (Customer)

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

Unable to cast COM object of type 'CrystalDecision.ReportAppServer.Controllers.ReportSourceClass' to interface type

Hello IFS Community, Can somebody point me to the best path to find solution to the following issue?I am running Crystal Report XI R2 and my IFS 9.

32152

3 years ago

ZTC ZTC JGOTAHero (Customer)

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

Crystal Report XI R2 - Crystal Report is asking for log info

Hello Community, I have an issue all the time when I try to run a crystal report in IFS is asking for log-in information. See Fig 1for details.I read that I need to add ( \ ) for table and (\\) for view. See Fig 2. I already ran the script for Crystal XI R2 to be able to add the InvalidAlias and I was able to rename the tables. See Fig 3. However, when I try to run the report one more time still asking for log in information one more time.What else do I need to do? Please, I need help :-( . FIg1Fig 2Fig 3

1461

3 years ago

Thiwanka SandaruwanHero (Employee)

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

LOVs not working when ordering BR reports from IFS Enterprise explorer

Hi, When creating a BR report the developer has used quick information source which containing the "DIM_ACCOUNT" and “DIM_COMPANY” standard dimensions. Inside the report design, there is a parameter for the account. Since the company is the parent of the account, They have used a company parameter as well.when the user orders that report from IEE, There is no LoV option for the account parameter. When ordering it through the business reporter excel add-on, once click the LoV option of the account parameter it will pop up the company LoV as a prerequisite. (Please note that there is a separate parameter for the company and the user should select the values for the company before selecting the account parameter)This company and account parameter LoVs properly working for some BR reports. Therefore I have compared the dimension joins of both information sources and there is no considerable changes.If you have any suggestions or information regarding this matter please let me know. LoV – L

3021

3 years ago

sumamatirmaziDo Gooder

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

How to pass multiple values in single parameter in IFS quick reports.

I create report in crystal reports, after I insert in IFS through “Create new Quick Report” window.In crystal reports I enter multiple parameters. But in IFS how I pass multiple values in single parameter.

12183

3 years ago

ZTC ZTC JGOTAHero (Customer)

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

Any Idea about this Crystal Report issue.

After I run a report I am getting the following message: Any Idea how could I fix the error?

1142

3 years ago

RutJWhalenSuperhero (Partner)

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

BR Execution Server Error

The following error appeared at 01:19 in the morning when hardly anyone was on the system.The report is scheduled to run.Template rendering Exception: Unexpected error while calling server method OrderXlrReport/SaveRenderedReport, Exception of type 'System.OutOfMemoryException' was thrown.. Error not related to report design. Therefore report not saved to error folder. Last successful execution log entry: Template file ORDER_INTAKE_AND_SALES_V1_1(215169) closed Any ideas how I can get to the bottom of the “System.OutOfMemoryException” error?Thank you. John

1991

3 years ago

Page 19 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded