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.

  • 641 Topics
  • 1,839 Replies
641 Topics
C
Do Gooder (Partner)
CD2022Do Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter -Using wildcard in a report parrameter

Has anyone come across a way of using a wildcard (‘%’ OR ‘*’) in the report Parameters so the user can select all without having to type the individual values?  They may need to run the report with one value in the parameter or  with no filter so it gets everything pulling through. Any advice is appreciated. Cheers

2237
L
Do Gooder (Partner)
G
Do Gooder (Customer)
GT69Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter without using trusted locations

Hi peoplesOur IT security team don’t want to set up a trusted location for Business Report Writer reports. Apart from using Business Report Execution Server is there another work around without having to create trusted locations? ThanksGT

1693
R
Do Gooder (Customer)
N
Do Gooder (Customer)
nithyaDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Report Designer

how to add a view to Modules_rep in an existing RDL file in Report Designer? Have to add a new field from a new view than the existing view (barcode_lines) in the rdl file (report to register arrivals ) 

245
asanka1055
Sidekick (Partner)
T
Sidekick (Customer)
TSPPRICHSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter for IFS Cloud issue referencing different sheets

Hi,We are upgrading to IFS Cloud 23R2 and have an issue with Business Reporter reports that were written in IFS Apps 10.We have tested in the BR client versions 23.2.0, 23.2.1 and 23.2.2 – the issue is present in all of them.Our report developers have used multiple sheets and use many formulas referring to data on other sheets like this example:In the Design view you can see the reference to a sheet within the workbook. When the report is run you can see the sheet names have been stripped out so excel is now referring to cells on the current sheet:  We need this resolving ASAP as our go live approaches.We have raised a ticket but nothing has been done yet. ThanksPaul

1142
M
Do Gooder (Customer)
S
Do Gooder (Customer)
SnehaGDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Extra Spaces in Excel Attachment for Scheduled Quick Report

 Encountered an issue when running a scheduled quick report in IFS Cloud 24R1. When the report is sent as an email attachment in Excel format, it contains extra spaces around the cells (except for the header row). However, when I run the same report and export it directly from the quick report/output window, it appears correctly without these extra spaces. Example - Scheduled quick report mail attachment: Output from Quick report window:Could you please guide me what configuration settings should be adjusted to prevent the extra spaces in the scheduled reports Excel attachment?Is there a specific setting related to the export format that might be causing these spaces?Any other suggestions to resolve this issue? Thank you!

303
S
Do Gooder (Customer)
D
Sidekick (Customer)
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

2799
sdhalk
Sidekick (Employee)
B
Hero (Partner)
bytsophanHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
#NAME? display in the business Reporter

Somethimes you have an Business Reporter which shows you the Field value as  #NAME? Just Run the Report and cancel and the field will show you normal again. 

80
B
Hero (Partner)
S
Do Gooder (Customer)
SnehaGDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
24R2- Business Reporter Login Error

After upgrading Business reporter to 24R2 version. I am frequently facing an error “Error while calling the projection BrClientAuthorizationHandler”.when I log in for the first time, I am able to load and run the report. However, if I try to load or open another report, I get an error.To resolve this, I have to close all the instances and reopen it.I did not encounter this issue before the upgrade. I am using a user who as all the necessary grants.- BA_SUPER_USER- BA_ENDUSER- BA_DESIGNER-  BA_REPORT_ADMINIs there anything that needs to be refreshed or any additional steps after installation to fix this issue? Tool version: 24.2.1.0Error -  Thank you!Sneha 

673
B
Hero (Partner)
N
Hero (Partner)
Nisansala LiyanageHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
BR report does not work when the parameter value is entered manually

Hi,There is a difference in how the BR report is executed when the parameter value in entered manually and selected from LOV. Selecting from LOVTyping manually This happens for both ‘Year’ and ‘Month’. They are of number type. But this is how the queries are formed.using to_char() or to_number() in advanced filter criteria didn’t work. Converting the field in the IAL using to_char() also didn’t work.Is there any other way to resolve this? Best Regards,Nisansala

286
S
Hero (Employee)
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

531
E
Sidekick (Partner)
B
Do Gooder (Customer)
bpamlinDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
how to handle multiple data sources in the lobby data source designer

How do you implement 2 data sources (views) into the lobby data source designer. I want the following code to return the count in the data source.select distinct(sp.catalog_no)from lora1app.sales_part sp, lora1app.sales_price_part_join splp where splp.catalog_no = sp.catalog_no and splp.SALES_PRICE_TYPE_DB = 'SALES PRICES'and sp.activeind_db = 'Y' and (splp.part_valid_to_date >=  (sysdate) or splp.part_valid_to_date is null)and splp.valid_to_date >=  (sysdate)       --currently I have gone about it the following way seeing that the data source cannot handle two views:select distinct SALES_PART.Catalog_NO from SALES_PART  where SALES_PART.activeind_db = 'Y' and SALES_PART.Catalog_NO  in (select catalog_no from  sales_price_part_join where  sales_price_part_join.catalog_no = SALES_PART.CATALOG_NO AND  sales_price_part_join.SALES_PRICE_TYPE_DB = 'SALES PRICES' and (sales_price_part_join.part_valid_to_date >= sysdate or sales_price_part_join.part_valid_to_date is null) and sales_p

6634
R
Sidekick (Customer)
D
Do Gooder (Customer)
DanielCatoioDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Lobby - Block automatic refresh

HI everyoneI would like to know if it's possible to block the automatic refresh of a specific lobby.I know that we have the option to refresh automatically but I would like to opposite as I have some lobbies which are quite heavy and we would like to get refreshed only on user demandFYI, we are using IFS 10 Update 9 Thanks in advance

80
D
Do Gooder (Customer)
E
Sidekick (Partner)
EntUviniGSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Spend Analysis sample BI report is not working

Hi ,We are trying to use Spend Analysis sample BI report and it’s not loading data into the report. The tabular model is deployed, and the Supplier Performance sample BI report is working as expected, even though both reports fall under Procurement. Our customer is using version 23R1. Our customer is in 23R1. Fix this command in the report does not fix the issues as well. User have access to all the sites and companies  as well.Many thanks for your inputs on this issue.Best regards,Uvini

223
S
Hero (Employee)
S
Do Gooder (Customer)
SPierpointDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Auto Enabling Macros on Business Reporter reports

Hi, We have come across an issue where if we ‘order’ the business reporter report in Excel it errors as it cant find/run the macro.  But if we ‘load’ report, it loads up with the box at the top to enable macros. We click enable, then ‘run’ and the report works fine.  We have always had issues with these reports running out of the IFS application, which is why we use IFS Business Reporter instead. Are you able to assist with this query please? Our company does have a policy where they don’t want users to use macros, but I’m not sure of another way around it so I’m looking for any options. thank you for your time!

252
S
Do Gooder (Customer)
ChanakaEA
Do Gooder (Partner)
ChanakaEADo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Analysis Models - Power BI Sales Parts

Hi,According to the latest IFS GPL and 24R2 sales part list, there are only two Power BI-related sales parts available:Advanced Analytics - Self Managed Analysis Models - Self ManagedI would appreciate more information about the latest sales parts related to IFS Analysis Models (24R2). Could you please provide answers to the following questions?What sales part(s) are needed to use IFS Analysis Models - Power BI with a self-hosted BI infrastructure setup? What sales part(s) are required for using IFS Analysis Models - Power BI (data lake Gen2) and IFS Advanced Analytics? Is it possible to purchase Advanced Analytics - Self Managed without purchasing Analysis Models - Self Managed? Does this mean that iFrame integration is always available and not dependent on any sales part? Can we assume that IFS Analysis Models – Tabular is no longer available for purchase?Thank you. 

932
S
Do Gooder (Employee)
T
Sidekick (Partner)
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.

1629
S
Hero (Employee)
N
Do Gooder (Partner)
NisansalaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Enabling Context Substitution Variables on QIS parameters

Hi,when using a standard dimension/fact item as a report parameter, relevant context substitution variables will be visible to choose as the default value.However, when a QIS is created based on an IAL, this is not possible. Here, the DIM_COMPANY dimensions was connected to the QIS from custom dimension connections oage.  Is this a framework limitation? Is there any setting or workaround to achieve this behavior? Best Regards,Nisansala

434
N
Do Gooder (Partner)
G
Sidekick (Partner)
GaSoGBSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Cloud: Report Designer - Use Custom Configuration

Hi All, What is the purpose of ‘Use Custom Configuration’ in Report Definition?Use Custom Configuration 

1052
T
Hero (Partner)
Himasha Abeywickrama
Superhero (Customer)
Himasha AbeywickramaSuperhero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
FACT_GL_TRANSACTION Incremental Loading

Hello,I'm trying to enable incremental refresh for FACT_GL_TRANSACTION, but I need to complete the initial refresh first. The dataset is quite large—refreshing accounting year (a full refresh using a criteria) 2024 alone takes around 15 hours. However, I'm unable to refresh the entire dataset. Once 2024 is fully refreshed the entity info says its no FRESH, attempting to refresh 2023 or any other year with entity criteria does not work. Any idea why?

444
Himasha Abeywickrama
Superhero (Customer)
N
Do Gooder (Customer)
nate.wDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Quick Report - SQL Statement - where date is yesterday

I am trying to create a Quick Report that will show all inventory receipts from the previous day. Below is my current query. I want to add a WHERE clause so I will only see records where the ARRIVAL_DATE is yesterday. I have tried several different ways to accomplish this and have not been able to figure it out yet. Simply looking for how to state the WHERE clause at the end of this query. select CONTRACT, VENDOR_NO, ORDER_NO, LINE_NO, PART_NO, QTY_ARRIVED, ARRIVAL_DATE, DELIVERY_DATE, RECEIVER, OBJSTATE, PART_OWNERSHIPfrom PURCHASE_RECEIPT_NEWwhere DEMAND_CODE = 'IO'

515
T
Superhero (Employee)
J
Sidekick (Customer)
jayoneil98Sidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS_GENERAL_LEDGER Tabular Model Error

Hello, I have been trying to set up the IFS general Ledger tabular model but I have been running into errors and issues. I have attached a log file. Has anyone been able to process this Model? We are currently using IFS Cloud 24.2.1 Thank you.

252
J
Sidekick (Customer)
Waqar Habib
Sidekick (Customer)
Waqar HabibSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
how to get IFS Users daily working log ?

Hi Experts,Requirement is IFS Users daily log required, is there any screen or report to check Users daily work.  

452
Charana Udugama
Superhero (Employee)
jzouaoui
Sidekick (Customer)
jzouaouiSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Ifs_sales cube

Hello, in the fact_customer_order_line_bi . I cannot see the correct amount if I have a credit that was made at the order level following an RMA. I can just see the amounts on the order line side and not on the invoiced line side and that creates an imbalance at the sales level.Exemple : Customer Order line  Side :fact_customer_order_line_bi : in power bi  fact_customer_order_lineCustomer invoiced Line side :  The  question : is there a way to resolve this issue and get the customer order line amount correctly

230
jzouaoui
Sidekick (Customer)
T
Sidekick (Partner)
TopDeepaWSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Can not saving/publish Business reports in IFS Cloud

Hi,I’m trying to save and publish a report to the IFS Cloud environment, but getting the below error. Kindly help me to resolve this. Error when saving the report in ifs cloudRegards,Deepal.

442
ashen_malaka_ranasinghe
Hero (Employee)
S
Hero (Customer)
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

1657
T
Sidekick (Customer)

Badges

Show all badges
Terms & ConditionsCookie settings