Skip to main content

Insights (Business Reporter and Analysis Models, EOI)

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

  • 614 Topics
  • 1,715 Replies
614 Topics
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.

900
S
Do Gooder (Customer)
3 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Report Designer adding new field with overlapping tables issue

Hi, I have an issue with adding a field on a lay-out in Report Designer. I want to add a field on the pdf lay-out of the Customer Invoice, but two tables overlap in Report Designer with as result that I am not able to add the new field. Does someone know how to resolve this issue? Please refer to the screenshots below.    

56210
D
Hero (Employee)
3 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Data Mart Refresh Categories

Trying to refresh a Data Mart Source and receiving the following error: ORA-20110: Error while refreshing Data Mart Source (CONSOL_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expired    How do I debug/resolve this issue?

2271
Kalhari Dissanayake
Hero (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?  

1190
B
Do Gooder (Customer)
3 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
SQL weeknumber issue: wrong weeknumber

Hi, I am trying to extract the weeknumber from a date. But both my SQL statements return the wrong weeknumber. Here is my first statement: SELECT to_char(to_date(cf$_co_date_order, 'dd-mm-yyyy'), 'ww') FROM customer_order_cfvStatement returns: 22-3-2021 0:00 12 23-3-2021 0:00 12 24-3-2021 0:00 12 24-3-2021 0:00 12 25-3-2021 0:00 12 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13  My second statement: SELECT to_char(to_date(cf$_co_date_order, 'dd-mm-yyyy'), 'iw') FROM customer_order_cfvStatement returns: 22-3-2021 0:00 12 23-3-2021 0:00 12 24-3-2021 0:00 13 24-3-2021 0:00 13 25-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13  So both are wrong. I expect every date to return weeknumber 12, because that is the correct weeknumber. Does someone know how to achieve this? 

2876
EntNadeeL
Hero (Partner)
3 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
SQL statement returns no value due to value separated by semicolon

Hi, I created a Custom Field in the LU IncomingInvoice which returns the Coordinator Name based on the PO Reference. But there could be multiple PO References separated with a semicolon. When that is the case IFS returns no value. Is it possible to solve this issue, so that IFS returns multiple values when there are multiple PO References. Please see the screenshots below. Arguments:v.company, v.po_ref_numberSelect Statement: SELECT t.cf$_coordinator_name FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no =:PO_REF_NUMBER Kind regards,Simon

33911
EntNadeeL
Hero (Partner)
3 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Creating Custom Fields in INCOMING_INVOICE2 view

Hi, I want to create two custom fields in the menu Supplier Invoices Analysis (view = INCOMING_INVOICE2) and need some help:A Custom Field which shows the On Hold Reason (SQL Column: on_hold_reason) from the menu Authorize Invoices for Payment (view: PAYMENT_PLAN_AUTH_QRY). A Custom Field which shows the Coordinator (SQL Column : AUTHORIZE_CODE) from the menu Purchase Order (view: PURCHASE_ORDER). Can someone please assist me and help me get the right statements to create both custom fields?Kind regards,Simon

3457
B
Sidekick (Customer)
3 years ago
D
Do Gooder (Customer)
DAVIDODo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
HOW To Create a sub total for Project Cost on All Activity in Project

I äm trying to create a new lobby for Project Hour and Cost Analysis hence I have created the below sql query but I am finding it difficult to have a sub-total for every group of the same activityI wrote the following SQL query  select distincta.activity_description,a.resource_id as resource_id,b.resource_group_desc,a.qty_used as qty_used,a.qty_planned as qty_planned,a.project_cost,a.percent_usedfrom IFSAPP.activity_resource_proj a JOIN IFSAPP.activity_resource_proj_sum bON a.resource_id = b.resource_idAND a.project_id = '&Project_ID'ORDER BY activity_description Below is what I am gettting:I need a sub_total for Activity named 'DETAILED DESIGN’ as well as sub_total for '’ÍNSTALLATION SAFETY STUDIES'’  

1831
EntNadeeL
Hero (Partner)
3 years ago
P
Do Gooder (Partner)
PrasadDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Standard Lobbies and Reports

Hi Fraternity,I would like to have the list of standard lobbies and reports available in IFS v10-Aurena.Kindly advise on source of information available for the same. Regards,Prasad

4601
Yasas Kasthuriarachchi
Superhero (Employee)
3 years ago
D
Do Gooder
dnyandeDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)
Order confirmation print

Hi, I was wondering is someone could guide me in the right direction. We’re looking to set a routine in IFS  that automatically prints order confirmation when a customer order is released. Could anyone please guide me on how to go about setting this up?  Thank you 

3431
Mohamed Infaz
Hero (Employee)
3 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Information Message when using Order Report: Attempting update for read-only data source

Hi, When using Order Report in IFS, an Information Message appears with the text: Attempting update for read-only data source. This message appears five times, so I need to click five times on OK before I can order a repport. Does anyone know what the trigger for this message is and how I can resolve this?  Kind regards,Simon

1503
B
Sidekick (Customer)
3 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.

940
A
3 years ago
E
Sidekick
EvrKristNSidekick
asked in Insights (Business Reporter and Analysis Models, EOI)
Voucher row number vs Invoice Item

Has anyone attempted to join the gen_led_voucher_row to the actual invoice_items where the Sales Parts reside ? The requirement is to be able to view which GL row has been created by which invoice item row. I can’t find a direct link so it seems we have to go via inv_accounting_row by invoice_id and then to find the rows in invoice_item but then we fail to get a 1-to-1 

2211
S
Superhero (Customer)
3 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}]'] 

1610
A
Do Gooder (Customer)
3 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Query Builder isn't working

Hi, I am having issues with Query Builder. After entering the Title I am unable to select anything else, there is nothing to select in the Row Type drop-down, please see below:  Any ideas? I am logged in as IFSAPP. 

4449
R
Superhero (Partner)
3 years ago
durette
Superhero (Customer)
duretteSuperhero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Daily Backlog Snapshots

If I take our order backlog as of tonight at midnight, subtract from that our backlog as of this morning at midnight, then add today's revenue, I will get today's net bookings.Σ Bookings = Δ Backlog + RevenueThis calculation method accurately handles both order line cancellations and intentional shipping differences. Does anyone else here do this?What are you using to get a daily snapshot of your backlog?How are you handling different time zones?Is your solution easy to maintain/change?Is it durable?Is it simple and trustworthy?

3237
durette
Superhero (Customer)
3 years ago
I
Sidekick (Partner)
imharshit003
asked in Insights (Business Reporter and Analysis Models, EOI)
How can we see the detail of background job in Aurena?

Dear All,I can see the background jobs screen in Aurena but if I want to see the detail of a job by selecting it, I am not getting that option. Check attached screenshot. I want to know how can I go to the show details of the job in Aurena.  Thanks in advance! BR,HA

51711
Minoshini Fonseka
Superhero (Employee)
3 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter Issue

We have a few reports that have recently been crashing displaying OLE error.   After going through each Server Set Id.After recreating the Server Set within a new report to test it.   I found that if I had 12 or less Measure Item columns no error was received and data was output.  Out of the 19 DIM_REPORTING_ENTITY.CODE columns that we had it doesn’t matter which 12 DIM_REPORTING_ENTITY.CODE items used, so long as only 12 columns were used then no error, if 13 or more then report crashes with OLE error. Has anybody come across this, if so, what is the cause? Thanking you.

2634
N
Hero
3 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Quick Reports: how to join total purchase order amount including charges in one report?

Hi, I am trying to create a quick report. I want to show the total amount of a purchase order including possible charges on that order, preferably in one column. There is a column ‘Total Gross incl Chrg/Curr’ but this is including tax. I want to show the amount excluding tax. Is there a way to make this happen? Kind regards,Simon 

1612
B
Sidekick (Customer)
3 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?

1870
G
Sidekick (Employee)
3 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter - how to fetch only data from Purchase Orders with status not planned?

Hi, I have an issue with Business Reporter and data. I created a report which shows the Purchase Order Lines per week. But I only want to show the data from Purchase Orders with status not Planned or Cancelled. I tried to show only the data from Purchase Orders which were autorized, but I was not able to do so because that data is not present in the Information Source. Is there any way to do this?The Information Source which I use is ‘Purchase Order Lines’. We are on APPS10 update 7.  Kind regards,Simon

2104
B
Sidekick (Customer)
3 years ago
jhainsworth
Do Gooder (Customer)
jhainsworthDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Customer Order cleanup Undo?

Had a user run the customer Order cleanup but selected a little too much and from too recent. I wanted to get verification that there wasn’t an easy Undo button for this. Found out this job completed without errors so other than a database restore nothing can undo.

1651
Susith Setunga
Superhero (Employee)
3 years ago
H
Do Gooder (Customer)
hwilkieDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Business Analytics - Invalid Number error

IFSAPPS 9.We have been using a Business Analytics model to run our sales forecast. This was using Business Opportunities as the Information Source.One of the filter criteria was DIM_OPP_PROBABILITY.CODE BETWEEN 50 and 100. This basically captured any high probability Business Opportunities. After we installed UP17 our Business Analytics model stopped working. I believe the issue was that prior to UP17, the field on the Information source was the value in the PROBABILITY_DB field and it has now changed to be just the PROBABILITY field. The issue is that the PROBABILITY field is suffixed by a % sign, so when we use this field in the filter I receive an ‘Invalid Number’ error message. However I have not been able to use SQL in the Filter Criteria to either TRIM or REPLACE the % value out.Is there a way to point the Information Source back to the PROBABILITY_DB field? 

1283
O
Hero (Employee)
3 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

720
H
Do Gooder (Customer)
3 years ago
C
Superhero (Customer)
cjohnsonSuperhero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Material usage by Work Center

Hello, I have been trying to find a way to view all raw material that is used at a given work center. Ideally, I have reviewed material usage, component where used, but there does not appear to be a way to search by Work Center. I am hoping that there is an area within the system where this data can be viewed. Any help would be greatly appreciated!

912
C
Superhero (Customer)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings