Insights (Business Reporter and Analysis Models, EOI)

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

  • 551 Topics
  • 1,559 Replies

551 Topics

M
Do Gooder (Customer)
MDDTJAMUDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - Report being used by another process (Shared Directory)

When we save a business reporter generated file to a shared location it initially runs fine then users begin to get to see a message that looks like this: “The process cannot access the file:’Z:\Test Reports\business_reporter_example.xlsx’ bause it is being used by another process.” We have checked the file is not open and ensured the locations used are listed in the Trust center locations. Has anyone else encountered this issue and/or have fix?

4
M
Do Gooder (Customer)
13 days ago
N
Do Gooder (Customer)
nahidDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Report Crystal error

The problem is described in the attached doc file.Please find the problem description in that doc file.

3
Manulak
Hero (Customer)
10 months ago
technice
Do Gooder (Partner)
techniceDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Cloud - Inside Powerpoint or other presentation viewer

IFS Cloud - Is there an inside Powerpoint or other presentation viewer to use directly in lobbies?

1
S
Sidekick (Employee)
10 months 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
A
Alexandra Sidlovska
asked in Insights (Business Reporter and Analysis Models, EOI)

Export from Business Report

Hi,I have a question how to export Business Reporter from Excel To *.ins field?Thanks.

0
A
3 years ago
Thiwanka Sandaruwan
Hero (Employee)
Thiwanka SandaruwanHero (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to control access for a BI access view that is created based on Quick Information Sources

Hi Community, If we need to control access for users who try to get data via BI access views created using QIS in the IFS cloud 21R2, Is there any mechanism to handle it? Best regards,Thiwanka  

1
S
Do Gooder (Employee)
1 year ago
K
Do Gooder (Customer)
kkormDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - Run Multiple Reports at Once

I have a BR report in APPS10 where I’d like to run multiple reports at once. In this example, the report takes a work task number for input and generates several pages for the work task. I’d like to either be able to pass in a list of work task numbers to the report itself or have IFS recursively call the report to produce multiple. Ideally, our end users would like a single combined PDF as well, but I’m not sure if that’s possible in the recursive case.So far, I’ve tried using sheet repeaters when allowing multiple values for work task input, thinking that the sheet repeaters could iterate over the list. This doesn’t seem to work, as the report just returns the design version, with no fields populated.I also tried to dig into the package (XLR_TEMPLATE_UTIL_API) that I think actually executes the reports, but I was struggling to successfully generate a report.Does anyone have thoughts on whether the above points are possible, and if so, how?Thanks!

4
K
Do Gooder (Customer)
6 months ago
W
Sidekick (Customer)
woprhoweSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR Report loses "Conditional Formatting" upon run

We have a report in IFS Apps 10 under IFS Business Reporter that was designed and and implemented over a year ago and up until the beginning of the month work correctly. Now, no matter whether you “Order” the report from within IFS, or launch IFS Business Reporter through Excel, as soon as the report is “run”, the “Conditional Formatting” rules within the Excel worksheet move from “This worksheet” into “Hidden:sheet_1”, even though there are no “hidden” sheets. This only happens when pulling the data from our production system. If we run the same worksheet through BR against any other environment (DEV, TEST etc.), the “Conditional Formatting” rules remain and the selected data that matches the conditions are highlighted as designed. This does not appear to be related to any IFS UPD levels, as we have had it succeed in both UPD8 (TEST1) and UPD12 (TEST2), but fail consistently in UPD8 (PROD).

2
W
Sidekick (Customer)
11 months ago
C
Do Gooder (Partner)
chiranthamDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Unable to retrieve parameters- Crystal Web Service

Hi Everyone,We recently installed crystal web service(x64 bit setup) in one of our client’s server and pointed it to IFS cloud (22R1 Update5) application. We are facing two issues when we are checking the web service functionality after the installation.When we test the web service with a sample layout pointing to the CR layouts location, it doesn’t return a binary response to indicate the connection between the Crystal web service and crystal report. When we execute a crystal report through application, it returns an error like below.  Appreciate your thoughts on this. Thanks!.

0
C
Do Gooder (Partner)
1 year 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)
8 months ago
P
Do Gooder
pendrivedatarecoveryDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Import MSG Contacts into Outlook – DIY Guide for Every User ?

How might Pen Drive Recovery import MSG contacts into Standpoint without burning through much time and exertion? How is feasible to import the information in mass without going through any inconveniences or dangers of Standpoint being crashed or contacts being altered? Indeed, there are different strategies that you might find on the web yet the inquiry is are these techniques effective? You will find that out in this blog.We as a whole realize that a MSG document is a solitary message record that contains every one of the messages, contacts, schedules, and so forth in it. In the event that you independently make a MSG record for contacts, just a single contact will be saved in a .msg document. In some cases, clients might need to import .msg contacts into Viewpoint 2010, 2013, 2016, and 2019, which is the reason we are referencing helpful arrangements here.There will be two simple techniques made sense of in this blog. One is an immediate strategy for bringing in the information which

1
M
Do Gooder
6 months ago
T
Sidekick (Partner)
TopDeepaWSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Analysis Model Installation

I'm trying to install analysis model on IFS race environment but unable to test connection due to following error message. Anybody can help me to resolve this?   

3
Gayan Dasanayake
Do Gooder (Employee)
1 year ago
B
Sidekick
Brijesh410Sidekick
asked in Insights (Business Reporter and Analysis Models, EOI)

Error occured while creating zip file

Hi Anyone faced ‘Error occured while creating zip file’  in BA reports. This came in to picture after upgrading report from BA to Business reporter. Running fine with Apps 8 BA. Thanks in advance..

0
B
Sidekick
3 years ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
posted in Insights (Business Reporter and Analysis Models, EOI)

Display balance with Euro Sign as Prefix

Hi,I created a lobby element which shows the balance of the bank accounts. I want to display the balance with a euro sign as prefix. Is this possible, and when so, how can I do this?I know how to do it with a counter element, but I am not able to do so when using the element below.  

2
B
Sidekick (Customer)
3 years ago
J
Hero (Customer)
JannetteCHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick report export to excel error

Hello all, When I try to export to excel my report I am getting the following error - what does this mean please ? 

1
J
Hero (Customer)
5 months ago
C
Do Gooder (Customer)
CAMHDMSDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Left Join Quick Report Error

I am trying to build a quick report that will pull all of our rework operations that we label with an “R” in our operation description. I cannot get this report to match shopfloor_clockings. It does not pull all of the same shop orders and operations. I started trying to test the database tables individually, but I need a left join in order to filter the content in the operations_history down to the operations with the operation_description found in the shop_order_operations so that I can see that they are working. I get the error that you can see in the screenshot and cannot find a way around it.

2
C
Do Gooder (Customer)
1 year ago
A
Do Gooder (Customer)
atheisenDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Custom Dimension Connections - Permission Issue

I’ve created a Dimension in IFS Apps 10. I’ve then used Custom Dimension Connections to connect the Dimension to the Appropriate Information Source. I can see the Dimension in IFS Business Reporter and add it to my report. When I run the report I get the following error. If I remove the field and re-run the report it runs fine. How do I find that specific item and set the appropriate permissions to it?  

1
A
Do Gooder (Customer)
1 year ago
U
Do Gooder
USLA
asked in Insights (Business Reporter and Analysis Models, EOI)

Filter criteria in BR generate different format

Filter criteria of BR generated different code for different users in same organization. So, it is difficult to share the report among the organization. Is this known bug, limitation or are we use it with wrong settings? Could some one help.Ex User A: In operation request comma separated list  User B:  In operation request semicolon separated list  

4
V
Hero (Employee)
2 years ago
N
Hero (Customer)
NMALKIHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Schedule BR to be sent by mail

Hi, I need to schedule a BR to be sent by MAIL to a distribution list. when I setup a schedule via “Report Schedule”  this report is only available via Report Archive and nothing is sent by mail to the distribution list... even to me if I specify to be sent by Email when finished. what am I missing pleaseThanks   

1
Novacura_jst
Hero (Partner)
1 year 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
C
Superhero (Customer)
cjohnsonSuperhero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Material usage by Work Center

Hello, I have been trying to find a way to view all raw material that is used at a given work center. Ideally, I have reviewed material usage, component where used, but there does not appear to be a way to search by Work Center. I am hoping that there is an area within the system where this data can be viewed. Any help would be greatly appreciated!

2
C
Superhero (Customer)
3 years ago
K
Do Gooder
kpiorunDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

"Order Report" greyed in Operational Reporting / Reports

In IFS10 on ifspp account one of reports in Operational Reporting is not available (C_PAY_GRIDLOCKS_REP). It has greyed submenu options: Order report, Show Archived Reports, Schedule Report, View Schedules. Other reports are available for print. When I try to add it to Report Schedule I got message: Report “C_PAY_GRIDLOCKS_REP” is not available for scheduling for current User (IFSAPP). In solution Manager / Operational Reporting / Report Definitions “Domain” and “Category” boxes are empty.Where can I unblock this report?

4
T
Hero (Partner)
3 months ago
H
Do Gooder (Partner)
himasha.abeywickramaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Analysis Models - Issue in setting up Tabular Models

Hello,I’m trying to set up tabular models IFS_INCIDENT_ANALYSIS and IFS_SALARY_REVIEW_ANALYSIS and it seems it’s missing Fact IDs referenced by above Tabular Models. It gives below error when trying to deploy tables and views to SQL Server, This environment does have some inactive components. Could you please explain the reason behind this behavior? what are the expected components that need to be active?

2
H
Do Gooder (Partner)
5 months ago
InfKristN
Sidekick (Partner)
InfKristNSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Project Structure Report Business Reporter The Given Key was not present in the Dictionary

I am trying to create a simple Project Cost Report using the Project Activity Information Online Source as I done before.I keep getting a The Given Key was not present in the Dictionary. What key, which dictionalry but how would I fix it ? Probably user related as I get it in APP10  nd IFS Cloud 21R2  but user not smart enough to figure it out (ie me) 

0
InfKristN
Sidekick (Partner)
1 year ago
A
Do Gooder (Customer)
a.georgeDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

ANALYZE (analyse) DEMAND DEVIATION

HiPlease could anyone possibly tell me what ‘ANALYZE DEMAND DEVIATION’ does and its impact Thank you

1
CallumW
Superhero (Partner)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings