Insights (Business Reporter and Analysis Models, EOI)

I am trying to use CTE’s in a quick report, but when I try to execute the query in IFS’ Query Tool it gives me the error “Input ‘my_query’ ” did not match regular expression. I tried with a basic CTE, that works in PL/SQL Developer: WITH my_cte AS(SELECT 3+4 as result FROM DUAL)SELECT result from my_cte I am not even trying to use a regular expression. Does anybody know why it does not work? Here is the detailed error log:  Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> System.NullReferenceException: Object reference not set to an instance of an object.   at Ifs.Application.Fndadm.SQLQueryTool.frmDynamicSelect.ContainsAnyLOBItems(IList`1 columns)   at Ifs.Application.Fndadm.SQLQueryTool.frmDynamicSelect.Execute(SalString sSql)   at Ifs.Application.Fndadm.SQLQueryTool.frmDynamicSelect.UserMethod(SalNumber nWhat, SalString sMethod)   at If

HelloI have heard I can use IFS Lobby Web Access for viewing lobby by android i.e.But I dont know how to start with this. Where can I find LWA ? Do I have to install something ? How to connect to it ? Some basics needed to start :) IFSAPP9

Hello AllI’ve created a lobby element using the query builder in data source designer for Customer Sales Order Milestone. Data works no issue, however I can not see a way to sort the data by expected date so it looks more user friendly. What am I missing?Thanks Sarah

Hello, Some advice or how to guide on adding a dimension(s) to an existing FACT table.We would like to use FACT_IL_ACCOUNT_BALANCE table for Business Reporter, we have also recently started using Accounting Structures from which the dimensions from accounting structures do not exit on the main FACT table or the underlying database view (as a persistent field)I believe we have to add the dimension to the FACT as below. From the existing set of dimensions here  Any ideas or help as to what I need to do to join/link the DIM_ACC_STRUCT_ACCOUNT to the existing FACT_IL_ACCOUNT_BALANCE table?Any guidance appreciated Thanks,Rob

When using query builder, I get multiple records when I use Join.   In The example below, I get 3x the records I expected, each record being duplicated 3 times.  I am assuming I am getting this due to the Join, my records from View A, the same records from View B, and the same records from the Join.  What can I do to only get 1 set of records and avoid duplicates?    

Hi,I saw the way to see the view being used as the backend for a page is to go to Debug console but for some pages, I could not trace the view. I want to see the time a FSE has spent in a work task & fetch it into quick reports.

Hello,  Does anyone know if is it possible to enable Macros in Business Report? I’m developing an Business Report where I need to block some cells based in the value of another column, a Macro would be very helpful in this sense. Thanks in advance

I'm currently in the process of defining and creating out permission sets. For finance, I have a general functional set that grants read-only access to all projections downstream of the three “Financial%” navigator tree headings.When I checked the access to the "Month End Process" lobby in the IFS, I found that the "Depreciation Proposals" and "Overall Status" elements are broken (Assuming the former feeds the latter). I thought that clicking on these elements to navigate to their data and then using the debug menu to find the projection that is required for these elements would work, but in this case, the "DepreciationProposalsHandling" projection was already granted and the elements are still broken.Can anyone offer guidance on how to find out what projection is needed for these elements and for other IFS Created Lobby / Lobby elements?

HelloWe plan to use Crystal Report defined operational reports and these are working fine.  However, I’m trying to set the default layout for purchase orders based on the country of the order using a Report Rule and the Crystal Report layouts are not appearing. Is there a way to make the Crystal Report layouts available for selection as part of a rule?  We’re using 22R1. Thanks in advance

Hello,When we pass a XPATH value in Report Rule-->Actions for type ‘Set Property’ , the report works fine in IFS EE but not in Aurena.(Apps 10)The Xpath fetches a number for property list ‘Copies’NOTE: If we pass a number for Copies directly , it is working Ok in IFS EE as well as IFS Aurena. Below output when xpath value is used in ‘Copies’:In IFS EE:In IFS Aurena:  Can someone please help us on this. Thanks

I’ve got a training of lobby on EE. But I don’t see any material on IFS Cloud. Please help.Thank you in advance

This might be a simple question, but it is something I have never done.Is there an easy way to sum a column on a quick report? Basically, I created a view and based the quick report off of view, but now need a sum to appear at the bottom of a column.like this: 

We are facing issue while trying to trigger a BR. The BR is triggering on Contract table and based on some requirement we are posting the contract through perform_review_and_post_contract MPM.

Hey guys, I am working on cube server and testing IFS Lobby with it. When I try to test my elements on the lobby, after few tests I get below error (Fig 1) in the slicer and find no values in the lobby (Fig 2).  Fig 1 Fig 2 However, when I restart IFS application, it somehow works. I also, get some kind of error (Fig 3) in data source designer as well and I believe, this error is connected to above error. Fig 3 

Hey guys,  I am working on data source type “Cube” > Cube Server “Tabular”.  I am trying to insert few measures in the table, whose data formats are percentage with 2 decimal values. However I keep getting below error.   I have no clue what does it mean. Can anyone help me with this?

Hi!As I said in the title, I need to know which table contains a specific column. Would the following query work for that? What should I put in the from-clause? SELECT      COLUMN_NAME AS 'ColumnName', TABLE_NAME AS  'TableName'FROM        WHERE       COLUMN_NAME LIKE '%storage_instructions%'ORDER BY    TableName            ,ColumnName;

I created a simple lobby with a single element that takes the count of a data source that filters Purchase orders by STATE = ‘Complete’ (Status, Shown as STATE within the Columns for some reason)Within the element designer i have “Use data source condition” ticked and when viewing the lobby from EE the link works. When viewing in Aurena i cannot click the link. Is there a reason for this? I Even on the Application owner account with full permissions it won’t work. The Element / Lobby are  both set to Aurena . 

How do I set the default columns that user sees when they create a Purchase Requisition, and add Part Lines. I want a field that is not in the default selection to be visible for input for ALL users by default. If they choose to overwrite and hide, fine, but by default I want it there to revert back to. 

HI Team,when I schedule my BR to be send by mail (Report Archive ticked as shown below) and save it in a trust location ==> the report loose his excel formatting (bold, Highligh) but when I run directly from IFS or Business Report , it is all good and formatted. Any idea WHy ?Thans  

Hi Everyone,We recently installed crystal web service(x64 bit setup) in one of our client’s server and pointed it to IFS cloud (22R1 Update5) application. We are facing two issues when we are checking the web service functionality after the installation.When we test the web service with a sample layout pointing to the CR layouts location, it doesn’t return a binary response to indicate the connection between the Crystal web service and crystal report. When we execute a crystal report through application, it returns an error like below. 

I'm trying to install analysis model on IFS race environment but unable to test connection due to following error message. Anybody can help me to resolve this?   

Hi! Have anyone done a integration between Active Director and IFS10, where the user pictures are imported? We have user pictures in AD and would like to have the same in IFS10.   /Karl

Soring on one specific column on an Business report is not working, seems excel is working fine but there is some issue in this BR report design on a specific column, Can able to sort other columns easily , may you please assist.

Hi All, i have a SQL query to join 2 simple datasets, i am receiving an error saying "PROD_STRUCT_ALTERNATE_CFV"."PART_NO": invalid identifierFailed executing statement (ORA-00904: "PROD_STRUCT_ALTERNATE_CFV"."PART_NO": invalid identifierrelates ot the ON part of the statement.If anyone can help i would appreciate it.the basic select query was working before i modified it to include the join from the other table.SQL is as belowSELECT objid,objkey,bom_type,alternative_no,contract,part_no,cf$_total_plastic_weight,cf$_total_regrind_weightweight_netFROM ((SELECT objid,objkey,bom_type,alternative_no,contract,part_no,cf$_total_plastic_weight,cf$_total_regrind_weightFROM prod_struct_alternate_cfv WHERE alternative_no ='*' AND bom_type ='Manufacturing' )

Hi all,I am getting the following error while opening the Business Reporter. Any suggestions to resolve this issue? ************** Exception Text **************System.Runtime.InteropServices.COMException (0x80004004): Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))   at Microsoft.Office.Core.COMAddIn.set_Connect(Boolean RetValue)   at Ifs.Application.ExcelReporter.AddInManager.GetConnectionAddInObject()   at Ifs.Application.ExcelReporter.AddInManager.SetConnectionAddInProperty(String name, Object[] values)   at Ifs.Application.ExcelReporter.ReportLoaderOperations.PerformBasicValidationOnLoad()   at Ifs.Application.ExcelReporter.ReportLoaderOperations.LoadReport(IUiCallback uiCallback)   at Ifs.Application.ExcelReporter.MainWorkbook.ThisWorkbook_Startup(Object sender, EventArgs e)   at Microsoft.Office.Tools.Excel.WorkbookImpl.OnStartup()   at Ifs.Applicat