Insights (Business Reporter and Analysis Models, EOI)

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

  • 557 Topics
  • 1,572 Replies

557 Topics

D
Do Gooder
darrenb3981Do Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Group BA Reports Together in apps9

Hello all, Wondered how you can group BA reports together in IFS?For example if I had seven or so finance BA reports and wanted to have them all in a Finance folder in IFS how would I do this?  The above is probably a really simple answer but interested to learn how.thanks allDarren

0
D
Do Gooder
1 year ago
P
Do Gooder (Partner)
pulkit.guptaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

"stream not readable" error

When I try to preview the report in excel output - order report. Then after ~10 mins system pop up “stream not readable” error. 

1
S
Superhero (Customer)
1 year ago
G
Do Gooder (Customer)
giovi2012Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Experiences with the "in memory" deployment

Hi All, It should be possible to run IFS “in memory”, this means the data-entry tables will run fully in memory.You will be able to select the tables which run in memory. This is facilitated by Oracle.I am curious whether someone has experience with this mode of running parts, or total IFS , in memory. Questions like:Will analytic background jobs run faster? Do you notice differences in data-entry? Do you notice differences in your analytic environment? Thanks in advance,Johan

0
G
Do Gooder (Customer)
1 year ago
jzouaoui
Sidekick (Customer)
jzouaouiSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Object Scann in Ifs aurena

Hello, i added an operational report from ifs developer Studio . and i don’t know how to launch Presentation object scann in aurena to scan the source Code  .  In IEE we have the screen below :  Thank you in advance.

2
jzouaoui
Sidekick (Customer)
1 year ago
J
Do Gooder (Customer)
Jeaneane L.Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Relations for Facts

Hi,I was working with an IFS employee for over an hour last night and they got stuck trying to add a new item to an information source for me. Specifically, I need to add Receipt Line Status into the Purchase Receipts Information Source. The SQL used is listed below. The item was created and populated in my information source but when I ran the report it was blank. I have a strong feeling it is because of Source Ref 4. We have no data in there and my understanding is this is an optional data source we can assign to anything. I do not believe we ever did. I need to know if the Source Ref 4 Fact ID is the item in green below, if not what is it?  RECEIPT_INFO_API.Get_State(RECEIPT_INFO_API.Get_Receipt_Sequence(:source_ref1,:source_ref2,:source_ref3,:source_ref4,'PURCHASE_ORDER',:receipt_no))

6
J
Do Gooder (Customer)
1 year ago
T
Sidekick (Partner)
tjudeSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

PrintJob Error Message

Hi All, Can someone explain the above message that I get with a PrintJob Error? Haven’t received anything like that earlier.  Thank You

0
T
Sidekick (Partner)
1 year 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
Y
Do Gooder
ykuseDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Report Designer colour conditions

Hi all, How can I use colour condition in report desginer?examlple : tns:OCAK_WL_RATIO between 75 and 85  

0
Y
Do Gooder
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
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
A
Do Gooder (Customer)
andreas.lindDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick report not showing in IFS Cloud

Hi! I am using IFS Cloud and are trying to create a Quick report.  After filling in the required information (see picture 1) I press Save and get redirected to the detaild view. But the detailed view is empty (see picture 2). For some reason I can´t see my quick report I just created. From the debuger I can see that a ID is created for the report.  My guess is that this is caused by something related to access. 

1
ChanakaAmarasekara
Hero (Employee)
1 year ago
ismigulay
Do Gooder (Customer)
ismigulayDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Report Designer - Add Condition With Parameter

Hello,I have a report that returns data results by entering parameters.In other words, the report result is displayed when you enter a parameter.If no value has been entered for the parameter, the report should still be displayed.When the parameter is used as a condition in the query sentence where the report draws data, the rows that do not contain data in the column will not appear in the report.I couldn't find how to display them.How should I write the condition in the query sentence? Can anyone help with this please?Sincerely..

2
ismigulay
Do Gooder (Customer)
1 year ago
D
Do Gooder (Customer)
DavMoDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

SQL join error, what am i missing

Hi All, i have a SQL query to join 2 simple datasets, i am receiving an error saying "PROD_STRUCT_ALTERNATE_CFV"."PART_NO": invalid identifierFailed executing statement (ORA-00904: "PROD_STRUCT_ALTERNATE_CFV"."PART_NO": invalid identifierrelates ot the ON part of the statement.If anyone can help i would appreciate it.the basic select query was working before i modified it to include the join from the other table.SQL is as belowSELECT objid,objkey,bom_type,alternative_no,contract,part_no,cf$_total_plastic_weight,cf$_total_regrind_weightweight_netFROM ((SELECT objid,objkey,bom_type,alternative_no,contract,part_no,cf$_total_plastic_weight,cf$_total_regrind_weightFROM prod_struct_alternate_cfv WHERE alternative_no ='*' AND bom_type ='Manufacturing' )LEFT JOIN (SELECT part_no, weight_net FROM part_catalog where part_no is not null)ON part_catalog.part_no_cfv = prod_struct_alternate_cfv.part_no ) 

5
T
Do Gooder (Customer)
1 year ago
jzouaoui
Sidekick (Customer)
jzouaouiSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

disabling Report printed automatically by the sys

Hello ,i have a report that is automatically printed by the system. and I want to disable automatic printing but I don't know where I should go in the set up .Report name : inventory order report Report ID : INV_PART_ORDER_PNT_REP_REPI think  the report is printed when the Mrp is started by a scheduled task . but im not sure Report archive :  Thank you in advance .

8
jzouaoui
Sidekick (Customer)
11 months ago
R
Sidekick (Partner)
Rasmus RaulSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Change Unit Of Measure on reports

Is it possible to change Unit Of Measure on a Customer Invoice depending on language? Can i change Unit of Measure depending on which language there is default for the company or customer?Ex: Currenct functionality - When a Customer Invoice is printed the Unit of Measure on the Customer Invoice is the same Unit of Measure as “Sales UoM” on Customer Order Line. If value in “Sales UoM” is “stk” (danish) how can i change this to “pcs”?.This can be useful if the customer or company is not speaking same language as the standard for unit of measure. 

5
Ozgun BAL
Sidekick (Customer)
1 year ago
D
Do Gooder (Customer)
DMGERBERDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Report Designer 200.2 Labels and Test not showing in Preview

I’m in the process of updating the Standard Invoice reports.  Sometimes when I add a label or text they don’t show when previewing the report?  Anyone have any ideas why this is happening?  

4
T
Hero (Partner)
1 year ago
D
Do Gooder (Customer)
DMGERBERDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Why do some standard report logos not change to stored company logo.

We have set up our company logo in our system parameters.  Our company logo does show up on Invoices but it does not show on Handling Unit Content Label.  What is the difference between the 2 logos below?  

2
D
Do Gooder (Customer)
1 year ago
T
Hero (Partner)
Tracy NorwilloHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is there a fix for Quick Report Date Parameter Issue?

Was this issue reported to IFS and is there a fix to be able to use the date picker for date ranges?@Charith Epitawatta  investigated and advised to open a Case for investigation.  Was this ever done? 

1
Charith Epitawatta
Ultimate Hero (Employee)
1 year ago
Ieva Rituma
Superhero (Employee)
Ieva RitumaSuperhero (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Enabling Drill-Down and Link back to IFS from Business Reporter, any Information Source

Drill-down and a link back to IFS is available as core already for the GL Balance information source. However, we would like to enable the drill-down also to other information sources, including quick information sources. Is this possible? In Aurena, there is a place to set up the Information Source URL but has anyone got experience in setting this up manually for other Information Sources?  

5
V
Hero (Employee)
1 year ago
J
Do Gooder (Customer)
JBumpusDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Individual Efficiencies in IFS10

I am trying to find a way to track employee individual operation efficiencies. I am trying to build a query using query builder to do this. Is there a way to track efficiencies of employees?

0
J
Do Gooder (Customer)
1 year ago
Andryis
Sidekick (Partner)
AndryisSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Serching for lobby education materials on IFS cloud 21R1/2

I’ve got a training of lobby on EE. But I don’t see any material on IFS Cloud. Please help.Thank you in advance

2
cperdue
Hero (Partner)
1 year 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
Dasun Navoda
Sidekick (Partner)
Dasun NavodaSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Version control BR Reports and moving between environments

Hi, There are two questions I’m looking for an answer. What is the standard procedure of version controlling IFS BR Reports? We have 75+ BR Reports and is there any way of version controlling these in IFS Cloud with Git? What is the best way of moving reports between environments (Dev →  SIT → UAT → PROD) in IFS Cloud with a delivery. I found below topic on this. Moving Business Reporter Reports between DBs | IFS Community Is it still the same? We have 75+ BR Reports and it is not practical manually moving between environments. It is also not possible to use Application Configuration Packages with BR Reports. Is there any workaround we can attach BR Reports with the delivery process in IFS Cloud? Thanks in advance. Regards,Dasun

1
V
Hero (Employee)
1 year ago
A
Sidekick (Customer)
aproughSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Information Source Draft with Custom Fields

Trying to create a QIS Draft that utilizes the “_CFV” version of the table so that the Custom Fields are available.  However, due to the fact that a “CF$_” is prepended to the field name and the Created View Definition is not editable to change an alias, the field comes into the Information Source with the CF$_ prefix, which I thought was fine. And the field is visible in the BR, but if you try to put a filter on the field, it errors out, indicating that QFACT_XYZ_CFV.CF is not a dimension or fact.  It appears that the $ in the db field name is being evaluated as a parameter and making BR blow up. Other than writing an IAL where I can alias the field correctly, does anyone know how to get around this issue?

1
Kelum Pradeep Kumara
Superhero (Employee)
2 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

Badges

Show all badges
Terms & ConditionsCookie settings