Insights (Business Reporter and Analysis Models, EOI)

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

  • 553 Topics
  • 1,562 Replies

553 Topics

N
Do Gooder (Customer)
NPHAHMEDJUMADo Gooder (Customer)
posted in Insights (Business Reporter and Analysis Models, EOI)

NO PDF Report Returned from Crystal web services-App10

Hi,We have App10m we are getting this error Maytime's and we done most of the recommendations like:Take the initpub backup.Uninstall the crystal services.Re install crystal service from new zip in IFS instance folder (install CWS from IFS Home)Restart the IIS.Retry generating the PDF reportNothing work!!!!We created 8 instances for crystal to make load balance also it’s not working!!!!Also we checked log file and nothing there    

0
N
Do Gooder (Customer)
8 months 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
pasana
Sidekick (Employee)
pasanaSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Rowkey in quick_report_tab is empty

Issue After upgrade from IFS8 version to IFS Cloud table quick_report_tab has empty rowkey column. With this it is impossible to assign report to ACP package. Resolution Running the below query will solve the issue,UPDATE QUICK_REPORT_TAB SET ROWKEY = sys_guid() WHERE ROWKEY IS NULL; Permanant solution has been implented in 23R1.

0
pasana
Sidekick (Employee)
8 months ago
pasana
Sidekick (Employee)
pasanaSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick report based on query designer without parameter fails

Issue When creating a quick report based on query designer and that query does not have parameters, it is not possible to create the quick report.The error message is :11:29:11 TRACE - DATABASE {"origin":"DB","indentation":"8","time":"195915004","category":"CALLSTACK","level":"DEBUG","type":"","text":"__anonymous_block at line 2 QUICK_REPORT_HANDLING_SVC.DO_CHECK_QUERY_DESIGNER_SQL_ACTION at line 939 QUICK_REPORT_HANDLING_SVC.CHECK_QUERY_DESIGNER_SQL_ACTION___ at line 4543 QUICK_REPORT_API.CHECK_QUERY_DESIGNER_SQL__ at line 2807 ERROR_SYS.APPL_GENERAL at line 339 ERROR_SYS.RAISE_APPLICATION_ERROR___ at line 129 ERROR_SYS.RAISE_APPLICATION_ERROR___.FORMAT_CALL_STACK___ at line 123 "}11:29:11 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"195915004","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Calling method: Server_Log_API.Log_Server_Error_"}11:29:11 TRACE - DATABASE {"origin":"DB","indentation":"8","time":"195915004","category":"FRAMEWORK","level":

0
pasana
Sidekick (Employee)
8 months ago
C
Do Gooder (Customer)
ColtonTheChemistDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Copy list of product codes into quotation lines from Excel

How Can I quickly copy several rows of product codes into sales quotation lines instead of going row by row adding a single product code then waiting for it to populate? I often have 30-60 product codes to fill in.

0
C
Do Gooder (Customer)
9 months ago
G
Sidekick (Customer)
golo.naitoSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Report definition - Design time

Hello,how is it possible to change the design time to “NO”? Otherwise the layout cannot be deleted.Thanks in advance,Golo

2
G
Sidekick (Customer)
8 months ago
K
Do Gooder (Customer)
KPalmieriDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR Single Filter Issue

Hello! We are having Business Reporter issues where a given report is filtered for one of our “Companies” and the report does not run yet the same report where we have the filter set for two or more of our “Companies” and the report runs… Seems odd to us and we have altered the single filtered company report in a few ways and no go over all. Curious if this could be a software version issue as we are on BR Product Version: 5.0.23 Any thoughts anyone?Thanks

1
T
Hero (Partner)
8 months ago
T
Sidekick (Partner)
TopDeepaWSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Column Grouping IFS Business Reporter

Hi, I have added a grouping for repeated column (D Column) in business reporter. It works in design mode but when running the report, it is not working. See the below images for reference.Any idea about how to collapse repeated columns in BR? Before runningAfter Runing 

5
SandT
Hero (Partner)
9 months ago
O
Sidekick (Customer)
odhcomIfsSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Power BI element in lobby

I am having a hard time figuring out the setup to use elements of a PowerBi report inside a lobby. Is there a guide for this? 

3
E
Do Gooder (Employee)
9 months ago
H
Sidekick (Customer)
HousseinySidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

how to filter on multiple items in message box (SQL)

I have the below line in SQL query where the user could write only one company or % for all. Is there a way to enable multiple values like we normally do in any view filter by ;?  I need this to be a parameter variable based on the user input and not fixed in the query itself. COMPANY LIKE NVL('&COMPANY', '%') regardsHousseiny

0
H
Sidekick (Customer)
9 months ago
Maja Stanislawska
Sidekick (Customer)
Maja StanislawskaSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to get a list of saved queries from Apps10?

Is there a way to get a list of saved queries (with the query string) from Apps10?How could it be achieved?

6
B
Do Gooder (Customer)
7 months ago
Chamaka Wimalarathne
Hero (Partner)
Chamaka WimalarathneHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Using multiple page Contexts for a user

I want to have a Custom context for a user group so I created one . And out of that group I want just one person to have a different lead page than other users .Something like below But when I create it as below . Is there a way to give priority to contexts . To use a logic like this …check the context chamaka is in the page , if not use the context pagero ..cant the context to be page oriented ?

2
EntNadeeL
Hero (Partner)
9 months ago
G
Superhero (Partner)
gumabsSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter 2 Information Source Issue

Hello BR experts,I have created a business reporter based on structure where I am trying to compare GL and IL Balances. Column HFM Balance is using source Internal Ledger Balance and Statutory Balance is using GL balance.When I defined a filter for Ledger ID on HFM Balance column, report gives me error shown on the screen shot.The only way to apply a filter is on cell level. But I am afraid it will reduce report generation time if I apply filter for each cell in the report.Basically my question is how to enter the filter that will bypass this error?   ThanksFurkan

8
G
Superhero (Partner)
1 month ago
H
Sidekick
HananeSidekick
asked in Insights (Business Reporter and Analysis Models, EOI)

Custom event on customer order

Hello everyone ,  I need to create a custom event that triggers when the status of the customer order is closed .My problem is that I can’t find state column ( sql column for status ) in the list of column available in customer_order_tab .PS : I can find it in the view but not in the table  Does anyone have an idea how to get it ? Thank you in advance.Hanane

5
H
Sidekick
10 months ago
N
Hero (Customer)
NMALKIHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is it possible to have a schedule event that trigger BR

Hi Everyone,We were able to schedule BR and send it to users by mail directly, but our request now is to schedule a BR to be send to PMs of active projects (we have around 100 projects).If I do it via Scheduled Reports, I will have to create 100 schedule reports and keep updating them every time PM change, new project created or another one closed...Project_ID is a parameter for the business Report.Not sure if there is a way to schedule a database task that lunch a custom event and in the event to trigger/ call a Business report (which function to call?)… then maybe send a link to the report archive or attach it to the PM mail ideally. Any idea would be much appreciated.We are using APP10 , Upd 15Thanks  

0
N
Hero (Customer)
10 months ago
ParsaHZM
Sidekick
ParsaHZMSidekick
asked in Insights (Business Reporter and Analysis Models, EOI)

Customized field in Business opportunity

Hello, FriendsI have a problem in Relationship management module, I’ll describe it in the below:We have some Customized field in Business opportunity page (follow the attached file) that prepared by our ERP developer team, How can we achieve to these fields in Business opportunities page (we want to bring them in Business opportunities columns) for preparing some analysis report and excel output. Thanks guyswish the best

12
ParsaHZM
Sidekick
10 months ago
P
Sidekick (Customer)
PennyBSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

BA Report switches date format when scheduled or run from IFS application

We’ve had this issue for years now, with no solution. BA Report displays dates in correction Australian format when run via BA Excel Add-In. However, when report is schedule or run from IFS application  any date references on the report revert to US Format. E.g. if there is a header in the report referencing the date the report is run or the date entered in a parameter it will show 9th June 2023 as 6/9/23 instead of Australian format of 9/6/23. Just wondering if anyone has resolved this?

3
P
Sidekick (Customer)
9 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
H
Sidekick
HananeSidekick
asked in Insights (Business Reporter and Analysis Models, EOI)

changing's a person email

Hello ,I changed my email in communication method in the person screen .But since i’m sending a scheduled report , i still receive it with the old email .Is there is further step that I need to apply or a job that I need to execute to take account of the new email saved . Thank you in advance Hanane

4
H
Sidekick
10 months ago
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)
16 days ago
sherry
Do Gooder (Customer)
sherryDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

ask for sql query tool training document

Does someone has any document for the sql query tool, i’m new for this area, want to get started.

2
sherry
Do Gooder (Customer)
10 months ago
D
Do Gooder
durasrbDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Report Designer for IFS Apps 8.0 (SP-0)

Hello all, i would like to start using IFS Report deisgner, version of IFS which i using is  IFS Apps 8.0 (SP-0) , i could not find any exe file to download, could anybody help about this issue and send me instalation file with report designer.Thank you in advance

0
D
Do Gooder
10 months ago
V
Do Gooder (Partner)
VIKASBISADo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Supplier Payment Screen missing from Cloud

Supplier Payment screen (Screen shot below) is missing from Cloud verison.I have below doubts -Although, the related business transaction can be done through mixed payment but what is the reason to discountinue the process.  How previous transaction can be seen in upgraded environment.  Note: Similarly, corresponding screen for customer, names - Customer paymeny is also discontinued.

0
V
Do Gooder (Partner)
10 months ago
M
Do Gooder (Customer)
Manish VermaDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Event Builder - Data Corruption

We have existing Event Builders at Product Level. Everything looks good in Database, but on Support Portal it is showing wrong information.Instead of Product Level, it is showing Item Level and next field is blank:  We are having this issue with a large number of Event Builders. Is there is a quick fix? Updating these manually is very time consuming.

0
M
Do Gooder (Customer)
10 months ago
T
Sidekick (Customer)
TimSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to delete entries from XLR_REPORT_RESULTS_TAB

APPS9We have been advised that XLR_REPORT_RESULT_TAB is consuming a large amount of disk space on our database.It looks like this is added to when a BA report is scheduled or manually run.How can we flush out/delete records from this table? We can see records going back to 2020 which we don’t need. Thanks

1
N
Hero
10 months ago

Badges

Show all badges
Terms & ConditionsCookie settings