Insights (Business Reporter and Analysis Models, EOI)

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

  • 555 Topics
  • 1,567 Replies

555 Topics

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
ZTC ZTC JGOTA
Hero (Customer)
ZTC ZTC JGOTAHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Any Idea about this Crystal Report issue.

After I run a report I am getting the following message:  Any Idea how could I fix the error? 

2
ZTC ZTC JGOTA
Hero (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
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
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter and multiple Information Sources

Is it possible to create a Business Reporter report using information from multiple data sources?Any information will be greatly appreciated.Thank you.

3
BEKEDE
Sidekick (Employee)
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
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)

Lobby -- INFO SOURCE -- data souce -- We have IFS-9

I am wondering how could get the INFO SOURCE data source type to have dropdown option for parameters.  

2
ZTC ZTC JGOTA
Hero (Customer)
2 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR Execution Server Error - Template has design errors. View trace file for more details

BR Execution Server Error - Template has design errors.  View trace file for more detailsI located the Error folder and extracted the DSRD file.   Is there an easy way to find where the report is failing. Thanking you.

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

When a user runs a Business Reporter report via Order Reports not data is being displayed

If the report is ran by the report designer or logged in as IFSAPP the BR report displays figures.We have checked that the report has been granted to the appropriate permission set. When the user orders the report using Order Reports the report is processed and a message is displayed prompted whether or not you wish to view the report.   On viewing the report no data is being displayed. Any ideas?

5
R
Superhero (Partner)
2 years ago
S
Do Gooder (Employee)
SASIUSDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Apps10 - SSRS Extension certification for SQL Server 2019

IFSSSRS extension certification question on Apps10.Please let me know if the IFS SSRS Extension is certified for SQL Server 2019 standard edition on Apps10 track. I have seen certification and installed IFS SSRS Extension on SQL Server 2016 and 2017 on Apps10, but I have not seen certification for SQL Server 2019. I have used SetupIFSReportDataExtension.exe file previously for SQL Serve 2016 and 2017 SSRS extension installation on Apps10. 

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

IFS Business Reporter Execution Server

BR reports that have worked previously are erroring stating an error in design.  Having been advised that no changes have been made to the reports.  It was decided to restarted the BR Execution Server as NO BR reports have been processed since the 3rd June.   On clicking Stop the service does not stop and the following error appeared in the Log: An error occurred while trying to stop BR Execution Server.  Reported error is.  The service cannot accept control messages at this time.   How can I stop and restart the service?   The log files appear to go back to the 06/06/2021 and there are a few reports flagged as errored. Any prompts much appreciated.

4
R
Superhero (Partner)
2 years ago
FRSMDE
Do Gooder (Employee)
FRSMDEDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Power BI not running

Hello In our environment (https://ifspsc1-d01.demo.ifs.cloud/) the Power BI reports examples are not running. They worked fine the last days but now you receive a message, it takes to long?Other colleaguers in our DACH team have the same problem

7
A
Do Gooder (Employee)
2 years ago
P
Do Gooder
Pardeep SainiDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

barcode issue in ifs

I have two reports having barcode one is quick crystal report and other one is order report with crystal layout. In quick crystal report barcode is showing in ifs but in order report it is not showing in system. Please suggest solution. Thanks in advanceRegardsPardeep Saini     

5
ChanakaAmarasekara
Hero (Employee)
2 years ago
Srikanth
Superhero (Partner)
SrikanthSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR Execution Server error

Hi,Version - Applications 10 Update 8We recently configured BRES by closely following IFS Documentation. The excel report is getting rendered but without any data. I see the following errors in the BRES log:I tried all workarounds incl. the one for COM Factory Class error but no luck so far.Any direction in this regard is very much appreciated.

4
Srikanth
Superhero (Partner)
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
R
Do Gooder
Rohini SDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS 7.5 Order Report Error

Hi, Trying to execute an Order report in IFS 7.5 but when clicked on report preview option, it throws error as there is no XML  data Code:            ORA-20000Location:     frmInfoServiceText:            formatReport_RequestFormatting: This report has no XML dataORA-06512: at "IFSAPP.REPORT_SYS"This occurs only in case of huge data. Is there any way to rectify this?

8
N
Hero (Employee)
2 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Lead SQL error

Hi, I tried the SQL statement: select *from business_leadAnd then receive the following error message:  Does someone know what this message means and why it occurs? Kind regards,Simon

2
B
Sidekick (Customer)
2 years ago
N
Hero (Employee)
Nalaka SamarasingheHero (Employee)
posted in Insights (Business Reporter and Analysis Models, EOI)

A simple Query Builder Example | Lobby

Basics:Navigate to ‘Lobby Data Source Designer’ and click + then select ‘Query Builder’. Add a name for the data source. Finding a view:Under ‘Search Views’, search Instant invoice. All the columns and references related to instant invoice will list down.  Adding a column and a function:RMB on ‘Invoice No’ and select ‘Add to Columns’. Then the column will appear under the columns section. Perform the same steps for the function ‘Get_Address’. Then search the view ‘Ledger Item’ and add the column ‘Cleared Amount’ as well. Adding a where condition:RMB on ‘Invoice Id’ and select ‘Add to Criteria’. Select the operator as = and insert a selected invoice id. Adding a table join (Inner):Under the joins section, select the Left View as ‘Instant Invoice’ and Right view as ‘Ledger Item’. After that select Invoice Id and company as keys from both views. Final Setup will be as below: Query Result will be as per the attachment. And all the basic functions available for SQL Query Data source can be

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

Quick Report Error when an IFS USER Log in with another language

Hello IFS Comminity,I found a very strange error today. We are currently using IFS 9.1- When the user log in using English language the Quick Report can run normally.2- When the user log in using French language the Quick Report generated an Error.Screenshot Error Error Log  Messages d'erreur du serveur :0db87c89-3718-4b71-b829-87a67a0cec77 Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-00972: l'identificateur est trop long Failed executing statement (ORA-00972: l'identificateur est trop longORA-06512: à ligne 12)   à Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)   à Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)   à Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, Fn

8
ZTC ZTC JGOTA
Hero (Customer)
2 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Create custom field in register arrivals from Part/No Part order lines

Hi,I created two Custom Fields, one in the view PURCHASE_ORDER_LINE_PART and the other in PURCHASE_ORDER_LINE_NOPART. They are identical.I want to display the values in one custom field in the view RECEIPT_INFO_ALT, because in the menu ‘Register Arrivals’ both Part and No Part order lines are displayed. But I am not able to display the value from the custom fields in the menu ‘Register Arrivals’.Does someone know how to make this work? Whe are on apps10 update 7. Kind regards,Simon

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

IFS Security - Quick Reports-IFS9

I can see different user in my company when they access the Reporting/Ad-Hoc Reporting they can see Explore Quick Reports. However, I can see others do not see the Explore Quick Reports options.When I try to see the data Source I found tbwQuicReportsListWhen I go to the Presentation Object Grants I can see the Permission Sets granting ‘Quick Reports’Permission Set FND_ENDUSER  However, all the user in my company have FND_ENDUSER, Why other can see Explore Quick Reports and why other cannot see Explore Quick Reports?How can I make Explore Quick Reports visible to other? 

3
ZTC ZTC JGOTA
Hero (Customer)
2 years ago
S
Hero (Customer)
sholmesHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Apps9 Report Rules

Help! I’m new to report rules and I want the company and the customer to decide what print layout to use. I’ve created simple one expression rules that work but I’m struggling to get two expressions to work. Below is what I’ve written and the error message I’m getting. If anyone can guide me that would be very appreciated. 

3
Tharindu Illangasinghe
Superhero (Partner)
2 years ago
S
Do Gooder (Customer)
SEFILLADo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Embedded browser IFS Enterprise Explorer

Hi there,Is it possible to set or change embedded browser in IEE?We are currently running IFS 10 UPD 6 (should probably update soon), but want to change from the “Internet Explorer” version or whatever it is to another browser. Where is it set?Best regards,Filip

7
william.klotz
Superhero (Customer)
2 years ago
hhy38
Hero (Customer)
hhy38Hero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to visualize values with comma separation on Line Chart Element?

We are using App 9.4. We could not visualize the line chart with comma separation. We tried many types of data sources. It did not affect anything. In the pie chart, everything works fine. We tried to_number, round while getting data but still the same. How can we visualize with comma separation?  

3
Minoshini Fonseka
Superhero (Employee)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings