Insights (Business Reporter and Analysis Models, EOI)

607 Topics

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

1 day ago

TopDeepaWSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Connect Business Reporter to IFS Cloud 24R1

Hi Everyone,Following error will appearing while connecting to the IFS Cloud instance. IAM client setup is done as per the technical documentation. Thank You.

603

9 days ago

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?

6206

13 days ago

ViitatiSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - The website’s security certificate is not secure.

Hi all, I try to log-on to Business Reporter, but I face strange error, which I have never met before: When I click “Refresh the page.” I get this error: I have installed this website’s certificate and this environmental works in browser correctly. I have also prepared IAM Client as it should: I have done this several times before for different environmental, and I have faced an errors when IAM Client or certificate is not defined correctly, but now I have done and defined them for this environmental at least twice.Certificate are stored on “Trusted Root Certification Authorities” -folder. I also stored them to different locations too, but did not make any difference. This environmental is working on 24R1 SU1.

321

17 days ago

dritterSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Login Error

Hello,We have an issue surrounding business reporter that is causing frustration in its users. After initial login in Excel, we are able to use BR as needed. However, if we get timed out and attempt to login again, we get the error below. The only workaround we’ve found involves closing all instances of Excel and reopening the business reporter. This is a pain when working on many reports, or when we just have many different documents open. Occasionally this doesn’t even fix the issue and we need to restart the entire computer. Is anyone else experiencing these issues with BR? Anyone have a fix for it? Thank you,Dylan************** Exception Text **************System.Exception: Error while calling the projection BrClientAuthorizationHandler. ---> System.Security.SecurityException: IFS Business Reporter session has expired. Please re-login using the Login button. at Ifs.Application.Br.Authenticator.AuthenticatorService.GetOpenIdAccessToken() at Ifs.Application.Br.Authenticator.Se

823

19 days ago

RudolphVDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Reporter - Remove Old copies of a report

Is it possbile to remove / delete old reports from the database? Having tested various things in BR, there are now many unwanted reports visible. How would one go about removing or deleteing them?

251

19 days ago

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?

22 days ago

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?

261

26 days ago

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

211

1 month ago

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?

2225

1 month ago

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.

915983

1 month ago

SHAUN_KERSLAKEHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Reporting and Data Warehouse

Afternoon,We are in the midst of upgrading to IFS Cloud 23R2 from Apps 10, and in parallel the business are reviewing our BI strategy. Currently we use IFS Lobbies, Quick Reports and Business Reporter within IFS, and externally use tools such as PowerBI and Qlik. All our reporting is based on the production IFS Oracle database through ODBC connections. We plan on using PowerBI as the primary tool for management reporting, whilst continuing to use Quick reports and Lobbies for operational reporting within IFS.We are therefore considering options for data warehouse solutions such as Microsoft Fabric and PowerBI. We are looking for information on what other IFS customer's are using for their BI strategy and data warehousing solution, along with some pros and cons. Thanks in advance

190

1 month ago

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:

411

1 month ago

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

131

1 month ago

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,

212

1 month ago

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.

661

1 month ago

m.dutkiewiczDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Businness Reporter - permissions for sources

Dears,Is there possibility to manage the permissions for the sources in Business Reporter? For instance, Person A (from Purchase Department) should not be able to create the reports from Finance, HR area which contains “sensitive data”.I would be grateful for any information how we can manage the permissions in this area?Best regardsMateusz

940

1 month ago

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?

402

1 month ago

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 ?

873

1 month ago

ManushaDo Gooder (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

181

1 month ago

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.

51911

1 month ago

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.

311

2 months ago

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?

372

2 months ago

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

662

2 months ago

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

613

2 months ago

Page 1 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded