Insights (Business Reporter and Analysis Models, EOI)

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

  • 553 Topics
  • 1,563 Replies

553 Topics

M
Do Gooder (Partner)
MangalaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is it possible to export IFS Business Reporter reports as .ins files?

Is it possible to export reports created using IFS Business Reporter as .ins files? I noticed that the sample reports in General Ledger are delivered as .ins files. But I could not find a way to do that using IFS Business Reporter.  Any idea how to do this?    

0
M
Do Gooder (Partner)
7 months ago
R
Do Gooder (Employee)
rajglkDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Streamserve Reports are not created to a folder

Hi All, I got a ticket from a customer that Stream Serve Layout reports are not print in the folder path created in  IFS Cloud 22R2 Worked in App9 as below.Enter the folder path which is in the middle ware servicePrint the Report and it will create a file in the folder path given in the system parameter. And they are trying to do the same setup in IFS Cloud 22R2.But while they print the report, they are getting the error as ‘No Such file or directory’  Is there any access problem or any idea for this.Thank you

1
Mathias Dahl
Superhero (Employee)
7 months ago
W
Do Gooder (Customer)
WellactuallyjustBennyDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS BR Information Source Purchase Receipt Status

A beautiful good morning to everyone! :)Is there a way to controll in an IFS BR file for the status of a purchase receipt?I cannot find the status in the light items nor in any of the linked dimensions.My current workaround would be to extract all receipts filtered for the cancelled status from the IFS App 10 GUI and add them manually to the executed report afterwards and link the status for the cancelled ones with a lookup and remove those receipts this way.Does anyone have a better idea?Manipulating the information source itself could be an option?I wouldn’t know how to do that currently, though.The overall goal is to produce a GRNI Report.Best regards,Benny

3
SandT
Hero (Partner)
7 months ago
R
Do Gooder (Customer)
reportingmgrDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR email subject line “Excel -File for report is ready”

We are running IFS 10 Update 13 mostly with Aurena.-Two report notification email issues:When scheduling reporting, and setting them to send emails to users, we have noticed that canned (prebuilt) reporting includes the name of the report in the subject line of the email. But, Business Reporter (BR) reports will not move the name of the report to the subject line of the email. Instead, we only see: “Excel -File for report is ready”    -How do we get the name of the report into the subject line of the email? We run multiple test environments. Can the environment name be in the Subject line of the email?Thanks!

0
R
Do Gooder (Customer)
7 months ago
H
Do Gooder (Employee)
Hassan ShareefDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Post Business Report Installation - Cannot open files larger than 10 MB

My customer is running 23R1 and after they installed BR on their local PC, the users are not able to open any excel file that is over 10 MB.  Has anyone seen this problem? 

1
H
Do Gooder (Employee)
7 months ago
M
Sidekick
mohamed_akrouhSidekick
asked in Insights (Business Reporter and Analysis Models, EOI)

Query Designer - can't specify value as parameter

Hi, I am attempting to create a query with parameters, but when I select my fields, Query Designer doesn't provide the option to choose dynamic parameters. Instead, it requires me to insert specific values. However, I want my query to support user parameters, allowing for a more flexible and dynamic input.thank you for your help 

0
M
Sidekick
7 months ago
D
Do Gooder (Customer)
DexpneDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to add a dimension item to an existing dimention?

I am new to dimensions, facts, and items. Is there a document or something I could read? My problem is I am trying to modify some BA reports that use certain information sources, and inside the sources there are existing dimensions, but the dimensions miss certain items that I want to add to them. I tried to add items on IFS from Information Sources → Dimensions → add new. But it asks me to incorporate a Fact that links the item to the dimension.The question is, can someone please show me a way to add a new item to an existing dimension?Thanks 

2
B
Sidekick (Partner)
7 months ago
Zuha Samsudeen
Hero (Partner)
Zuha SamsudeenHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Set an accounting structure as default in BR

HiI have created an accounting structure and wants to use that when loading income statement through business reporter.May I know how can we set that as the ‘default’ to be used when loading income statement through business reporter.

1
T
Hero (Partner)
7 months ago
M
Do Gooder
Mustapha_DeublinDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

list of tables and schema of IFS ERP database

Hi everybody ,I’m new by using IFS ERP and as Data analyst I need the list of tables/views and also the relationship between tables (Foreign keys ) like the Schema  !Regards 

13
Michael Kaiser
Sidekick (Customer)
7 months ago
Maja Stanislawska
Sidekick (Customer)
Maja StanislawskaSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to get a list of saved queries from Apps10?

Is there a way to get a list of saved queries (with the query string) from Apps10?How could it be achieved?

6
B
Do Gooder (Customer)
7 months ago
T
Do Gooder
tcboutteDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Reports SQL - Multiple Left Join Issue

Does anyone know why the following SQL doesn't work in IFS? I only seems to work without the last LEFT JOIN and the associated column that I want to bring in at the bottom of my SELECT statement. I’ve verified the column names exist, but unfortunately the errors in IFS point me nowhere. Thanks! WITH FilteredAccount AS (    SELECT *     FROM ACCOUNT     WHERE Company = '4400')SELECT    GEN_LED_VOUCHER_ROW_QRY.Company,    GEN_LED_VOUCHER_ROW_QRY.Voucher_Type,    GEN_LED_VOUCHER_ROW_QRY.Voucher_No,    GEN_LED_VOUCHER_ROW_QRY.Accounting_Year,    GEN_LED_VOUCHER_ROW_QRY.Accounting_Period,    GEN_LED_VOUCHER_ROW_QRY.Voucher_Date,    GEN_LED_VOUCHER_ROW_QRY.Year_Period,    GEN_LED_VOUCHER_ROW_QRY.Account,    GEN_LED_VOUCHER_ROW_QRY.Account_Desc,    GEN_LED_VOUCHER_ROW_QRY.Code_B,    GEN_LED_VOUCHER_ROW_QRY.Code_B_Desc,    GEN_LED_VOUCHER_ROW_QRY.Code_C,    GEN_LED_VOUCHER_ROW_QRY.Code_C_Desc,    GEN_LED_VOUCHER_ROW_QRY.Code_D,    GEN_LED_VOUCHER_ROW_QRY.Code_D_Desc,    GEN_LED_VOUCHER_ROW_QRY

6
T
Do Gooder
8 months ago
juares
Do Gooder (Employee)
juaresDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Crystal Report integration by REST

Hi everybody!Is there some way to set Crystal Report to use OData interface to get data to use in its reports? In other words to use REST API as Crystal Report data source…Thanks in advance   

0
juares
Do Gooder (Employee)
8 months ago
H
Do Gooder
henrique_95173Do Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

CSV file creation in APP9

Hello All,I have a requirement to create a CSV file with the data from a quickreport(select) in IFS9 and write it to a folder everyday. I created a database task and was unable to create the process that creates the CSV file.Regards,Henrique

1
dsj
Superhero (Partner)
8 months ago
V
Do Gooder
VANzalaDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Clarification on "Send Email" Report Rule

Hello. My IFS version is IFS Apps 10 Update 16.I’m trying to use the “Send Email” action in a report rule to change the default email that IFS sends when you share a Customer Order Confirmation. I can change the Subject and the Body, but renaming the attachment and changing who the email is from is not working. The attachment retains the default name “CUST_ORD_CONF_REP_#####.pdf” and the From on the email is the default “noreply@blahblahblah.com”. Is there something special you have to do to make those change?Apologies if this is under the wrong sub forum. Wasn’t sure where exactly this fits.

1
S
Hero (Employee)
8 months ago
R
Do Gooder (Customer)
ronDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to resolve row level security on on access views

Hi ,IFS recommended to use Access views to export data from IFS Cloud environment hosted by IFS.  The recommended user account is IFSINFO. Now the question is, since most data sources have row level security (Company/site/ HR access) some data are not visible to IFSINFO schema user by default. What is the recommendation here ? Q1.  Should IFSINFO be registered as an employee with supervisor access to fetch all  employee data from access view ? Thanks,Rohana         

2
ChanakaEA
Do Gooder (Partner)
8 months ago
P
Do Gooder
PheonixDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Report rule to print only the 1st page of a report?

Is there a way to restrict a report only to print the 1st page ?

2
NiyomalN
Hero (Partner)
8 months ago
D
Do Gooder (Customer)
dkjensenDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

query of invoice_attachment table

How do we see the records in the invoice_attachment table?  I am getting “Query returning data types BLOB/CLOB is not supported.”  I just want to see the company and invoice_id for a specific company.  A previous post mentioned excluding the BLOB/CLOB fields, but not how do to that.  Can someone give me a specific example for excluding those types of fields?

9
D
Do Gooder (Customer)
8 months ago
A
Do Gooder (Partner)
AstTharuCDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR Report - Excel Chart in Separate work sheet

I’ve inserted a chart in a Business Reporter report.  I added the chart as a separate tab.  When I do this, the report doesn’t seem to work.  Are charts only able to be embedded in the same worksheet, not a separate worksheet from the source information?

2
A
Do Gooder (Partner)
8 months ago
J
Do Gooder (Customer)
JustinJDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter client allows access to all reports

I have noticed, when trying solve a users acccess issue for a BR report, that while in IFS Explorer, users can only see and run BR reports that their IFS access allows them to.However, if someone logs in with  the standalone Business Reporter client on their PC, they can access and run all the BR reports in the system, regardless of their IFS user security settings, so the security settings are bypassed altogether.Is this a bug, or is there something that needs configuring in the system to ensure they can only see and run  the same reports in the BR client that they have access to in the IFS Explorer client?IFS Explorer client version: apps 10 update 14, in house installation.Business Reporter client: Apps 10, version 5.0.24Thanks

2
J
Do Gooder (Customer)
8 months ago
G
Sidekick (Customer)
golo.naitoSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Report definition - Design time

Hello,how is it possible to change the design time to “NO”? Otherwise the layout cannot be deleted.Thanks in advance,Golo

2
G
Sidekick (Customer)
8 months ago
S
Do Gooder (Customer)
SPierpointDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Report Designer Training Apps10

Hi, is there a course available for Report Designer, Apps10 that anyone is aware of?I’ve looked on the IFS Academy and there is only a training opportunity for Report Designer - IFS Cloud.  ThanksStacy

1
T
Hero (Partner)
8 months ago
A
Do Gooder (Partner)
addperpesDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

The image used as standard logotype (ifslogbw.gif) overrides other images in the reports

In my report where I have issues with images I have the standard logotype in the report. It has been added via the Aurena Interface under the tab LOGOS. Furthermore I have added another image to the report. This has been added “IMAGES” with another name.When running the report with the standard logotype in the database the image for the standard logotype is displayed both in the area of the standard logo and in the area of the other image.If I remove the standard logo from the database the other image will be displayed as expected, but I also want to have the standard logo in place, but the standard logo seems to replace other images when it’s stored in the database.Has anybody experienced this issue. Is it a bug?  

1
T
Hero (Partner)
8 months ago
R
Hero (Customer)
ronhuHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Flat LCD/LED Panel to show IFS Lobby Transport Task Info

Community,We are planning to set up couple flat LCD/LED panels to show the lobby info about inbound/outbound transport tasks and their status. questions:does each panel need a IFS user id?  which lobby out of box will have transport task info? how to set up lobby as the only info on the flat panel? any documentation available?Thank you.

0
R
Hero (Customer)
8 months ago
N
Do Gooder (Customer)
NPHAHMEDJUMADo Gooder (Customer)
posted in Insights (Business Reporter and Analysis Models, EOI)

NO PDF Report Returned from Crystal web services-App10

Hi,We have App10m we are getting this error Maytime's and we done most of the recommendations like:Take the initpub backup.Uninstall the crystal services.Re install crystal service from new zip in IFS instance folder (install CWS from IFS Home)Restart the IIS.Retry generating the PDF reportNothing work!!!!We created 8 instances for crystal to make load balance also it’s not working!!!!Also we checked log file and nothing there    

0
N
Do Gooder (Customer)
9 months ago
pasana
Sidekick (Employee)
pasanaSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Can not export quick report result to excel

Issue Can not export quick report result to excel if the report have a bind variable and I leave it empty. For example, if I have a where statment like this: where company like nvl('&Company', '%'). If I run the report in IEE and leave it empty it works fine. But if I try to export it to excel I get the error "Stream was not readable".Product Version: Apps10 UPD19  Resolution Identified this as a bug, and this is fixed in APPS10 UPD20.

0
pasana
Sidekick (Employee)
9 months ago

Badges

Show all badges
Terms & ConditionsCookie settings