Insights (Business Reporter and Analysis Models, EOI)

I am attempting to configure IFS Facts for extraction to our data lake. My goal is to have the facts incrementally load on a per day basis so that the resulting parquet files are created daily and the files have the date appended to the file name. It looks like most of the Facts only have datetime columns. Is there a way to add a date column to the OOTB facts for partitioning? I currently only have access to the IFS cloud user interface. 

How to enable turn on 

I know there is a lot of Crystal is deprecated discussion in 25R2. We were just sold an Add-On for Crystal Reports with 25R2. Has anyone else gone done this path? I am not seeing anything about anyone doing this.  Does anyone have info on getting Crystal Reports going in IFS Cloud?

Hi, We are using Apps 10 and in the process of upgrading to Cloud. I downloaded Business Reporter for Cloud but now I’m not sure I can log into Business Reporter for Apps 10 any longer? How can I use both while we are in this transition? ThanksStacy

Why is an on prem gateway necessary for the connection between ADLS Parquet datasets and the end user’s Power BI instance? 

Hi,I’m experiencing the following issue with IFS Cloud 25R2 SU3 and was wondering if anyone else has come across something similar.What I have done was:1. Create a Query using the Query Designer window.2. Add more than 16 columns to the view.3. Save and publish the Query.4. Create a Quick Sight report based on the Query.5. Open Report Studio and start creating a layout for the report.6. The JSONDataSource is not visible/available. However:7. Go back to the Query created in Query Designer.8. Remove the additional columns so that the Query contains a maximum of 16 columns.9. Save and synchronize the Query.10. Go back to the QuickSight report and open Report Studio again.11. The JSONDataSource is now visible and available. Has anyone experienced a similar issue?Do you know whether this is a bug, a limitation of the tool, or an expected behavior?Or am I missing a configuration or step somewhere?Any advice or insights would be greatly appreciated.Thanks in advance!Chathuri 

Hey all,We're on IFS Cloud 25R1 and working through our Analysis Models - Power BI setup (Advanced Analytics, IC10126), following Deployment Scenario 3. Getting our Azure/ADLS Gen2 side sorted with our network engineer and had a couple questions for the community:1. Storage sizing for the Golden Workspace / ADLS Gen2Anyone have real-world numbers or a rule of thumb for how much storage the Parquet Data Sources end up using per functional Area (Finance, HCM, Procurement, etc.)? Just trying to get a ballpark so we're not over- or under-provisioning.Also curious if anyone's used Azure's Hot/Cool/Archive tiering on the ADLS Gen2 container to save on cost — like keeping current data Hot and tiering older Parquet snapshots down. If you've done that, did it cause any headaches with Power BI refresh?2. Turning on just a few models to startFor our initial testing, can we enable only one or two Area models (say Maintenance and Procurement) instead of the whole set, just to keep things lean and c

We’ve had this issue for years now, with no solution. BA Report displays dates in correction Australian format when run via BA Excel Add-In. However, when report is schedule or run from IFS application  any date references on the report revert to US Format. E.g. if there is a header in the report referencing the date the report is run or the date entered in a parameter it will show 9th June 2023 as 6/9/23 instead of Australian format of 9/6/23. Just wondering if anyone has resolved this?

Hi,In IFS, this is what shows as the explanation for parameter Allow nested repeaters.In technical documentation, this is what we found.They both don’t seem to behave the way it is explained as regardless of TRUE / FALSE, it behaves the same. Can someone please explain the purpose of the system parameter?

I’d love to see Business Reporter be able handle the option to decide whether to include the hold table vouchers or stick with updated vouchers only.

Hello everyone, We’re running into occurrences where we make a minor change to a business report previously published in the database removes that report projection from all permission sets other than the permission set “BR_FULL_REPORT_ACCESS”. This is requiring permissions to be modified each version of the report to restore permissions back to where they were prior to unpublishing the active report. Is anyone else running into this issue? Would love to hear how others are managing permissions related to IFS Business Reporter around changes to existing reports.  We’re working off the technical documentation here. 

Hello community,I am here with a new issue. 😊In IFS Cloud, we can manually scan delivery notes.Now I want to automate this process using BPA Workflows.The first question is::Can we read or scan a PDF file with workflows? Thank you in advance.

I get an error when previewing a Report Studio - Designer layout in Build Place.IFS Cloud Version 24R1SU0Can't I use a  Report Studio - Designer layout in Build Place?Error:The Print Job can not be printed due to Redis queue failure. Contact System AdministratorThe capture below is Report ID:MODULE_REP.  

Dear communityI created a user interface workflow for training purposes only. It prompts the user to fill in the "Customer RF" field for a specific customer.But I get the following error message: Here is my workflow:Where am I going wrong?

Hello, I created some exel report via IFS Business Reporter. I created some UDF function via Microsoft Visual Basic Editor. I used my function in report and it works fine, but problem is, that it works only when I run it. When some other user open this Business Report or is sent via Execution server, UDF function is not in the exel sheet. Could somebody help me how to save macro or UDF correctly in IFS Business Reporter to be globally available? Thank you Romana

Business Reporter has an 32 bit client released. However the customers in large organizations have quite often office 365 64 bit client on company level. This cause an great problem as it requires an standalone computer with an local Office installation outside the company standard.  This require a extra resources for customer IT department and takes resorces from the parter technichians. When will an 64 bit client be available? Please vote if you struggle with the same problem.

Hello,I’m currently operating on IFS v10 and have Business Reporter installed. Everything works fine.Now I’m testing IFS Cloud 25R1. Do I need to install Business Reporter again since the connection will be completely different? That is, I can’t just change the link for connect to:Thank you!

We have been using the Detail Statistics pages in IFS Cloud 24R2 to report Invoiced Sales, Order Entry, etc, it’s a differential update report, so if there are no changes, it doesn’t update the lines. Someone in the organization has updated the name of a large customer, and so now, we have two customer names associated with the customer number in the Detail Statistics.I’m wondering how we could force it to update the lines. I’m guessing with a deletion migration job? BUt I wondered if there was a less scorched earth approach.

Hi All, It should be possible to run IFS “in memory”, this means the data-entry tables will run fully in memory.You will be able to select the tables which run in memory. This is facilitated by Oracle.I am curious whether someone has experience with this mode of running parts, or total IFS , in memory. Questions like:Will analytic background jobs run faster? Do you notice differences in data-entry? Do you notice differences in your analytic environment? Thanks in advance,Johan

Hi EveryoneOn the Page “AD User Mappings for Financial Models” one can Generate Access for General Ledger Code Combinations. In some Cases not all Combinations get generated namely.GL Authority Combinations (We only use it on Account and Cost Center, all other Elements are %)MAX: Account = %, Cost Center = %Voucher Row:Account = 24790, Cost Center = nullThis Combination is Missing in the [CODESTRING_COMBINATION_RLS_BI_TAB] and therefore RLS is not working properly in GL Analysis Model.The Generate Access Procedure must include null combinations. Currently it only takes combinations into account where the code part exists in code part values, but a combination of account without any other posting element ist very viable. 

Does anyone have a suggestion on how we can track who and when lobbies are being used in apps 10? Or course we can create an API with a get-function that updates a history table when called, but I wonder if anyone came up with something more elegant or had a discussion with IFS on this? One of the recent updates enables this for quick reports and this is a great tool which can help us identify which reports are important and which could be phased out (we have 2000 reports build over many years). 

Hi, I need to know how to use information sources in power bi, i can’t open examples from doc.ifs. Could any one explain it? I don’t have licences for analasys service I use fact transfer by excel but i don’t know how to use it in power bi.

HelloIn IFS Cloud, there are so many screens that had been defaulted with setting up certain conditions as below snapshot, which may make some confuses for end user when they search some items but not pop-up as expected. Can these be cleared up by users themselves or need to IT help? Please help to advice. ThanksSusan 

A. What is your idea?Build and Release an Analysis Model for Request Management so that customers can explore the data in BI tools. 2) Brief descriptionThis is a gap for our customers who are adopting Request Management.     B. Context and scope1) Who is affected?Customers C. Value and impact1) What is the business outcome?Improve analysis outcomes of Request Mgmt module.  In the absence of this model, customers are forced to come up with labor-intensive workarounds and lack confidence in the data. E. Additional details 2) Would you like to participate in validation or early testing?Answer “Yes/No”.Write here:  Yes