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

557 Topics

ProThushA
Do Gooder (Partner)
ProThushADo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

What BI Reports are Available for Manufacturing

We are interested on What BI Reports are Available for Manufacturing customers. Appreciate if you can guide us where we can find BI Solution in each Product in IFS.

1
O
Hero (Employee)
2 years ago
A
Sidekick
AdarshSidekick
asked in Insights (Business Reporter and Analysis Models, EOI)

Send order report to user via Report rule automatically?

Hi Community,  Kindly assist us in sending an order report to the user via Report Rule automatically in particular condition,(IFS 10). Anyone has know about this topic ,pls share your experience. Thanks in advance

1
Rusiru Dharmadasa
Superhero (Employee)
2 years ago
A
Do Gooder (Partner)
AIDA LOTFIDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

EOI

Hi,  If IFS will continue to support on IFS EOI? kind Regards,Aida.

1
O
Hero (Employee)
2 years ago
ZTC ZTC JGOTA
Hero (Customer)
ZTC ZTC JGOTAHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is Crystal Report 2016 supported by IFS 9? Where Could I see the list of Crystal Reports versions supported by IFS?

I am looking to upgrade to Crystal Report version 2016, I read the Crystal Report version 2020 is not supported 100% by IFS 9. I am currently using IFS 9

1
Randini Jayasundara
Superhero (Employee)
2 years ago
ZTC ZTC JGOTA
Hero (Customer)
ZTC ZTC JGOTAHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Where could I find the data used to send email from the Report Format & Output window?

Hello IFS community, In the “Report Format & Output” window, a check box to send E-Mail. Where could I find the data used to send the E-Mail?for example=> The E-Mail bodyIs it possible to update the e-mail body sent by E-Mail?    

1
Asela Munasinghe
Superhero (Customer)
2 years ago
G
Do Gooder (Customer)
GTGesDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

CR_WEB_INIT location

Hello,I am developing a quick report in IFS. I know that CR_WEB_INIT has to be added however I am not able to locate it. Please advise under which category it should be. I looked everywhere especially under shaw1app.  Thank you!

1
ChanakaAmarasekara
Hero (Employee)
2 years ago
eqbstal
Superhero (Partner)
eqbstalSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is Business Reporter navigator supported in Aurena?

I was wondering. In IEE we have:Is this part of IFS Business Reporter already available in Aurena?Is the equivalent the following: 

1
J
Superhero (Employee)
2 years ago
T
Do Gooder (Partner)
TecAnujpGDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Xpath input in report rule not working in Aurena

Hello,When we pass a XPATH value in Report Rule-->Actions for type ‘Set Property’ , the report works fine in IFS EE but not in Aurena.(Apps 10)The Xpath fetches a number for property list ‘Copies’NOTE: If we pass a number for Copies directly , it is working Ok in IFS EE as well as IFS Aurena. Below output when xpath value is used in ‘Copies’:In IFS EE:In IFS Aurena:  Can someone please help us on this. Thanks

1
mattconk
Sidekick (Partner)
1 year ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR Execution Server Error

The following error appeared at 01:19 in the morning when hardly anyone was on the system.The report is scheduled to run.Template rendering Exception:  Unexpected error while calling server method OrderXlrReport/SaveRenderedReport, Exception of type 'System.OutOfMemoryException' was thrown.. Error not related to report design. Therefore report not saved to error folder. Last successful execution log entry: Template file ORDER_INTAKE_AND_SALES_V1_1(215169) closed Any ideas how I can get to the bottom of the “System.OutOfMemoryException” error?Thank you. John 

1
Thiwanka Sandaruwan
Hero (Employee)
2 years ago
U
Do Gooder
USLA
asked in Insights (Business Reporter and Analysis Models, EOI)

BR writeback Error

Receive the below error when save. No any error/compilation issue in Database object of writeback interface. Where should I check? 

1
U
Do Gooder
2 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Creating Email alert when the IFS BR Execution Server stops

Does anybody know whether it is possible to create an email alert that should fire when IFS Business Reporter Execution Server status stops. I tried to create an alert on XLR_BAES_TAB when Active = 0 but when the Business Reporter Execution Server stops on the Report Server the XLR_BAES_TAB Active column isn’t changing from 1 to 0. Any advice would be much appreciated.

1
V
Hero (Employee)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Shop Order Pick List missing Master part number

IFS10-UPD9Shop Order Pick List is missing Master Part number (highlighted in yellow), Is there an easy way/ setting we are missing to print main/master part number on the pick list?Is modifying report the only option we have? Thanks

1
Björn Hultgren
Hero (Employee)
2 years ago
Eric FOULART
Sidekick (Employee)
Eric FOULARTSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS BR - Impossible to uninstall 21R2

Hi allafter having this error message “This Add-in is installed for all users on this computer and can only be connected or disconnected by an administrator”, I was no longer able to open my IFS BR Reports created.I uninstalled IFS BR 21.2.0.0 (installed before with the MSI) … and I installed again IFS BR .. but I always have the same issue.I follow the topics named “IFS BR issue with Office 365”.I have installed IFS BR as administrator but I always have the same message : Operation Cancelled (Exception of HRESULT : 0x80004004 (E_ABORT)it’s very strange because 1 hour before it’s running well, but after a Microsoft Crash, … I have this issue.Please contact me asap I really must use IFS BR and reports for an important presentation this week./RegardsERIC 

1
Eric FOULART
Sidekick (Employee)
2 years ago
saiful
Sidekick
saifulSidekick
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Report Generation Failure.

 Showing this error when I going to generate a business report .  what type of error it is? how can I solve it ? please suggest me.Thanks in advance.Saiful.

1
S
Do Gooder (Partner)
2 years ago
T
Sidekick (Customer)
tombowe77Sidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Multiple values in Business Reporter parameter field?

Hello, Is there a way to pass multiple values in a given parameter in report designer (apps 10)?  For example, if we add ‘supplier id’ as a parameter and the user wanted to get three suppliers (2654, 1759, 1953), is there a way to pass all three values in a single parameter that the report could then parse out to get the results?  If yes, is there an out-of-the-box IFS report where I can see it working?Thanks,Tom Bowe

1
Thiwanka Sandaruwan
Hero (Employee)
2 years ago
Thiwanka Sandaruwan
Hero (Employee)
Thiwanka SandaruwanHero (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to get GL balance from GL cube when having an opening balance?

Hi,I have an unclear area on the General Ledger cube in APPS9. When we have an opening balance for any year it will insert under the 0th accounting period key. And If we want to take the value for the opening balance from the “Dm_FACT_GL_BALANCE” table we will have to use the 'BALANCE_OB' field instead of the 'BALANCE' field.Assume we have an opening balance for a company in 2019, My question is when I need to get the GL balance for the 2019 year what is the measure I need to be used? It seems the balance measure gives the wrong value.If you have any information regarding this matter please let me know. Best Regards,Thiwanka Sandaruwan

1
B
Do Gooder (Employee)
2 years ago
Link
Superhero (Customer)
LinkSuperhero (Customer)
posted in Insights (Business Reporter and Analysis Models, EOI)

Create read only permission set in IFS Aurena

Dear community,I want to create a permission set without any write permissions in IFS Aurena.first step:second step: But my permission set is empty:If I grant write permissions then everythink is fine.How I can I create a permission set only with read permissions? Thank you

1
william.klotz
Superhero (Customer)
2 years ago
waidyah
Do Gooder (Partner)
waidyahDo Gooder (Partner)
posted in Insights (Business Reporter and Analysis Models, EOI)

Case Statement Returning the same Value in many Instances

The requirement was like this:       CASE          WHEN SUBSTR(PART_NO, 1, 2) IN('XX', 'YY', 'ZZ')  THEN           SUBSTR(PART_NO, 1, 2)         ELSE           'SP'       END CODE,See also >>multiple values in case statement | Toolbox Tech

1
M
Sidekick (Customer)
2 years ago
ZTC ZTC JGOTA
Hero (Customer)
ZTC ZTC JGOTAHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Crystal Report XI R2 - Crystal Report is asking for log info

Hello Community, I have an issue all the time when I try to run a crystal report in IFS is asking for log-in information. See Fig 1for details.I read that I need to add ( \ ) for table and (\\) for view. See Fig 2.  I already ran the script for Crystal XI R2 to be able to add the InvalidAlias and I was able to rename the tables. See Fig 3. However, when I try to run the report one more time still asking for log in information one more time.What else do I need to do? Please, I need help :-( . FIg1Fig 2Fig 3 

1
ChanakaAmarasekara
Hero (Employee)
2 years ago
U
Do Gooder (Customer)
Urvakshh.AvariDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is there a way I can generate customised reports in IFS ?

Is there a way I can  generate customised reports in IFS ?For Example , A quick Report is required to monitor all Cost Types. 

1
X
Superhero (Employee)
2 years ago
Thiwanka Sandaruwan
Hero (Employee)
Thiwanka SandaruwanHero (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

LOVs not working when ordering BR reports from IFS Enterprise explorer

Hi, When creating a BR report the developer has used quick information source which containing the "DIM_ACCOUNT" and “DIM_COMPANY” standard dimensions. Inside the report design, there is a parameter for the account. Since the company is the parent of the account, They have used a company parameter as well.when the user orders that report from IEE, There is no LoV option for the account parameter. When ordering it through the business reporter excel add-on, once click the LoV option of the account parameter it will pop up the company LoV as a prerequisite. (Please note that there is a separate parameter for the company and the user should select the values for the company before selecting the account parameter)This company and account parameter LoVs properly working for some BR reports. Therefore I have compared the dimension joins of both information sources and there is no considerable changes.If you have any suggestions or information regarding this matter please let me know. LoV – L

1
N
Hero (Employee)
2 years ago
chrisbrigg
Sidekick (Customer)
chrisbriggSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Reporter Error "External component has thrown an exception."

Hello,One of our users recently reported an error when trying to run a BR report, both locally on the PC from within the BR app *and through IFS IEE. The user was able to run the report with no issues within the last year and this started about three weeks ago. I can run the same report with no issues from my PC. We tried to re-install IFS BR w/ pre-reqs but the same error message still occurs.*EDIT: The user reported they can run the report successfully from within IEE.We’re looking into other factors such as if an application was recently installed that may be conflicting with BR but that seems unlikely. Has anyone else experienced an error similar or know how we might go about troubleshooting this further?    

1
V
Hero (Employee)
2 years ago
R
Sidekick (Customer)
rvanden5Sidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Putting Custom Designed Report in place of IFS Operational Report

I have created a complete custom report (.Report, .RDF, .RDL, .XML) through IFS Studio Report Designer to replace the IFS PO Report.  There were just to many things we wanted to change to make it economical to change the inherent IFS Report.  Is there a way to change to the custom report so that the inherent IFS calls (like the RMB on the purchase order to print the work copy) calls the custom created report rather than the IFS Canned Report?  We are using IFS10.I am not talking about going to the report definition and just swapping in a new layout, that question has already been answered.

1
R
Sidekick (Customer)
2 years ago
mzislam
Sidekick (Customer)
mzislamSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Want to use multiple layout in supplier check

I want to use multiple layout to print supplier check. Like one check with “AC PAY ONLY”  in the left top corner of the supplier check, another one will be without “AC PAY ONLY”.How I can do it? 

1
ChanakaAmarasekara
Hero (Employee)
2 years ago
L
Hero (Customer)
ludovic.rougeanHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter error related to Zoom In

Hi,Did anyone face such error when performing Zoom In function in a BR report?The Oracle error "-1691" occurred when inserting report data into the report table - " unable to extend lob segment IFSAPP.SYS_LOB0000070775C00005$$ by 1024 in tablespace IFSAPP_LOB" That’s a quite simple report that queries the GL Project Transaction aggregating values by Code C for a specific project and specific period. If i try to zoom in it generally produce this errors, however it actually worked a few times with some lines. It seems that it works if only very few data are within the Zoom In (= only few lines).

1
L
Hero (Customer)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings