Insights (Business Reporter and Analysis Models, EOI)

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

  • 560 Topics
  • 1,583 Replies

560 Topics

cperdue
Hero (Partner)
cperdueHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Paymode file template

All- In hopes someone has had experience with Paymode payment file/pay advise.   I need to create a pipe separated file that incorporates ACH and CHK supplier pay methods within one file. Any help is greatly appreciated. Best-Christy

0
cperdue
Hero (Partner)
2 years ago
R
Hero (Customer)
ronhuHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Lobby drill down and do query

Community, a question about lobby drill down. now I want not only drill down, i want a SQL query to be executed on the destination object, e.g. Register Arrival,   I want system not only navigate me to the Register Arrival window, but also do a query on certain part no. is this possible?Thank you.

0
R
Hero (Customer)
2 years ago
N
Hero (Employee)
Nalaka SamarasingheHero (Employee)
posted in Insights (Business Reporter and Analysis Models, EOI)

A simple Query Builder Example | Lobby

Basics:Navigate to ‘Lobby Data Source Designer’ and click + then select ‘Query Builder’. Add a name for the data source. Finding a view:Under ‘Search Views’, search Instant invoice. All the columns and references related to instant invoice will list down.  Adding a column and a function:RMB on ‘Invoice No’ and select ‘Add to Columns’. Then the column will appear under the columns section. Perform the same steps for the function ‘Get_Address’. Then search the view ‘Ledger Item’ and add the column ‘Cleared Amount’ as well. Adding a where condition:RMB on ‘Invoice Id’ and select ‘Add to Criteria’. Select the operator as = and insert a selected invoice id. Adding a table join (Inner):Under the joins section, select the Left View as ‘Instant Invoice’ and Right view as ‘Ledger Item’. After that select Invoice Id and company as keys from both views. Final Setup will be as below: Query Result will be as per the attachment. And all the basic functions available for SQL Query Data source can be

0
N
Hero (Employee)
2 years ago
K
Do Gooder (Customer)
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? 

0
K
Do Gooder (Customer)
2 years ago
Y
Do Gooder (Partner)
YvonneDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Get an empty form by Cyrstal Report in IFS 10 UPD9 IEE

Get an empty form by Cyrstal Report in IFS 10 UPD9 IEE .When I select more than 10 records, then print Cyrstal Report in IFS 10 IEE.Sometimes I got some  spare empty form. And I checked the output, nothing missed.I want to know why.  

0
Y
Do Gooder (Partner)
2 years ago
P
Do Gooder (Partner)
pronavyasDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to print text vertically in report designer

Hi All,I need to show the text 'SUPPLIER' vertically in a report. I tried using Vertical Text(text) function that is available in report designed but didnt get desired output.It not showing full text during preview. Anyone have an idea how to show text vertically   

0
P
Do Gooder (Partner)
2 years ago
baris.halici
Hero (Customer)
baris.haliciHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Using Quick Report Parameters and Flags

Hello Dear Community Users, I have a question regarding the following topic.I need to add the current operation state and the state of the operation before the current operation as parameters. When the parameter popup window is opened, 2 pieces of operation status (Oper Status Code) field are displayed. Which one is present and which previous operation parameter is not understood. SELECT * FROM shop_order_operation o LEFT JOIN shop_order_operation prev_op ON prev_op.order_no = o.order_no AND prev_op.release_no = o.release_no AND prev_op.sequence_no = o.sequence_no AND prev_op.operation_no = shop_order_operation_api.get_previous_operation(o.order_no, o.release_no, o.sequence_no, o.operation_no) WHERE o.work_center_no = '&[MCS-L]Work_Center_No' ANDo.oper_status_code = '&[MCS-L]shop_order_operation.oper_status_code' ANDprev_op.oper_status_code = '&[MCS-L]operation_history.oper_status_code';How do we make special prompt when we use view column which is enumeration? B

0
baris.halici
Hero (Customer)
2 years ago
J
Sidekick (Employee)
JayaniduSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Getting the Error in IFSCommandPLSql Unexpected error while calling server method AccessPlsql/Invoke ORA-20115:The ":UL" has already been removed by another user.

I am getting the error “Error in IFSCommandPLSql Unexpected error while calling server method AccessPlsql/Invoke ORA-20115:The ":UL" has already been removed by another user.” when trying to upload files using 3rd party tool integrated to applicant function in IFS application) . NLS_LANG is set to AMERICAN_AMERICA.AL32UTF8. customer is using French in IFS application. Can some one assist to resolve this issue ?  

0
J
Sidekick (Employee)
2 years ago
R
Sidekick (Partner)
rakpadmaSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

BA Report excel missing border lines

Request help for the strange behavior of the BA report extracted from GL Balance fact . The data is filtered on a particular code part . The format (border) for  a column which does not appear if there is not data is set as Underline and for the totals (Operational revenue in below the border line is set as Underline. For some code parts the Underline just appears partially and does not show up for other columns. Below is the issue. Not able to figure out what is causing this issue.  The underlines should extend to the other columns as shwon in RED but NOT hapening 

0
R
Sidekick (Partner)
2 years ago
hhy38
Hero (Customer)
hhy38Hero (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?   

0
hhy38
Hero (Customer)
2 years ago
H
Do Gooder (Customer)
HIMHIMABIDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Calling a Lobby about generated eMail-Link

Hallo community,ACTUAL scenario: The user is informed about changes by e-mail. The mail contains a generated link to the relevant IFS mask, which calls up this IFS mask when pressed. This works because it is the standard behaviour for IFS masks (ifsapf:frm ...).TARGET scenario: Now this should also be implemented for the jump from the mail to a lobby. I.e. the user receives a generated link in mail to the lobby, which calls up the respective lobby when pressed. Only in the case of Lobby (ifswin:Ifs.Fnd.CompositePageRenderer.Page...) does it NOT seem to be the default behaviour.How can i do this? Any ideas?Thx for support

0
H
Do Gooder (Customer)
3 years ago
Thiwanka Sandaruwan
Hero (Employee)
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

0
Thiwanka Sandaruwan
Hero (Employee)
2 years ago
A
Do Gooder (Customer)
astarkDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Excel Plugin Report Design

I am designing my own Excel Plugin for a report output.  I have it running except I need to run a case sql that will set a field to a certain number when a customer is printed.  Has anyone been able to pass a report parameter to a sql?  [&SELECT CASE WHEN IDENTITY='VICMEO' THEN '0131' ELSE '0000' END FROM CUST_ORDER_INV_HEAD_UIV_ALL WHERE invoice_no='[@REPORT-VALUE{PRE_INVOICE_NO}]'] 

0
A
Do Gooder (Customer)
3 years ago
S
Do Gooder
Santosh SatapathyDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Expense sheet

Hi All, Can someone will tell me when this reimbursable amount and gross amount will be different?what can be the scenarios in which it can be different? 

0
S
Do Gooder
2 years ago
G
Sidekick (Employee)
Gonzalo ValleSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Some questions regarding IFS Analysis models

I like to design a solution of IFS Analysis Model and I have some questions: What is better: to have SQL Server On-Premise or in MS Azure? What do you need into account when MS SQL Server is in Azure? Have we got a list of which PowerBI example dashboards are included in IFS Analysis Model? Have we got a description of the facts and dimensions included in each OLAP cube?

0
G
Sidekick (Employee)
3 years ago
ZTC ZTC JGOTA
Hero (Customer)
ZTC ZTC JGOTAHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is it Possible to auto pass a parameter value to a crystal report?

IFS Community, hello! There is a possibility that when I click on my crystal report "Material Rev Board Label" See screenshot, the parameter will be automatically passed to my crystal report. This is without prompting the window to ask for parameter values.I have Case ID 52 in my screenshot, so if I click on Material Rev Board Label, the 52 will pass to the Crystal Report automatically and after the report will display. 

0
ZTC ZTC JGOTA
Hero (Customer)
2 years ago
B
Do Gooder (Customer)
bworakuinDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter-Drill down does not show any data

I created a BR report for project budgeting and forecasting with writeback on ETC. It works ok. However, I have enabled drill down on certain cells and all these drill down do not show any data. Not sure this is an issue or I am missing some set up. Please share any relevant info. 

0
B
Do Gooder (Customer)
2 years ago
A
Alexandra Sidlovska
asked in Insights (Business Reporter and Analysis Models, EOI)

Export from Business Report

Hi,I have a question how to export Business Reporter from Excel To *.ins field?Thanks.

0
A
3 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Custom Attributes for Facts error when unpublishing

Hi, I created a new Relation for Fact to use in my Business Report. I want to add the new Fact to the Custom Attributes for Facts menu. To do this I need to Unpublish the Custom Attribute, but I ran into an Error Message. See the screenshot below. Is there a way to work around/solve this issue, without unpublishing and removing the Fact Items that are used in current Business Reports?   

0
B
Sidekick (Customer)
2 years ago
S
Do Gooder
sandun.kodituwakkuDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Unable to see IAL views in Visual Studio 2019 - SSIS with Oracle Connector and Client

We have a question regarding an SSIS connection to IFS.  I am using Visual Studio 2019 - Community Edition and have established a connection to IFS using Microsoft's Oracle connector to pull some data via an SSIS package.We have IALs in IFS that are considered views and have access to them with a "read-only" user account given to us.  I can see and access them in PL/SQL Developer, but I can only access tables in Visual Studio SISS package, I can't access the IAL views.Is there some type of limitation with the Oracle Connector? DetailsMain Requirement – Get some data integrated to a SQL Server database on premisesSSIS requirements and BI tools are installed.User Account – IFSINFO VS Studio Version – Can connect to the database using IFSINFO user but can’t execute a SQL query.  Only some of the views are shown and none of the IAL views are shown.  Question – how to make the IAL views accessible in VS? (They are accessible for the same user in PLSQL Developer)

0
S
Do Gooder
2 years ago
R
Do Gooder
rumeshDo Gooder
posted in Insights (Business Reporter and Analysis Models, EOI)

Navigate to Feature Form (ifswin) / Open Window using iURL / Navigate to Quick Report via RMB

Way 1private void menuFrmMethods_menuTest_Execute(object sender, FndCommandExecuteEventArgs e){ // ifswin:Ifs.Application.QuickReporting.QuickReportDetail?action=get&key1=773426 iURL.Clear(); iURL.SetProtocol("ifswin"); iURL.SetProgId("Ifs.Application.QuickReporting.QuickReportDetail"); iURL.iParameters.SetAttribute("action", "get"); iURL.iParameters.SetAttribute("key1", "773426"); iURL.Go();}Way 2public override void New(){ Ifs.Fnd.Core.FndUrlAddress url = new Ifs.Fnd.Core.FndUrlAddress("ifswin:Ifs.Application.QuickReporting.QuickReportDetail?action=new"); this.NavigationService.Navigate(url, false, true);} Cheers!

0
R
Do Gooder
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
S
Do Gooder (Customer)
swright1115
posted in Insights (Business Reporter and Analysis Models, EOI)

Modifying RDF file when environment is hosted

Our company would like to take advantage of printing media items on the service reports using Report Designer.  Our solution is  hosted and part of the challenge has proven to be obtaining access to the RDF files so that they can be changed. This is standard functionality on some of the other reports such as order confirmation but not the service reports.  Ideally, this would become standard functionality so it is not our responsibility to maintain this as upgrades come.  Has anyone had any success modifying the RDF files in a hosted environment.  It seems to have stumped support based on the feedback I have received.

0
S
Do Gooder (Customer)
3 years ago
B
Do Gooder (Customer)
bworakuinDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Writeback in Project Forecast

Can anyone share example reports of BR with writeback in project forecasting? How to add all ETC column in write back?  Is it possible to writeback of a entire row as new entry using writeback?  

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

How do I add Part # to HandlingUnitLabelRep using Report Designer

I have a user request to add Part and Part Description to the Handling Unit Label.  I would appreciate if someone could point me in the right direction.

0
D
Do Gooder (Customer)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings