- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
Search

Replies posted by Thiwanka Sandaruwan

36 Replies

Newest first

Oldest first

Martin GestingerDo Gooder (Employee)

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

Parent value in BR

Cloud Documentation:https://docs.ifs.com/techdocs/22r1/050_reporting/500_information_sources/030_configure_information_sources/020_configureisdimensions/#dimension_parents

Martin GestingerDo Gooder (Employee)

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

Parent value in BR

Hi @Martin Gestinger , Please refer the below documentation to get a clear idea about parent item configuration for a dimension. https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/030_configure_information_sources/020_ConfigureISDimensions.htm#Dimensions_Parents Best regards,Thiwanka

KPalmieriDo Gooder (Customer)

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

How to get BR Software Updates?

Hi @KPalmieri, What is the track you are using? Is it IFS APPS10? The latest version of APPS10 is 5.0.26. Best regards,Thiwanka

KPalmieriDo Gooder (Customer)

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

How to get BR Software Updates?

Hi @KPalmieri , There are two ways to install IFS Business Reporter:Install via a msi file. Installing a ClickOnce version of IFS Business Reporter, i.e. installation via a web page. Kindly note that the ClickOnce is the recommended installation method.The ClickOnce version of IFS Business Reporter client automatically gets updated when a new version is available in the published location. This means that a user will always be made aware when a new version of IFS Business Reporter is available. Please refer the below documentation to more information.https://docs.ifs.com/techdocs/Foundation1/020_installation/400_installation_options/007_br_and_a/010_IFS_Business_Reporter/005_BR_Installation.htm Best regards,Thiwanka

yasirsardarDo Gooder (Customer)

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

IFS business reporter "you are not licensed to use IFs Business reporter

Hi @yasirsardar, Have you checked whether the users are having BA_USER permission set is granted to the referred users and with the activity 'ControlBiAccess'? Usually there are two activities that should be granted, which are ControlBiAccess and ControlBrAccess. Incase if those permission sets are not granted kindly grant them and refresh the security cache to see if this issue gets resolved. Please check the below resolved similar issue. Best regards,Thiwanka

shewaDo Gooder

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Business Reporter error when Bulk Save

Hi @shewa , Please note that IFS Bulk save/republish is not designed for the purpose you have used it.The bulk save/republish is used when there is a need to republish all the report while keeping the original report after an upgrade. This is why it has not used the word publish but has used the word republish instead. Only saved reports are capable of republishing. There is NO tool available to export and import all the BR reports designs from one database to another. For this you need to get a copy of the database to another.OR you can do it one by one as you tried to do. Best regards,Thiwanka

OsthewhaSidekick (Customer)

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

BR - How do I get a BR report ordered from IEE/Aurena to pop up directly, when run, instead of fetching it in Report Archive ?

Hi @Osthewha IEE: To access a published report, the end user must have the necessary grants, which means that the Presentation Object representing the report must be granted to the user. Thus, if a Business Reporter end user should be able to order a report either via Order Report in IFS client or via Order Report in Report Mode in IFS Business Reporter, it is necessary to grant the report/reports to the user. The same applies for a Business Reporter designer that wants to run a publish report via Report Mode in IFS Business Reporter.There are some predefined permission sets that provides access to BR reports. These Permission Sets are described below documentation. but it is not recommended to grant them to end user since it will make it difficult to provide specific grants to specific users. https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/040_Services/010_manage_BRA_services/020_manage_user_permission/150_access_to_bra_reports.htm#General Aurena: https://doc

TAPSUDJAYSidekick (Customer)

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

Business Reporter reports not working through IFS for one user

Hi @TAPSUDJAY , What is the situation if the user login to another working machine? Best Regards,Thiwanka

shewaDo Gooder

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Business Reporter Parameters

Hi @shewa ,You can create multi-value parameters for the site, buyer_code and project_id fields using the defauld value as ALL. Then it will fetch all the values for them If user only enters COMPANY and TEMPLATE_ID as parameters. If user wants to filter by site, buyer_code and project_id fields they can use the required value instead of the default value.Example: Best Regards,Thiwanka

TopDeepaWSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Can not create information source

Hi @TopDeepaW , Could you please check the available BR navigator structure and the selected “Navigator folder name” when creating this QIS? If you are noticed any duplicate record in the selected folder you can select another folder or create a new one. Please refer to the below documentation to get an idea about draft QIS and setup BR client navigator. https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/060_Quick_Info_Source_Drafts/120_qis_functionality.htm#Draft_a_Quick_Information_Source https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/030_Business_Reporter/020_setup_BR_client_navigator/default.htm Best Regards,Thiwanka

smelansonSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Business Report issue when saving

Hi @smelanson, As per the below community post answer, You can verify the success of the report saving process by querying the below statements. https://community.ifs.com/insights-business-reporter-and-analysis-models-eoi-51/saved-business-reporter-reports-14774?postid=55068#post55068 SELECT * FROM xlr_template_file_tab WHERE TEMPLATE_id LIKE '%report_id%'SELECT * FROM xlr_template_tab WHERE TEMPLATE_id LIKE '%report_id%'(report_id must be replaced with your report ID) And please follow the best answer of the below post to republish your report, The reported issue is different, maybe the steps provided in the answer will help you. https://community.ifs.com/insights-business-reporter-and-analysis-models-eoi-51/business-reporter-error-17079 Best Regards,Thiwanka

RodolfoDo Gooder

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Information Source back drafted status

Hi, I need to modify an information source, however once created there is no option to move it back to draft status so it can be modified or deleted. I have looked in all the info source related pages and can’t find anything. Many thanks Rodolfo Hi @Rodolfo , As I know, first you need to remove the information source, and then it goes back to drafted status. Br. Lopes Hi @lopespetro , Yes, correct. Only QIS which is the Drafted state can be deleted. https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/060_Quick_Info_Source_Drafts/120_qis_functionality.htm#Delete_Selected_QIS_Draft(s) So if you have already created an information source from the selected QIS draft, you need to delete that QIS from the information source window first. Best Regards,Thiwanka

kpath7Do Gooder

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

Error previewing SSRS reports from Visual Studio

Hi @kpath7 , As per the below answer of Developer Community of Visual Studio, having the 32 bit ODP installed is necessary to run the report. https://developercommunity.visualstudio.com/t/ssrs-report-preview-error-for-oracle/1067437 Just found this from the web. So please check this out if you didn’t check it before. Best Regards,Thiwanka

ronhuHero (Customer)

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

SQL Information Source Data

Hi @ronhu, By enabling the "Display data access details" checkbox you can find the available view names for online and DataMart methods. And you can query data from the available views. Example : Select * from FACT_GL_BALANCE_OL Select * from FACT_GL_BALANCE_DM Best Regards,Thiwanka

Robby CDo Gooder (Customer)

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

BR - Adding Dimension to FACT table

Hi @Robby C , Yes, the recommended way is to add a new dimension(standard dimension/quick dimension) to an information source via Custom Dimension Connections. Best Regards,Thiwanka

Robby CDo Gooder (Customer)

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

BR - Adding Dimension to FACT table

Hi @Robby C , Please refer the below documentation to get an idea about how to add a dimension to an information source(fact). https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/020_Custom_Dim_Connections/010_cust_dim_conn_ovw.htm As well as you can refer to some examples from the below documentation. https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/020_Custom_Dim_Connections/020_cust_dim_conn_ex.htm Best Regards,Thiwanka

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

Filter criteria in BR generate different format

Hi @USLA , I found some insight from the web as below. “By default, Excel uses the list separator defined under regional settings in Control Panel. The US English version of Excel uses a comma (,) for list separator by default, while other international versions may use a semicolon (;).”Source :- https://exceljet.net/glossary/list-separator Could you please check the regional versions of both A and B users? Best Regards,Thiwanka

DKSSIDo Gooder (Customer)

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

IFS business reporter / Budgets

Hi @DKSSI , Please use the GL period budget information source as well. Best Regards,Thiwanka

ShouSidekick (Employee)

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

Business Reporter - Interactive Structures

Hi @Shou, I believe your question is how to create account structures from IEE. From the “Accounting Structure” window you can create account structures. And active account structures can be selected by using the structure details option. If you need more information regarding account structures please refer the below documentation.https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/020_Analysis_Models/100_AnamdlConfigBasicData.htm#Accounting_Structures Best Regards,Thiwanka

lopespetroHero (Customer)

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

JUST ONE RECORD ROW BUSINESS REPORT

Hi @lopespetro , If that row repeater creation is not clear for you Please follow the below steps. Select entire 2nd row in your report design. Then click the highlighted icon from document action. (please refer the attached screenshot) It will automatically add the row repeater for Group Id. Then run the report. Best Regards, Thiwanka Hi @lopespetro , I hope you are trying to follow the above suggestion. Could you please reopen the business reporter and try to design the report again? And please let me know your business reporter client version. Best Regards,Thiwanka

lopespetroHero (Customer)

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

JUST ONE RECORD ROW BUSINESS REPORT

Hi @lopespetro , If that row repeater creation is not clear for you Please follow the below steps. Select entire 2nd row in your report design. Then click the highlighted icon from document action. (please refer the attached screenshot) It will automatically add the row repeater for Group Id. Then run the report. Best Regards,Thiwanka

lopespetroHero (Customer)

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

JUST ONE RECORD ROW BUSINESS REPORT

Hi @lopespetro , Please create a row repeater by using Group Id. Please refer below example to get a clear idea. Best Regards,Thiwanka

tombowe77Sidekick (Customer)

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

Multiple values in Business Reporter parameter field?

Hi @tombowe77 , Yes, If you want to fetch multi-value for any parameter, You need to enable the “Multi-Value” property when creating the parameter. And please make sure to change your filter from “=” to be “IN”. Please refer below community post for more details. Best Regards,Thiwanka

LinkSuperhero (Customer)

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

Table name of users company and site

Hi @Link , Just try below statements. Tables: SELECT * FROM company_tab;SELECT * FROM site_tab; Views: SELECT * FROM company;SELECT * FROM site; Best Regards,Thiwanka

TopDeepaWSidekick (Partner)

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

Loads All Project Activities - BR Report

Hi @TopDeepaW, Hope you have followed the below documentation. If not please refer these documentations to have a better understanding of the custom dimension LOV. Overview https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/030_Custom_Dim_Lov/005_cust_dim_lov_ovw.htm Examples https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/030_Custom_Dim_Lov/020_Lov_examples.htm Best Regards,Thiwanka

1
2

Page 1 / 2

Badges

Isak Navihas earned the badge 1st Reply
priyakatariahas earned the badge 1st Topic
Dustonhas earned the badge 1st Topic
userqueryhas earned the badge 5th Reply
motionenergygelhas earned the badge 1st Topic

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login as an IFS Employee

or

Username (Do not use your email as a username.) *

Email Address (Use your work email address.) *

Name *

Company *

Account Number

(Private)

Only you and moderators can see this information

Job Title *

Member Type *

IFS Employee IFS Partner IFS Customer Just Visiting

Products Used

(Private)

Only you and moderators can see this information

IFS Cloud IFS Applications FSM PSO Maintenix Fleet Planner Alliance FieldCentrix assyst MWM Other

Country

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login as an IFS Employee

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK