Skip to main content

Insights (Business Reporter and Analysis Models, EOI)

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

  • 661 Topics
  • 1,885 Replies
661 Topics
J
Do Gooder
JohnnyDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)
how to disable PDF archive

this is my operational report setting, every time the crystal report will be invoked and generate PDF automatically. I’d like to archive only, but don’t like to trigger crystal PDF. how can I accomplish it? I know I can do it via “order report” with “archive only” check-box manually.  

702
J
Do Gooder
EmiliaUsa
Do Gooder (Customer)
EmiliaUsaDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
List of transactions id in IFS

Hello community. It is a way to have a list of transactions IDs and their use ?thanks a lot,Emilia 

12236
M
Do Gooder (Customer)
S
Do Gooder (Customer)
SEFLNDADADo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Double lines when entering a time report

Hi,When adding a time report we get double lines in Aurena.It looks correct in IEE for the same work order.When select 1 line in Aurena it automatically selects both of the lines.I have create an employee to several companies where this doesn’t happen, it’s only in one company we can see this issue.Someone that knows what the reason can be?Thanks! 

480
S
Do Gooder (Customer)
G
Hero (Customer)
gianni.nevesHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Cloud - IFS Analysis models

Hi guys, Need help to understand how show the menu Analysis models in IFS Cloud. I see BIBASE component installed, but the menu is not available. I already configured SQL Server and all requirements from here IFS Analysis Models - Installation Checklist - Technical Documentation For IFS Cloud, but when I arrive to SETUP ENVIRONMENT ASSISTANT, I cannot find this item. I tried PERMISSION SET, YAML file, reconfiguration of SQL Server, but nothing works. Did anybody have any idea? Thanks,Gianni 

1150
G
Hero (Customer)
zuhaib
Sidekick (Customer)
zuhaibSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Report Error

When I run a quick report through IFSAPP it works fine, after that I run it on any user it shows the error.  When I run Quick report on user ID that error is show  

16112
zuhaib
Sidekick (Customer)
mwilliams
Do Gooder (Customer)
mwilliamsDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-Value cannot be null.

Hi All- I am getting this error in my Crystal Report (please scroll to the end), Many Thanks. 16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] File Name : BA_BRO_ADDR_(v0.1).rpt16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] The file C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt is found16/02/20

1614
ChanakaAmarasekara
Hero (Employee)
B
Do Gooder (Partner)
BeaParisBDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Sort data by measure item in business reporter

Hi all, I am having trouble sorting data by measure item in business reporter. Does anyone know if there is a BR functionality that enables you to do so? If not, any good work arounds? Any help would be great, thanks! 

573
B
Superhero (Employee)
M
Do Gooder (Employee)
Martin GestingerDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)
Missing LoV in Client for Business reporter

Hi, Please, can someone advise me how to add LoV while ordering Business Report in IFS Client. For one parameter there is no list of values and I don't know why.  If I check the dimension for this parameter in Dimension Item Details I see this set up.   Is it publishing Info window where I should set something to get LoV in Client.  Anyone any Idea ? Thank you Martin Gestinger

3262
S
Hero (Employee)
U
Sidekick (Customer)
Unscented0296Sidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Quick Report - SQL expression is wrong

I wrote an SQL query using the SQL Query Tool in IFS App 9. But when I try to save the query as a Quick Report it states: SQL expression is wrong (SQL-Ausdruck ist falsch).The query runs fine in the IFS Query Tool and unfortunately the error message does not specify why the SQL expression is wrong. Does somebody know what is wrong with my query?

3194
U
Sidekick (Customer)
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?  

1221
A
Do Gooder (Customer)
K
Do Gooder (Customer)
KPalmieriDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Corrupt BR Excel Files

Hello, We keep getting corrupt BR Excel files that are placed on our network drive:​​​​This is completely wiping out our BR Excel reports and are unable to recover...Any thoughts? Thanks

562
S
Do Gooder (Customer)
M
Do Gooder (Employee)
Martin GestingerDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)
Parent value in BR

Hi, Does anyone know if it is possible to add more parents values in Business reporter to Enter Parameter Values. As you can see in my example now. If I want to choose department value, I need first choose parent value company. Based on choose parent value (Company) I get data for departments, but I would like to add one more parent parameter. But I am not confident how to do it.  

733
Thiwanka Sandaruwan
Hero (Employee)
A
Do Gooder (Customer)
AMCKEVITTDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
How to login to IFS Portal

I have attempted to login to my IFS Portal which has not been used in a long time.It does not recognise my username or password but will not allow me to register again as it recognises my email address. How can I find out my username in order to reset my password?

1686
Link
Superhero (Customer)
L
Sidekick (Partner)
LakmalSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Crystal report error in IFS Cloud

I’m getting following error when try to run ModuleRep.rpt in new cloud installation.Cannot connect to the Crystal Web Service through  http://XXXXXXX:80/IFSCRWebSetup/Ifs_ReportService.asmx. Please Contact your System Administrator.Web service call not received to IFSCRWebSetup logfiles even though Crystal web service is installed and able to test with blank.rpt and db.rpt.Thanks,Lakmal

2630
L
Sidekick (Partner)
M
Do Gooder (Employee)
Marc BOBENRIETHDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)
Reporting - Access view - 22R1

Hi,According my understanding, as the IAL views, the Access views are configured (created on demand by an end user) and belong the IFSINFO schema.For the IFS managed-cloud hosted customers, that offer the opportunity to use them via a direct access to the database allowed only to IFSINFO schema. But something remains not clear for me.In the technical documentation for IFS CLOUD (https://docs.ifs.com/techdocs/21r2/045_administration_aurena/255_br_and_a/050_integrations/080_external_access/010_access_views/) it is mentioned: "Access Views are used as the source for loading the Tabular Models specific data layer in SQL Server." "When the Access Views have been created, the Tabular Models framework can be setup, necessary model objects can be deployed to the SQL Server database and then a data load can be performed where the Access Views are used as sources when transferring data from IFS Cloud database to the SQL Server database.".I assume that this SQL Server is optional, not provided wi

1281
S
Do Gooder (Employee)
Disna Marakkala
Sidekick (Employee)
Disna MarakkalaSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)
NVL2 BR Function Parameter - Example?

Hi All, Can anyone please show an example of using NVL2 function parameter in a BR report?  I tried to use NVL but could not get what I wanted. And trying to use NVL2 function parameter, but  not sure what should I enter for the first argument (ValueIfNull). please see the image.&CodeB is a standard parameter for DIM_CODE_B.CODEThe requirement is to get all CodeB values including NULL when the &CodeB leaves blank and the selected CodeB values when &CodeB has a value.Example:when &CodeB = say '45' , the report will only show the records with code_b = 45when &CodeB leaves blank (NULL) then the report will show the records where the code_b of any value plus the code_b IS NULL  Thank you!

1695
M
Do Gooder (Employee)
E
Sidekick
ertan.ariSidekick
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Business Analytics

Hello Community, I have 2 questions about ifs business analytics.1-) When I want to run the business analytics report installed in IFS, a blank page appears when displayed in excel.2-) How can I view quick reports in IFS Business Analytics?

2621
E
Sidekick
U
Sidekick (Partner)
USER_IFSSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Error: 00942. 00000 - "table or view does not exist"

How can I add permissions for a user to can connects to see data in views by ‘SQL Developer’ tool (directly from the database Oracle) ?Currently, the user can see tables, but views can't - by SQL Developer. if I add IFSAPP perspective , then he connects but can’t see the data from view.-off course this view have the data :  here is an example that user has connect to the table: The issuse related with IFS 10.

5932
U
Sidekick (Partner)
Z
Do Gooder (Customer)
ZAEDOMNYADo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
crystal report in edu environment

Hi I have a quick question on crystal report on EDU environment APPS10. I cant seem to download the Crystal Runtime files from the add-ons, could someone please explain to me why this is the case?  

300
Z
Do Gooder (Customer)
SMANUEL
Sidekick (Partner)
SMANUELSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
BR installation error

Hi Received the following error after BR client installation (MSI installer)MS Office 2019 

1366
SMANUEL
Sidekick (Partner)
shafiuzzaman
Do Gooder (Partner)
shafiuzzamanDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
How do I automatically select the report layout based on logic?

The supplier Check report has several layouts based on Banks. I want to select multiple bank checks and when I print, system will select automatically layouts based on banks.

1443
cperdue
Hero (Partner)
A
Do Gooder (Partner)
Akshaya SDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Lobby count is working fine , but filter is not working as expected

Hi , I have a requirement where the lobby  must show the count when the reminder is due (from purchase order screen )and filter applied in reminder due as ‘ yes ‘ and on clicking the count it must navigate to purchase order confirmation reminders screen where it must show the data where the reminder due is yes . but for me it is showing the count for all the data in the page without recognizing the filter . if I add filter as reminder due is yes inside the navigation , it is not working properly .  PURCHASE_ORDER_LINE_ALL - View used in datasource PURCHASE_ORDER_API.Get_Contract(order_no)= ContractAND Purchase_Order_Line_Api.Get_Ord_Conf_Reminder(order_no , line_no , release_no) = 'Print Order Reminder'  - this is the SQL condition I have given page/PurchaseOrderConfirmationReminders/List - This is the navigation I have given in element designer for now . if I try adding reminder due = yes inside this navigation it is not working  Now if I click on this count . it is taking me to the P

1464
A
Do Gooder (Partner)
K
Do Gooder (Customer)
KPalmieriDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
How to get BR Software Updates?

Trying to figure out how to be aware of new Business Reporter software updates? How do we get notification of new updates?

1294
S
Do Gooder (Employee)
M
Sidekick (Customer)
mlizarraldeSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Graph Lobby element

Is it possible to choose the colour of the graph in a lobby element ?  

491
Link
Superhero (Customer)
G
Sidekick (Partner)
GaSoGBSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
APPS10 -UPD14 Aurena SQL Quick Report Titles

Hi All, When I preview a SQL Quick Report in EE, it correctly shows titles in mixed case. However when I preview the same report in Aurena, it only shows first word in mixed case and others in lower case. If you have any prefix like ‘%’ it then even shows first word in lower case.Does anyone know a solution/workaround for this? EE  Aurena 

670
G
Sidekick (Partner)

Badges

Show all badges
Terms & ConditionsCookie settings