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
N
Sidekick (Partner)
NecMayuIkSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Where is the Report Layout Migration Tool?

The documentation states the following, but I cannot find where to download the Layout Migration Tool in the Remote Deployment Guide.Can anyone tell me where I can download the Report Layout Migration Tool?https://docs.ifs.com/techdocs/24r1/070_remote_deploy/400_installation_options/005_operational_reporting/150_layout_migration_tool/--> https://developer.ifs.com/  

2818
G
Hero (Customer)
S
Do Gooder (Customer)
SYBMETHSHIKADo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Cannot login into IFS Business Reporter as a super user with basic authentication

Hi, When I'm trying to login into the Business Reporter using a super user username/password, it doesn't give any login error neither successfully load the reporter having closed the login dialog. When I choose the azure AD login option it says im already login. It seems something wrong with handling authentication code in the BR login dialog when even authentication happens successfully. Not loading after manually closing the login dialog too.Any workaround for this?This is IFS Cloud 24R1   Thanks!/Methshika

1134
S
Do Gooder (Customer)
Sachitha
Hero (Employee)
SachithaHero (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)
Excel Add-In don’t work on Jump server

When logged into the Windows 2019 Jump server with a user with administrator rights,  encountered an issue while attempting to initiate the IFS Excel Add-in.Upon starting Microsoft Excel and clicking on the IFS Excel Add-in icon, the Add-in launches successfully.However, when attempting to log in, encountered the following error:  Web browsers are up-to-date and not working for both edge and chrome,versions installed on this jump server,Also installed WebView2, Would appreciate your insights on what could be the root cause of this issue

2196
G
Sidekick (Customer)
D
Do Gooder (Customer)
DERYNGVE
asked in Insights (Business Reporter and Analysis Models, EOI)
Error when trying to open RDL in Report Designer

Hi all! We get the following error when trying to open and RDL in the latest version of Report Designer: We also have an older version installed and if we open the RDL in that version it works just fine. Any idea what the issue might be? Best regards

391
T
Hero (Partner)
PhillBronson
Hero (Customer)
PhillBronsonHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Lobby Datasource Designer - Performance Issues 23R2

I have noticed a significant difference in the way Lobby Datasource page is loaded.Every refresh it retrieves all the available queries in the sudo-selector, and I usually end up waiting a full minutes before the page will respond. Has anyone else experienced this behavior?Is there any solution?

371
PhillBronson
Hero (Customer)
S
Do Gooder (Customer)
setayeshDVDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Data Warehouse and ETL IN IFS Application

my main question is, Does the ifs application have a data warehouse service? 

7926
J
Do Gooder (Customer)
B
Do Gooder (Customer)
ballmanDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
The public IP/FQDN should be internally resolved to the private IP of the SQL Server.

I am trying to setup my Analysis Models to populate to an on-premises server.   The instructions are telling me :To achieve this scenario, where SQL Server needs to be accessed using the same IP address/FQDN both externally and internally, you can set up Split DNS or a Hosts file entry on the server running the SQL Server instance.I have tried to edit the host file by adding the external/public IP address as follows.      Internal IP       Exeternal IP or FRQN/Server Name    172.xx.xx.67    rs-IFS-biServer.domain.com    172.xx.xx.67    rs-IFS-biServer    172.xx.xx.67    170.xx.xx.245 Am I doing this right or do I have it backwards?

371
S
Hero (Employee)
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
BPA Workflow - return count of records returned into recordset

Within workflow I am trying to get the total number of records returned into the record set so. Can anyone advise a way to do achieve this?

851
R
Superhero (Partner)
M
Do Gooder (Customer)
MspargoDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Information Sources Used

Hi,  Does anyone know a way to see the information sources used in Business Analytics/Business Reporter reports. Essentially trying to work out which of our QFACTs are not being used. Thanks

401
S
Hero (Employee)
T
Do Gooder (Employee)
ThejanJayDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)
Question on loading data from IFS Cloud to existing Data Warehouse

A customer has custom data warehouse built in MS SQL server that they are using with multiple internal systems for reporting purposes. When using IFS Cloud they want to keep using the same data warehouse solution.What is the best way of loading data to their existing data warehouse from IFS Cloud at the database level?Is it possible to use Access Views for this purpose? if so are there any benefits of using access views for this rather than using Oracle views with direct DB connection?

3035
S
Hero (Employee)
ADNAN
Sidekick
ADNANSidekick
posted in Insights (Business Reporter and Analysis Models, EOI)
Everything about the IFS 10 Lobby.

 You can ask anything you wonder about IFS 10 Lobby. I can answer any questions you may have about IFS 10 LOBBY. Element design, data design, where patterns, references, page creation, authorization, etc. I would be happy to help.

1019283
T
Sidekick (Partner)
K
Do Gooder (Customer)
KiBriDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Report Designer - SQL query statement - NVL and subselect possible?

Hello,I would like to output a logo that is retrieved from the database via a select query and 2 parameters (company and language).Since it can happen that PNGs are not available for all combinations, I would like to output a standard logo for this case using the NVL function. The select statement works in PL/SQL-Developer.Unfortunately, no PDF is generated in the Report Designer Preview. Only the rendering cursor is displayed briefly, but nothing happens, no PDF, no error message.Is a nested select or the use of the NVL function not possible?Is there anything else to consider that I have overlooked?Or is there perhaps another way? Here is my select statement:SELECT NVL((SELECT image            FROM   Report_Logos_Tab            WHERE  SUBSTR(image_name,1,4)=:1                   AND SUBSTR(image_name,-6,2)=:2),           (SELECT image FROM Report_Logos_Tab WHERE image_name = '0000-Logo-en.png'))        FROM dual; These are the parameters:tns:PURCHASE_ORDER_PRINT_REP/tns:PO_HEADERS/tns:

1031
K
Do Gooder (Customer)
F
Do Gooder (Customer)
ftharyDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
are there best practices to create customs views to crystal reports layout

Hello,I am curently using IALs views with Quick reports in crystal. this works fine but when I try to use the IALs views in crystals layout in IFS these doesn’t work. I saw in a doc that sometimes it is better to create customs views in IFSAPP instead of IALs in IFSINFO (like IALs) so could you please give me an advice ?ThanksFrédéric

451
S
Hero (Customer)
R
Do Gooder (Customer)
rtailorDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Connecting Tableau to IFSAPP

I’ve connected Tableau to IFS using the Oracle connector but I only see partial data once connected. Not sure what I am doing wrong and any help would be much appreciated. Cheers, 

552
R
Do Gooder (Customer)
K
Sidekick (Partner)
Kavinda_JaySidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter Logging Error

Hi,One of our customers getting the following error when trying to log in to the IFS BR.In his PC VS 2020 is installed and trusted locations are defined.What can I do to resolve the issue?Thank you in advance. 

1701
NiyomalN
Hero (Partner)
N
Sidekick (Customer)
NorahmfSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Crysatl report issue

Dears, I create a new crystal report, but when I try to order report show blank page:is there a missing step?

782
H
Do Gooder (Customer)
P
Do Gooder
PheonixDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)
Report rule to print only the 1st page of a report?

Is there a way to restrict a report only to print the 1st page ?

1303
T
Do Gooder (Customer)
M
Sidekick (Partner)
ManushaSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter to CSV file

Hello everyone, Looking for some insight on the title. Customer requires BR to generate in CSV format: Report is as follows: They required all approved expense sheet details grouping by Payroll ID and Rate. We had the ability to create an IAL for this data including the grouping as well. The Start and End dates are taken from the same field, Expense Date in IFS where Start Date shows the date for the oldest expense sheet and end date shows the newest expense sheet. However, where we hit a wall was the search parameters were based on the ‘Approve date’ which can carry many different dates so the grouping in the SQL did not work. We decided to create an IAL bearing all the data in the table plus the approve date and decided to perform all the other functions using Excel and it was a success. The report however now contained multiple worksheets and hidden cells of course due to the functions.The current solution we provided was to move all visible cells into a new workbook and save it as

391
NiyomalN
Hero (Partner)
jporter
Sidekick (Partner)
jporterSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
22R2: Using Power BI in IFS hosted environments

We have a customer on 22R2, hosted in IFS cloud, looking to use Power BI.We’ve read the instructions here https://docs.ifs.com/techdocs/22r2/050_reporting/400_power_bi_int/010_setup_pbi_int/but not sure what customer would do and what would need to be done by IFS managed cloud team.Has anyone done this?Thanks.

60411
wahelk
Hero (Former Employee)
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.

631
H
Do Gooder (Customer)
H
Do Gooder (Partner)
himasha.abeywickramaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Tabular Models : No data for custom field in SQL Table

Hello,I’m having a problem where Custom Field data is not getting transferred over to SQL database. Here’s what i have done,1. Relations for Facts      2. Custom Attributes for Facts  3. Access View  4. Data Source  5. Deploy to SQL Server Db6. Data Load Run 7.  FACT_BUSINESS_OPP_BI_TAB table shows as NULL for CF$_EC_NEXT_STEP  8. Querying for ‘SELECT * FROM FACT_BUSINESS_OPP_BI’ shows below, Any idea why it’s not transferring any custom field data to SQL Server?

702
H
Do Gooder (Partner)
L
Sidekick (Customer)
leadingzerosSidekick (Customer)
posted in Insights (Business Reporter and Analysis Models, EOI)
Use the folders within IFS Business Reporter to Manage Permissions

Hello everyone,  We’re managing permissions for IFS Business Reporter and we’re starting to build more and more reports within the tool. As we’re training up more report designers, we’re running into a bottleneck around permissions management since each report (and each report unpublish / publish event) has to be managed separately.  Thinking about how to solve this, if the report structure within Business Reporter could be an object to manage permissions, this would permit folders to be assigned to a permission set and the report projections underneath them would be inherited by the “folder” level security object.  It seems to be inline with the direction laid out in the technical documentation where a practice recommended is to build a permission set for a given department and assign permissions. The folder structure we’ve built out has naturally fallen along organizational lines and it would simplify the management of report permissions.  It could also remove the tedium of restoring

1172
G
Do Gooder (Customer)
A
Superhero (Employee)
Adam MazurczakSuperhero (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)
Empty BR report

Hi BR experts,I'm preparing a report in Business Reporter, and I've encountered an issue. When the customer orders the report, they receive an empty one, but when I order the same report, I receive a report with data.I tried to recreate this issue, but I couldn't do it until I turned on the debugger.When I turned it on, I received an empty report.Have you ever encountered an issue like this?Do you have any suggestions how to solve it, I mean how to ensure that when the customer orders a report using their credentials, they receive a report with data.I would be grateful for your assistance.Best regards,Adam

993
Dharshankumaar Mahendran
Superhero (Partner)
D
Sidekick (Customer)
DV - JLSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Date Repeater Without Time Stamp

I am trying to run a report out of Business Reporter, using the GL Transaction info source. If possible, I would like to use the Light Item - Entry Date as a repeater, but only by the day. The system is currently repeating each time stamp. Example, I would like everything by “8/30/24 and 8/31/24” and not “8/30/24 1:23:01PM, 8/30/24 1:23:14PM, 8/30/24 1:25:57PM”. 

140
D
Sidekick (Customer)
L
Sidekick (Customer)
leadingzerosSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Managing Permissions Within IFS Business Reporter

Hello everyone, We’re running into occurrences where we make a minor change to a business report previously published in the database removes that report projection from all permission sets other than the permission set “BR_FULL_REPORT_ACCESS”. This is requiring permissions to be modified each version of the report to restore permissions back to where they were prior to unpublishing the active report. Is anyone else running into this issue? Would love to hear how others are managing permissions related to IFS Business Reporter around changes to existing reports.  We’re working off the technical documentation here. 

1732
L
Sidekick (Customer)

Badges

  • 1st Reply
    fishpolehas earned the badge 1st Reply
  • 1st Topic
    Selmahas earned the badge 1st Topic
  • 5th Reply
    emma_buyerhas earned the badge 5th Reply
  • 10th Reply
    cmojkuuhas earned the badge 10th Reply
  • 5th Reply
    yoderkdhas earned the badge 5th Reply
Show all badges
Terms & ConditionsCookie settings