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,582 Replies

560 Topics

R
Do Gooder (Customer)
rinatszDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - Different criteria (filters) within one repeater

Hello,I work on IFS Business Reporter Excel app and I hope someone could help me with below issue - how should I create design row and repeater, considering that within that specific repeater I’d like to add two different criteria. I’ll try to expain this in details:What do I have:What do I want to present:I’d like to make report showing summary of purchase and shipment accounts for Code_D values as A1, A2, A3 and for specific period (let’s take for example periods from 1 to 2).So basic criteria would be as follows: CODE_D LIKE ‘A%’, PERIOD<=2, ACCOUNT LIKE ‘302%’ (for one block), ACCOUNT LIKE ‘701%’ (for second block)I’d like this data to be shown with the following repeater/order:First - Code D then by:Second - Period (within Code D) then by:Third - two blocks: for purchase and for shipment (both within specific period and Code D, with repeater per account number) So basically I would like to create some design row with repeater and such criteria, starting from something like this

3
V
Do Gooder (Employee)
2 years ago
M
Do Gooder (Employee)
Martin GestingerDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Parent value in BR

Hi, Does anyone know if it is possible to add more parents values in Business reporter to Enter Parameter Values. As you can see in my example now. If I want to choose department value, I need first choose parent value company. Based on choose parent value (Company) I get data for departments, but I would like to add one more parent parameter. But I am not confident how to do it.  

3
Thiwanka Sandaruwan
Hero (Employee)
1 year ago
Dasun Navoda
Sidekick (Partner)
Dasun NavodaSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

List of new Information Sources released in IFS Cloud 22R1

Where can I find the list of new information sources released with IFS Cloud 22R1 release. I checked the release notes and “22R1 Service Updates - Fixes” shared in the community and there is no information about list of new IS’s.

3
Dasun Navoda
Sidekick (Partner)
1 year ago
L
Do Gooder
LOLDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

How to delete a published quick report

Hi,I have a published Quick Report, which now needs to be deleted/unpublished. The only options available to me are shown below:Is there a procedure I can follow to delete or unpublish an existing Quick Report? 

3
L
Do Gooder
2 years ago
L
Do Gooder (Partner)
LakmaADo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Error: JVM required 1.4. Detected 18.0.1

While I launch IFS Report designer tool I am getting this error.  Here is my java installed details Please help to solve this error.Thanks 

3
Charith Epitawatta
Ultimate Hero (Employee)
1 year ago
B
Sidekick (Customer)
BillatREMSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick report Export to Excel Menu item?

I have a “Right Mouse Button” menu item to generate a quick report.  Is there a way to have a menu click automatically generation the Export to Excel function for a quick report?  My user has to click several more buttons to send it to excel and that is what I want the menu item to do. We are on Apps 10, Update 10

3
V
Hero (Employee)
2 years ago
T
Sidekick (Partner)
TopDeepaWSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Multiple Values for Function Parameter

Hi,I have created a parameter “&Activity” for getting project activity short name. (Figure 1).And also created function parameter “&Activity_2”  because “&Activity” is not mandatory while running the report (Figure 2).After I checked “multi value” checkbox of “&Activity” and also changed operator to “IN” for holding multi values in filter criteria (Figure 3). When running report with multiple values its showing blank pageAnyone can help me to solve this problem? 

3
T
Sidekick (Partner)
2 years ago
D
Do Gooder (Customer)
DMGERBERDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Drill Down not showing Query Voucher hyperlink

So I’m currently in training for Business Report and have activated Drill Down, but when I select a row from the ‘drill down’ temporary worksheet I don’t get the hyperlink to Query Voucher Rows or Details?

3
D
Do Gooder (Customer)
2 years ago
I
Do Gooder (Customer)
ioana.ionescuDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Unexpcted error in IFS Business Analytics Report: System.OverflowException: Not a legal OleAut date.

I am getting the following error while running  an IFS Business Analytics Report. I am using a custom SQL Source to get some Project Management info.  It was working perfectly fine for almost a year.  System.OverflowException: Not a legal OleAut date.at System.DateTime.TicksToOADate(Int64 value)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.ParseValue(Datatype type, String value)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportExecutionMgrOld.CreateDataSet(DsrdResultSet resultSet, ArrayList physicalDataSets, ReportGenerator generator, String separator, Int32& recordCount)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportExecutionMgrOld.PrintReport(Dsrd dsrd, XlrTemplate template, ArrayList physicalDataSets, Exception& exception, Int32 lastDataSetId)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.ExecuteReport(Exception& exception, Boolean cacheEnabled)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.

3
S
Superhero (Customer)
2 years ago
H
Do Gooder (Employee)
HavasDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter : using an entered value as filter

Hi Is it possible to enter a value in a cell and use it as a filter. See attached file.Regards Jean-Christophe

3
B
Superhero (Employee)
2 years ago
A
Do Gooder (Partner)
AddOscarCDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Functional Parameter BR - Next Business Plan ID

What function do I use to create a functional parameter that replace for example business plan id F2022Q1 with F2022Q2, i.e. next courter?If the business plan id would be a number value I could use function ADD but business plan id is a string and I can’t use it as a parameter value as number?

3
B
Superhero (Employee)
2 years ago
K
Do Gooder (Customer)
Kandi GeorgeDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter insight

Who can I contact to learn more about Business Reporter? 

3
V
Hero (Employee)
1 year ago
cperdue
Hero (Partner)
cperdueHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Pay Method

Hello, All- Trying to create a single supplier payment file for check & ACH (paid via 3rd party - Paymode).  The required file is a csv mixed with a pipe separator.   Any suggestions for creating a mixed output file type? Best-Christy

3
O
Hero (Employee)
2 years ago
J
Do Gooder (Customer)
jcostaDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Table View

We are in the process of migrating to Aurena and are in the design process. When we go to different screens with in the system, we have to change to table view every time to see all the info we need. Why isn’t the table view the default view?

3
K
Hero (Partner)
1 year ago
S
Sidekick (Customer)
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.

3
Charith Epitawatta
Ultimate Hero (Employee)
2 years ago
C
Sidekick (Customer)
Christian CordiusSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Report how to search on multiple suppliers

How can i write an expression/query so it’s possible to search on multiple suppliers? Right now my Quick Report only works when one supplier is searched on. See image:Quick Reportselect sig.supplier_id          , sig.name AS "Supplier Account Name"          , sia.address_id          , sia.name AS "Supplier Name"          , sia.country          , sia.address          , sia.address1           , sia.address2          , sia.address3          , sia.zip_code          , sia.city          , se.buyer_code          , PURCHASE_BUYER_API.GET_NAME(se.BUYER_CODE) AS "Buyer Name"          , PURCHASE_CODE_API.Get_Description(se.PURCHASE_CODE) AS "Supplier Category"          , cm.name          , cm.description          , cm.method_id          , cm.value          , cm.method_default          , cm.address_default          , cm.valid_from          , cm.valid_tofrom supplier_info_general sig        left outer join supplier_info_address sia on sig.supplier_id = sia.supplier_id        left outer join supplie

3
C
Sidekick (Customer)
2 years ago
M
Sidekick (Customer)
m.arifSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business reporter error

While opening business reporter , i am getting an errror like “Object reference not set to an instance of the object “ ,  it was running till yesterday. 

3
M
Sidekick (Customer)
2 years ago
K
Do Gooder (Customer)
K.mitchDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Custom Field not Available to use in Lobby SQL

I have a custom field on the Inventory Transactions History Screen which I want to use as Criteria within a lobby datasource.  (Product Family=’1000’) however I am getting error of Invalid Identifier.  When I select * in SQL Developer or in the SQL query tool this custom field also is not available. What would be the best way for the custom field to effectively show in the database so I can use the needed criteria? Many Thanks Kirsten

3
K
Do Gooder (Customer)
2 years ago
A
Sidekick (Customer)
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 

3
A
Sidekick (Customer)
2 years ago
Mark.Feldpausch
Sidekick (Customer)
Mark.FeldpauschSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - Filter Design Column without a Repeater?

Is it possible to filter a design column or row without having a repeater?  Every time I try to do this, my filter gets wiped out.Here are the steps I’m taking: I create a design row with a repeater and add filter criteria: The design column name and filters.  I delete the repeater because I just want one column - I don’t want the data to repeat. The repeater that I originally had. After I deleted the “repeater”  I click out of the column and then come back to it - my filter criteria is gone. The design columns and parameters are gone. 

3
Mark.Feldpausch
Sidekick (Customer)
2 years ago
T
Do Gooder (Employee)
ThejanJayDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Question on loading data from IFS Cloud to existing Data Warehouse

A customer has custom data warehouse built in MS SQL server that they are using with multiple internal systems for reporting purposes. When using IFS Cloud they want to keep using the same data warehouse solution.What is the best way of loading data to their existing data warehouse from IFS Cloud at the database level?Is it possible to use Access Views for this purpose? if so are there any benefits of using access views for this rather than using Oracle views with direct DB connection?

3
S
Do Gooder (Employee)
1 year ago
khajeewak
Sidekick (Partner)
khajeewakSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

SMTP SendAsDenied Exception when sending email via Print Dialog

Hi All,When we try to send email using print dialog email function. (IFS Application 9)We are getting the following error. Any idea how why we are getting this and how to fix it?Thank you,Jeewan

3
khajeewak
Sidekick (Partner)
2 years ago
S
Sidekick (Employee)
ShouSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - Interactive Structures

Hi, with the following webcast (IFS Internal )https://web.microsoftstream.com/video/87b365f9-8392-4fdc-aa9b-4b2e983b761aI know IFS Businss Report have a new feature called  “Interactive Structures“ from APP10 RTM. while, currently even I’m using APP10 UPD10, I still cannot see such option in my Desing Row: Can anyone tell me how to enable this feature?

3
V
Hero (Employee)
2 years ago
Y
Do Gooder (Customer)
yasirsardarDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS business reporter "you are not licensed to use IFs Business reporter

when i install ifs business reporter to any user it raises this error while running the report. sometimes it work but mostly user receive this error, specially with the user with fresh installation.   

3
Y
Do Gooder (Customer)
1 year ago
M
Do Gooder (Customer)
MDGDAUPHINEEDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Move a field in Report Designer 21.1.1.0

Hi,I am trying to move a field in report designer. I am using the alt key to move it like the documentation says but either it won’t move or i make the cell bigger. Is there any easy way to move a field. We have hidden a few fields to make more room and now would like to move the fields over. This reporting tool is very frustrating. Any help would be great.CheersMaggie

3
J
Hero (Customer)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings