Insights (Business Reporter and Analysis Models, EOI)

Hello,I have a requirement to make the data source - FACT_GL_TRANSACTION as incremental data load and I have modified that in Data Load Definitions -> Data Source ->FACT_GL_TRANSACTION - Incremental Load (condition got auto generated based on mvt_created_dt).Although my existing access view FACT_GL_TRANSACTION_BI, has the data access type set as online and it is created based on FACT_GL_TRANSACTION_OL. Hence, full load will be sent every time when the data load runs as the mvt_created_dt in  FACT_GL_TRANSACTION_OL is sysdate.I don't see any option to modify access view - FACT_GL_TRANSACTION_BI to change access type as datamart. Can you please suggest me how this can be handledRegards,Manisha

Hello,We have a data source - FACT_GL_TRANSACTION which needs to be sent as incremental load to Azure. But the load goes into error while the data load runs. Any idea why ?  

Steps to recreate the issueCreate a Report Rule for any report. I have checked this issue for the Order confirmation report (CUSTOMER_ORDER_CONF_REP) with an Action type of “Route to Connect”. And use “ResultKey” as an OutputFileName So, When I print the Order confirmation Report, I got an Email with the Output name combined with ReportID_ResultKey.  Not only with “ResultKey”.But if I use only “ReportID”, then It send an email with only ReportID as an OutputFile Name.  Expected resultExpected result would be to only get ResultKey as an OutputFileName in the attachment without ReportID combined.  

HI,In some cases BR reports  that have been working properly stops reconginzing field names and show #VALOR or #¿NAME? in each cell that includes an IFS field. The formula ribon however shows the field properly. That change happens after running the report and going back the Design mode.  In some of those cases the BR still works and show data when I press Run report, but in other cases the report stops working. Do you now how to resolve this problem?   

I get below error when I open IFS Business Reporter. Any suggestion/ solution is highly appreciated. 

Hi All,  I am just having a play with the GL Balance information source and wondered if I can supress rows with 0 balances I currently have the 3 elements below with a row repeater of account There seems to a few account that has a 0 balance. I was wondering if i could exclude that from showing in the report. I have tried setting row filters and cell filters.(Is not Null and not equal to 0 ) doesn’t seem to get rid of them. Is there something obvious I am missing here ?  Any advice is appreciated  ThanksCameron

Hi, I have created a custom field and added that into an entity. I also created a new entity/projection/page with some custom fields. I tried to query into the custom views using PLSQL developer, I used:   SELECT * FROM IFSAPP.PART_CATALOG_CFVBut it gives the error: “ORA-00942: Table or view does not exist” For the custom page, I can see data in the client, and I used the View name shown in the debug console for the query, but still gives the same error.I’m using IFSDBREADONLY as the user. Any help to resolve this? Thank you.Kalindu  

Hello, I created a Quick Information Source based on an IAL, I could enable the Zoom-In, however I can’t create Workbook/Sheet Slicers based on my QIS/Custom IAL.Is there a place where I need to enable the option?Also, does anyone have documentation on this? I.e., Documentation on creating IAL/QIS for Business Reporter. I’m also trying to make the Drill-down option work (it is enabled but giving an error message).Thanks in advance

Hello BR experts,I have created a business reporter based on structure where I am trying to compare GL and IL Balances. Column HFM Balance is using source Internal Ledger Balance and Statutory Balance is using GL balance.When I defined a filter for Ledger ID on HFM Balance column, report gives me error shown on the screen shot.The only way to apply a filter is on cell level. But I am afraid it will reduce report generation time if I apply filter for each cell in the report.Basically my question is how to enter the filter that will bypass this error?   ThanksFurkan

Hi,We have encountered an error with the view FACT_ACTIVITY_CALCULATION_BI which I believe is part of the Analysis Models.The error is:ORA-00904: "ACTIVITY_CLASS_SEQ": invalid identifierHas anyone else experienced this?It seems that it is because the view thinks that "ACTIVITY_CLASS_SEQ" is a column in FACT_ACTIVITY_CALCULATION_OL but that view does contain that column.This is causing failures for us when we are trying to load the data into the SQL database.Any help would be appreciated. Thanks,Mark Mruss  

Is there any documentation available on how to connect Power BI from apps 10 which is on managed cloud . What are the best practices like using SSAS . Please share the details.

Hello to the community, I am using GL balance data set to create reports on Business Reporter; All credit values, revenues are shown as negative amounts and costs have positive values; I was wondering if I could switch this value format presentation somewhere in order to show cost with minus sign (-100) and revenues as positive amounts?  Thank you for your help :)  Tanya

Hi everyone, Having some issues with Crystal that I can’t seem to wrap my head around. I’m trying to pull through the list of operations on a Shop_Order as they appear within the view, however Crystal is splitting each onto a new page. No ‘keep together’ options are working to resolve this either… Am I missing something? I’ve attached a screenshot of what result I’m getting, VS what I’m TRYING to get to.Appreciate any insights!   

Hi,We have a report rule setup for the report CUST_STMT_ACCT_REP which sends an email for users. we have renamed the attachment as below to take the customer no.Environment = Apps9 But the attachment name is not getting the customer no and we receive attachment name as below. Are we missing anything here? Any help would be appreciated.Thanks!

Is there any way to kep the Reports stay in the Reprot archive for 3-5 days

Hi, Has anyone ever set up an Escalation Handling rule in IFS? My team has tried to set up an Escalation configuration that would dispatch a “Case” based on criteria but we can’t seem to get it to trigger.  Any help would be greatly appreciated.Note: We really have yet to see a single Escalation Trigger work in action. A simple example of an Escalation Handling trigger in action may be enough to get us to the finish line.Thank you,Alex

In IFS10 on ifspp account one of reports in Operational Reporting is not available (C_PAY_GRIDLOCKS_REP). It has greyed submenu options: Order report, Show Archived Reports, Schedule Report, View Schedules. Other reports are available for print. When I try to add it to Report Schedule I got message: Report “C_PAY_GRIDLOCKS_REP” is not available for scheduling for current User (IFSAPP). In solution Manager / Operational Reporting / Report Definitions “Domain” and “Category” boxes are empty.Where can I unblock this report?

Can we create an order report with fillable fields like the attached PDF document using IFS Report Designer? 

I am trying to put together a data source where the column count only shows me results greater than 1. How can I do this?

Morning,We are trying to create a new lobby, but we it come time to create the datasouce (using datasource designer), we are getting always the error “UNABLE TO FIND xxxxx View” (where xxxxx is the name of the view). I already change the grants in all ways possible, and I don’t thing the problem is it. Did anyone have the same problem and managed to fix? Thanks, Gianni

Hi,Can someone advise me on how to add a chart for a table (Column/Bar/Pie chart) in business reporter.Thank you.

When we schedule a Sql report it comes through with a lot of unnecessary formatting that makes the resulting spreadsheet impossible to use.  All of our financial number fields have a carriage return and spacing. The reports export fine within IFS. Is there a place to tell  the system to send scheduled quick reports as data only?  This was not the previous behavior in Apps10 We are 23R1 UPD7

Hi,I have prepared a report in BR and it is working fine from Business reporter itself. After saving and publishing the report i am unable to open it from IFS Cloud. getting the following error: ************** Exception Text **************Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: This document contains custom code that cannot be loaded because the location is not in your trusted locations list: TB1_REP_4108_20230320-110225.xlsx. If you trust this document you can save and open it from a location on your computer.  For more information, see http://go.microsoft.com/fwlink/?LinkId=99104. Can any one help me here? Thanks in Advacne.  Polash 

[I’m very new to IFS, so apologies in advance for incorrect terminology / an obvious question / etc.] My company are moving to IFS Cloud, and want to customise some of the standard report templates. From the docs and this post, it looks like the process for this is:Install Developer Studio, and link it our IFS instance via IFS Lifecycle Experience, Azure VPN etc. Use Developer Studio to download the .rdf and .xsd files for the report we want to customise. Install Report Designer and edit the report template, creating a new .rdl file. Upload the new .rdl file to IFS Cloud, and link it to the relevant processes.Is there another way to do this? E.g. is it possible to download the .rdf and .xsd files directly from IFS Cloud, and edit in Report Designer; or better still, clone an existing report template from within IFS Cloud and edit that directly? [And if not, is there anywhere I can vote for that functionality?!]

Hi,There is an option already to export information source as .ins file. But I couldn’t find any option to import that file into same or another environment. I’m very grateful if anyone have idea for that. Thank you.