Business Reporter always uses SUM() when aggregating, for repeaters, currently this is the only supported operation from the server. There are some options though.If the data volume is not large (may be couple of thousands), it is possible to bring all the rows to the report and do the min or max operations using Excel functions. Create an IAL for your requirement (exact report query) and create a Quick Information Source and fetch all values to the BR report If this information is available in a light item or dimension item, BR will always return data as “MIN_VALUE-MAX_VALUE”. If both min and max the same, will return only that value. e.g ABC-ZET, 10-25. This way may be you can extract data from EXCEL using the excel functions. You could create a custom (information source) attribute from an existing information source as a light item. Hope this helps. \Sanjaya
Hi, It could be that the Information Source in question still does not support URLs from IFS Business Reporter to Aurena.When an Aurena URL is available, it will be added as a separate RMB in IFS Business Reporter.You could navigate to the Information Source page https://IFSURL/main/ifsapplications/web/page/Fact/InformationSource and query for the Information Source in question to see the availability. There should be two types (Client Type) of URLs. IEE and Aurena. Referhttps://docs.ifs.com/techdocs/Foundation1/045_administration_aurena/255_br_and_a/010_Information_Sources/030_configure_information_sources/010_ConfigureISFacts.htm#Information_Source_URLs \Sanjaya
@chrisbrigg , If you are getting this issue due to a new delivery of Business Reporter. It is recommended to get Support from IFS as this could be an error in the software it self, or could be due to increased amount of data fetched to the report.To confirm whether this is a software issue, please run the same report using the old IFS Business Reporter client you had.The latest (as of writing) IFS Business Reporter release for Apps 10 is 5.0.22. If this is an issue in this particular version, it is highly likely that this might have gotten fixed in 5.0.22. Sanjaya
Hi @Antbarrif, If you have granted necessary functional permissions, company, GL Authority etc.., then you should be able to see data without requiring to grant IS Full Access. So I recommend finding the root cause without giving IS Full accessIS Full Access is supposed to be used for special cases such as transferring data to data warehousing purposes (ETL) where all data should be transferred without row level security considerations, solving performance issues. \Sanjaya
Hi, There is a http call from IFS Database to the IFS Middleware server during BR Report execution. It is highly likely that this error is related to that call. Refer https://docs.ifs.com/techdocs/foundation1/020_installation/020_installing_fresh_system/010_planning_installation/020_security_considerations/030_oracle_ssl/ \Sanjaya
It is possible to use the “ALL” parameter value functionality for this purpose.https://docs.ifs.com/techdocs/foundation1/045_administration_aurena/255_br_and_a/040_Services/010_manage_BRA_services/010_BRA_System_Parameters/default.htmWhen “ALL” (the configured value) is entered as the parameter value, values including NULL will be shown.
Hi Johan,Thank you.FYI. This is a remote deployment.I tried both ones. Since I could not get to working with the default one, I’ve created a new Azure hub.I get the requests to the hub but they fails. I believe this is due to settings up none of below. Sanjaya.
I am assuming you are using a Remote Deployment based on the question.If it is a remote deployment, then it is possible to view this information in the helm charts. But it is required to understand helm templates to read this information.When running the mtinstaller, the helm charts will get downloaded based on the chart version used. This will be downloaded to local helm repository cache. It is possible to find the location of the helm charts by looking at the helm env variables by running the below powershell command.helm envUsually the path of the repository cache is “C:\Users\username>\AppData\Local\Temp\helm\repository”Once the chart file is extracted (first .tgz and then the .tar), the whole Helm chart can be inspected.The file “ifs-cloud\charts\applicationtemplate\templates\_application.tpl will contain the calculation used for setting up the memory and CPU. Below is from a 23R1 chart. Note that this can be overridden by individual chart (container). resources: limi
Failed Requests from Azure Notification Hub None of these settings were setup.@JOOLSE
Hi @JOOLSE ,I am interested in below information.Quoting 24R1 documentation.Does the Notification Hub exist and is it configured correctly? The Notification Hub requires configuration for each required client platform (Google, Apple, Windows). The Azure Notification Hub configuration pages can send test Push notifications to check this.What is the process to get hold of these configuration parameters? Whom to contact?Sanjaya
I have been with a support call with IFS RnD. These configuration values are internal to the App developers and they are not shared. (I am not sure there is a way to obtain them. I think generally it should not be possible.). So I think it is not possible to use custom Azure Notification hubs at all. (General case)Therefore this information should be removed from the IFS Documentation as I see, There should not be any mentioning about custom Azure Notification Hubs at all (or mention the specific cases they might be needed).The notifications for all the IFS customers are handled by the same notification hub.There is no need to change any of the parameters. Anyway it seems like the parameters which gets added during the installation of IFS Cloud is incorrect. I am yet to receive the correct parameters for NotifyMe. @Rukmal Fernando. I am tagging you.Could you please validate what I have written here is correct? Also will it be possible to provide the correct parameters?
An update.The parameters set during the installation is correct.I think some configurations were done to the central hub.Now the Windows and iOS notifications are working.
@JOOLSE , Yes. waiting for Android to work.
Hi, I am restating some information to mark this comment as the answer. For Notifications to work No additional Hubs are required. The parameters values defined during the installation is correct. Works for Remote deployments as well. Custom notification hubs are not necessary My opinion is this information should not be in the documentation If a custom hub is used, The hub should be configured with sensitive keys available only for the developers of the app (RnD) so that the notifications can be delivered to the App. These keys never to be shared with others Hence custom hubs cannot be configured for NotifyMe (Device) Android NotifyMe app permissions for Notifications gets dropped, (or does not get added during the installation). Therefore Android devices might not get notifications. Ensure that the notification permissions are granted to the App in the Device.Sanjaya
@ORFJAN ,The notifications are working for me now. The Notification Path you have provided earlier is not valid for IFS Cloud.Can you please check them? I got the correct ones from IFS and they seem to be the same ones I had (got inserted during installation).First iOS and window apps also did not work for me, but after reporting to RnD they started to work.Later found that Notification app permissions were missing for Android. RnD found that there is an instance where during installation the permissions are not requested.
@ORFJAN,I hope you are debugging by trying to send the notifications via Send Notification command. My question was related to Sending Notifications only. Can be tested via Send Notification command. “Send Notification” works fine in my case. If you are concerned about the business logic generated Notifications.I had an issue where the permissions cache not getting refreshed for existing users. (I did not debug this issue).Once I created a new user, there were no issues. with Business Logic (Order Report) generated Notifications.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
