Insights (Business Reporter and Analysis Models, EOI)

Where do I find the Design Row Grouping in Business Analytics?

I am getting the following error while running  an IFS Business Analytics Report. I am using a custom SQL Source to get some Project Management info.  It was working perfectly fine for almost a year.  System.OverflowException: Not a legal OleAut date.at System.DateTime.TicksToOADate(Int64 value)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.ParseValue(Datatype type, String value)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportExecutionMgrOld.CreateDataSet(DsrdResultSet resultSet, ArrayList physicalDataSets, ReportGenerator generator, String separator, Int32& recordCount)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportExecutionMgrOld.PrintReport(Dsrd dsrd, XlrTemplate template, ArrayList physicalDataSets, Exception& exception, Int32 lastDataSetId)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.ExecuteReport(Exception& exception, Boolean cacheEnabled)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.

I’ve made a quick report for a user however, they want to be able to right click each row and click view case. How do I make this an option on a quick report?  Thanks!

Hi All,I need to show the text 'SUPPLIER' vertically in a report. I tried using Vertical Text(text) function that is available in report designed but didnt get desired output.It not showing full text during preview. Anyone have an idea how to show text vertically   

I have shut off the First page, but when I preview the report it still shows the Header and Footer on page one.  I only need the Repeat page.  

When creating a custom report in Report Designer 200.2.0000 is there a way to copy from a Standard IFS report?  If not can someone explain to me why this is not available?

Request help for the strange behavior of the BA report extracted from GL Balance fact . The data is filtered on a particular code part . The format (border) for  a column which does not appear if there is not data is set as Underline and for the totals (Operational revenue in below the border line is set as Underline. For some code parts the Underline just appears partially and does not show up for other columns. Below is the issue. Not able to figure out what is causing this issue.  The underlines should extend to the other columns as shwon in RED but NOT hapening 

I have a user request to add Part and Part Description to the Handling Unit Label.  I would appreciate if someone could point me in the right direction.

We have a new project admin who is granted the same permissions as the other project admins and have Business Reporter installed on their laptop.When running a report through Business Reporter, it’s fetched correctly with no issue. However when it’s run from IFS it loads just the following. This works fine for everyone else and only just this one person is having this issue. The reports we are trying to run are not new ones and have been used by other admins for long time now.IFS version - Apps 10 UPD 10 IEEHas anyone experienced anything similar? An advice or suggestions? Thanks in advance!

Hi, I created a new Relation for Fact to use in my Business Report. I want to add the new Fact to the Custom Attributes for Facts menu. To do this I need to Unpublish the Custom Attribute, but I ran into an Error Message. See the screenshot below. Is there a way to work around/solve this issue, without unpublishing and removing the Fact Items that are used in current Business Reports?   

Hi everyone, In Info Services - Archived Reports, some users can’t see reports generated by other users, although they are added in the correct DG as per the user model. What else could be the issue? I’m using IFS 7.5 I appreciate all of your answers.

I have a custom field on the Inventory Transactions History Screen which I want to use as Criteria within a lobby datasource.  (Product Family=’1000’) however I am getting error of Invalid Identifier.  When I select * in SQL Developer or in the SQL query tool this custom field also is not available. What would be the best way for the custom field to effectively show in the database so I can use the needed criteria? Many Thanks Kirsten

The requirement was like this:       CASE          WHEN SUBSTR(PART_NO, 1, 2) IN('XX', 'YY', 'ZZ')  THEN           SUBSTR(PART_NO, 1, 2)         ELSE           'SP'       END CODE,See also >>multiple values in case statement | Toolbox Tech

I am getting the error “Error in IFSCommandPLSql Unexpected error while calling server method AccessPlsql/Invoke ORA-20115:The ":UL" has already been removed by another user.” when trying to upload files using 3rd party tool integrated to applicant function in IFS application) . NLS_LANG is set to AMERICAN_AMERICA.AL32UTF8. customer is using French in IFS application. Can some one assist to resolve this issue ?  

BR - which settings are  necesary for running the report from the applications, and view the report directly instead of fetching it in Report Archive ?  

I created a BR report for project budgeting and forecasting with writeback on ETC. It works ok. However, I have enabled drill down on certain cells and all these drill down do not show any data. Not sure this is an issue or I am missing some set up. Please share any relevant info. 

Hi,any idea how to solve this?If I run the report in BR Server manually in the BR Client- then it works without any issue.  Template DREHPLAN_2 has design errors.View the trace data for more details.Exception from HRESULT: 0x800A03ECSystem.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC   at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)   at Microsoft.Office.Interop.Excel.PivotTable.set_SourceData(Object )   at Ifs.Application.Br.ExcelInterface.Vsto.ExcelPivotTable.SetSourceData(String sourceData, String sheetName)   at Ifs.Application.Br.Rendering.ReportExecutionUtil.CreateNonBaPivots(IExcelWorksheet excelSheet, ReportSheet reportSheet)   at Ifs.Application.Br.Rendering.ReportExecutionUtil.SortReportSheets(Exception& exception)

Dear community,I want to create a permission set without any write permissions in IFS Aurena.first step:second step: But my permission set is empty:If I grant write permissions then everythink is fine.How I can I create a permission set only with read permissions? Thank you

Hi,I’m trying to create a quick information source from the GENRES module to look at the resource activity load data. I can create the QIS, however it’s stuck in Draft status and I don’t have the option to “Create Information Source”, and I’m only given the option to create another draft. Is there a step I’m missing? Any ideas much appreciated Many thanks   

Hi all, I have created a report using BA structure reapers in Accounting. I want to know whether we can get the original order of the accounting structure without automatically ordering the resulting data set in an alphabetical order.(need to see the exact same order of accounting structure in the report.) thanks in advanced!Niyomal

IFS10-UPD9Shop Order Pick List is missing Master Part number (highlighted in yellow), Is there an easy way/ setting we are missing to print main/master part number on the pick list?Is modifying report the only option we have? Thanks

Hi All,When we try to send email using print dialog email function. (IFS Application 9)We are getting the following error. Any idea how why we are getting this and how to fix it?Thank you,Jeewan

I’m new to IFS10 and Report Designer 200.2.0000.  I have been asked to change the labels on few fields in the OrderQuotationReport.I was able to click on DELIVERY_TERMS_DESC, delete the label and use the Text tool add the updated label. But I’m unable to do the same for DEL_TERMS_LOCATION.  When I click on that label it shows the Header properties instead of the Table cell properties?I have tried to move the ORDER QUOTE LINE section down to display the entire header, but that doesn’t solve my problem either.  I have 3 labels in this area that I need to update.If someone could point me in the right direction I would appreciate it. 

Get an empty form by Cyrstal Report in IFS 10 UPD9 IEE .When I select more than 10 records, then print Cyrstal Report in IFS 10 IEE.Sometimes I got some  spare empty form. And I checked the output, nothing missed.I want to know why.  

Hello,One of our users recently reported an error when trying to run a BR report, both locally on the PC from within the BR app *and through IFS IEE. The user was able to run the report with no issues within the last year and this started about three weeks ago. I can run the same report with no issues from my PC. We tried to re-install IFS BR w/ pre-reqs but the same error message still occurs.*EDIT: The user reported they can run the report successfully from within IEE.We’re looking into other factors such as if an application was recently installed that may be conflicting with BR but that seems unlikely. Has anyone else experienced an error similar or know how we might go about troubleshooting this further?