Insights (Business Reporter and Analysis Models, EOI)

We have noticed that Auto Grating of Permissions when Publishing Quick reports In our UAT and PROD environments.We this this is a security issue and it should be corrected ; as per the current setup when publishing Quick reports , it will modify FND permissions and adding quick reports to the Core Permissions sets and other all permissions sets in the system 

Hello Community, We want to install exel add in for App 9 via link and wonder where we can find the link mentioned in below documentation. Please see marked in yellow in the attachment. Note: we have  ATU licens.  Thanks.   

Hi, I want to create a custom field under “Work Task” which auto populates the id of the person which closes the ticket. Need guidance regarding this. Need to know If there is any field which is by-default given by IFS which we can use for the above purpose. ThanksMani Shankar

We have situations where reported faults may need quite some investigations before the origin of the error is identified. In such cases we wish to be able to enter an intermediate pre-posting against the work tasks which will be updated once the true cause is identified.In the normal case this is not an issue, but at year end we will want these intermediate work task cost postings to be posted to the balance sheet. Is there any way we can do that to just selected work tasks or is there a clever way to do it? We do not want all our work task postings registered as WIP.@Thommy : Would you have any input on this?

Hi community,can fields of Ad-Hoc report be translated? I created an ad-hoc report from a custom view.  In metadata label-message-id is added for each field.I created message translation type Label and Report Label for the messages. Columns of ad-hoc report are still not translated. How to get the columns of ad-hoc report translated? Thanks in advance for your feedback. ~Juni

Hi Expertsi have created a Report of fix Assets object Transactions. Now i have objects (rows) where the total value of the obect at the starting periods are 0. That means the total of the object transactions equals 0  Is there a Solution or workarround how to filter these Rows from the report automatically? I tried to preset a filter in the design but it didnt work. The filter gets deleted as soon as you run the report  I also tried to add a advanced filter on the repeater and also on the field

How can I know various tables in which my cloud data is stored? I created some sites, service requests, work tasks etc. & now I want quick reporting on them, so how can I know in which table that info is stored so that I can use SQL statement?

Hi Everyone,  I was wondering if anyone else has come across issues when creating custom information sources and dimensions. When ever i create one from an IAL i find the filters in business reports utility don’t seem to work and i end up filtering my fields in the IAL before converting it to info source.  If anyone else has a solution or idea for me to try please feel free to let me know. ThanksCameron

who to create new  order report.thanks. 

I am trying to create a MTD sales summary for a Lobby.  We have two companies.  One uses USD and the other uses Korean KRW.  We have currency rates in the system for the conversion of USD to KRW.  Is there an api to get the currently active exchange rate?

this is my operational report setting, every time the crystal report will be invoked and generate PDF automatically. I’d like to archive only, but don’t like to trigger crystal PDF. how can I accomplish it? I know I can do it via “order report” with “archive only” check-box manually.  

Hello community. It is a way to have a list of transactions IDs and their use ?thanks a lot,Emilia 

Hi,When adding a time report we get double lines in Aurena.It looks correct in IEE for the same work order.When select 1 line in Aurena it automatically selects both of the lines.I have create an employee to several companies where this doesn’t happen, it’s only in one company we can see this issue.Someone that knows what the reason can be?Thanks! 

Hi guys, Need help to understand how show the menu Analysis models in IFS Cloud. I see BIBASE component installed, but the menu is not available. I already configured SQL Server and all requirements from here IFS Analysis Models - Installation Checklist - Technical Documentation For IFS Cloud, but when I arrive to SETUP ENVIRONMENT ASSISTANT, I cannot find this item. I tried PERMISSION SET, YAML file, reconfiguration of SQL Server, but nothing works. Did anybody have any idea? Thanks,Gianni 

When I run a quick report through IFSAPP it works fine, after that I run it on any user it shows the error.  When I run Quick report on user ID that error is show  

Hi All- I am getting this error in my Crystal Report (please scroll to the end), Many Thanks. 16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] File Name : BA_BRO_ADDR_(v0.1).rpt16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] The file C:\IFS\I

Hi all, I am having trouble sorting data by measure item in business reporter. Does anyone know if there is a BR functionality that enables you to do so? If not, any good work arounds? Any help would be great, thanks! 

Hi, Please, can someone advise me how to add LoV while ordering Business Report in IFS Client. For one parameter there is no list of values and I don't know why.  If I check the dimension for this parameter in Dimension Item Details I see this set up.   Is it publishing Info window where I should set something to get LoV in Client.  Anyone any Idea ? Thank you Martin Gestinger

I wrote an SQL query using the SQL Query Tool in IFS App 9. But when I try to save the query as a Quick Report it states: SQL expression is wrong (SQL-Ausdruck ist falsch).The query runs fine in the IFS Query Tool and unfortunately the error message does not specify why the SQL expression is wrong. Does somebody know what is wrong with my query?

I’ve created a Dimension in IFS Apps 10. I’ve then used Custom Dimension Connections to connect the Dimension to the Appropriate Information Source. I can see the Dimension in IFS Business Reporter and add it to my report. When I run the report I get the following error. If I remove the field and re-run the report it runs fine. How do I find that specific item and set the appropriate permissions to it?  

Hello, We keep getting corrupt BR Excel files that are placed on our network drive:​​​​This is completely wiping out our BR Excel reports and are unable to recover...Any thoughts? Thanks

Hi, Does anyone know if it is possible to add more parents values in Business reporter to Enter Parameter Values. As you can see in my example now. If I want to choose department value, I need first choose parent value company. Based on choose parent value (Company) I get data for departments, but I would like to add one more parent parameter. But I am not confident how to do it.  

I have attempted to login to my IFS Portal which has not been used in a long time.It does not recognise my username or password but will not allow me to register again as it recognises my email address. How can I find out my username in order to reset my password?

I’m getting following error when try to run ModuleRep.rpt in new cloud installation.Cannot connect to the Crystal Web Service through  http://XXXXXXX:80/IFSCRWebSetup/Ifs_ReportService.asmx. Please Contact your System Administrator.Web service call not received to IFSCRWebSetup logfiles even though Crystal web service is installed and able to test with blank.rpt and db.rpt.Thanks,Lakmal

Hi,According my understanding, as the IAL views, the Access views are configured (created on demand by an end user) and belong the IFSINFO schema.For the IFS managed-cloud hosted customers, that offer the opportunity to use them via a direct access to the database allowed only to IFSINFO schema. But something remains not clear for me.In the technical documentation for IFS CLOUD (https://docs.ifs.com/techdocs/21r2/045_administration_aurena/255_br_and_a/050_integrations/080_external_access/010_access_views/) it is mentioned: "Access Views are used as the source for loading the Tabular Models specific data layer in SQL Server." "When the Access Views have been created, the Tabular Models framework can be setup, necessary model objects can be deployed to the SQL Server database and then a data load can be performed where the Access Views are used as sources when transferring data from IFS Cloud database to the SQL Server database.".I assume t