Skip to main content

Insights (Business Reporter and Analysis Models, EOI)

This will include the questions related to Business Reporter and Analysis Models, and Enterprise Operational Intelligence.

  • 614 Topics
  • 1,715 Replies
614 Topics
S
Do Gooder (Customer)
SunnyDay208Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Permissions & Business Roles

Is there a way to see what permission’s or Privilege's are attached to a specific business role? 

1755
S
Do Gooder (Customer)
1 year ago
C
Do Gooder (Partner)
CD2022Do Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Business Reporter- Issues using drill down function

Hi All, Is it possible to use the drill down function but point it at a dimension instead of the original info source ?  Current report - The report currently uses a custom Info source that has grouped data in the IAL so the drill down wont go further down if I point it to the info source.  I am wondering if its possible to point the drill down function to the Dim showing the same columns just without the grouping ? When I have tried to do this - I set up the custom dimension connections and it seems to wipe out my information source in my report as if there was a failure of the connections.  Any advise would be appreciated  ThanksCameron

1463
C
Do Gooder (Partner)
1 year ago
N
Sidekick (Customer)
NorahmfSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
quick report error

I create a quick report from view created in database but when try to order report I faced this issue I need urgent help please.is there any missing step or something?

1114
N
Sidekick (Customer)
1 year ago
P
Sidekick (Partner)
PlaBhagyWSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Advanced Criteria not working

Hi, I am trying to create a Business Report in APP 10 using advanced criteria for a cell. It is not working as expected. Appreciate any support in solving this. Advanced Criteria:DIM_ACCOUNTING_PERIOD.ACCOUNTING_YEAR = 2022 AND(DIM_ACCOUNT.CODE IN '60900';'61900' OR ((DIM_CODE_G.CODE LIKE '10%' OR DIM_CODE_G.CODE IN '4000';'4100') ANDDIM_ACCOUNT.ACCOUNT_GROUP = 'G13' ANDDIM_ACCOUNT.CODE NOT  IN '60900';'61900';'60999';'61999'))Report Result is -915,006.71.Expected result (Querying through SQL) is as below. When you analyze the data set in business report it shows without the brackets. 

691
S
Do Gooder (Employee)
1 year ago
U
Do Gooder
USLA
asked in Insights (Business Reporter and Analysis Models, EOI)
Get BR Publisher information

When we install IFS BR as ClickOnce or MSI, it did not provide the publisher. So we are facing security issues. How we get these information.    

110
U
Do Gooder
1 year ago
R
Do Gooder (Customer)
ramankDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Order Report menu to run Operational Report in MWO

We can see Order Report menu to run Operational Report in MWO is not visible.please let us know how we can run the operational report in MWO Service App

350
R
Do Gooder (Customer)
1 year ago
A
Do Gooder
aalyDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)
Error while open BR

Dear Support,  We are gating the below error when open BR in excel.  

553
B
Do Gooder (Customer)
1 year ago
K
Do Gooder (Customer)
KyleDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
SQL Quick Reports - Custom Function

Hi,I created a custom oracle function in app owner schema.I granted EXECUTE to IFSAPP, IFSINFO, IFSPRINT and IFSSYS on the function.The SQL Quick report that uses this function is throwing a ORA-00904 error which I know means it can’t find it.I am calling the function within a SQL statement as <appowner>.<myfunction>.Are we able to use custom functions in a  quick report?And if so, what user needs access to it?  I thought it was IFSPRINT but apparently I am wrong.Thanks!

962
K
Do Gooder (Customer)
1 year ago
Maja Stanislawska
Sidekick (Customer)
Maja StanislawskaSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Dynamic file name for a scheduled quick report (IFSAPP10)

Hi,Is there a trick to dynamically change scheduled quick report file names, for example to include the date of the run YYYYMMDD_HHMM_MyQuery.xls?Some time ago there was a discussion on dynamic parameters for scheduled quick reports, but it does not cover file naming. 

1794
J
Hero (Customer)
1 year ago
N
Do Gooder
nayeem285Do Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)
Report View Error

We have created a sample report in prod environment. When we went to preview the report it shows following error. 

1902
ChanakaAmarasekara
Hero (Employee)
1 year ago
X
Do Gooder (Partner)
XitRamadJDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Object reference not set to an instance of an object - Form Level

I am facing issue in form level. When open the form below error is coming and designer file is not opening.Please give some solution to overcome this problem. Note:  I have rebuilt the workspace, deleted the file in workspace and took new files in harvest, reset/updated the server files. I tried to open the form with different user’s login with their workspace but same issue coming for them also.

1712
X
Do Gooder (Partner)
1 year ago
U
Sidekick (Customer)
Unscented0296Sidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Why do my CTE's keep failing?

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 Ifs.Application.Fndadm.SQLQueryTool.frmDynamicSelect.vrtUserMethod(SalNumber nWhat, SalString sMethod)   at Ifs.Fnd.Ap

1633
S
Superhero (Customer)
1 year ago
W
Do Gooder (Customer)
WFMGALKADo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Lobby Web Access IFS9 - how to start

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

501
W
Do Gooder (Customer)
1 year ago
C
Do Gooder (Partner)
CD2022Do Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter -Using wildcard in a report parrameter

Has anyone come across a way of using a wildcard (‘%’ OR ‘*’) in the report Parameters so the user can select all without having to type the individual values?  They may need to run the report with one value in the parameter or  with no filter so it gets everything pulling through. Any advice is appreciated. Cheers

1956
S
Do Gooder (Employee)
1 year ago
S
Hero (Customer)
sholmesHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Apps9 Lobby sorting - can't see how to in query builder

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

2793
PvanderHeyden
Do Gooder (Customer)
1 year ago
R
Do Gooder (Customer)
Robby CDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
BR - Adding Dimension to FACT table

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

2824
D
Do Gooder (Customer)
1 year ago
B
Do Gooder (Customer)
BrendanDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Query Builder: Restrict duplicate records when using Join

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?    

54611
B
Do Gooder (Customer)
2 years ago
H
Do Gooder (Partner)
HDZANUSHAKHDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
How can we see the db tables /views for underlying elements in Aurena page

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.

1203
M
Hero (Partner)
2 years ago
L
Sidekick (Partner)
Luiz RSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Enable Macros on Business Report

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

390
L
Sidekick (Partner)
2 years ago
A
Do Gooder (Customer)
Aimee2801Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
How to determine Permissions required for Stock IFS Lobbies

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?

891
A
Do Gooder (Customer)
2 years ago
M
Hero (Customer)
MMcKHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Selection of Crystal Report layout using Report Rule

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

941
M
Hero (Customer)
2 years ago
T
Do Gooder (Partner)
TecAnujpGDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Xpath input in report rule not working in Aurena

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

1931
mattconk
Sidekick (Partner)
2 years ago
Andryis
Sidekick (Partner)
AndryisSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Serching for lobby education materials on IFS cloud 21R1/2

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

1182
cperdue
Hero (Partner)
2 years ago
C
Hero (Customer)
chajashHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Sum on column in a quick report

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: 

4524
C
Hero (Customer)
2 years ago
P
Do Gooder (Partner)
p.pritiDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
posting the contract through perform_review_and_post_contract MPM

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.

251
P
Do Gooder (Partner)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings