Insights (Business Reporter and Analysis Models, EOI)

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

  • 557 Topics
  • 1,570 Replies

557 Topics

B
Do Gooder (Customer)
BeckyDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Lobby Data Source count greater than 1

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?

5
B
Do Gooder (Customer)
4 months ago
K
Do Gooder (Partner)
KalinduDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Custom Field View is not accessible from SQL query

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  

5
T
Superhero (Employee)
2 months ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter not able to run report due to item 'probability'

Hi, I ran into an issue with Business Reporter. I use the data source Business Opportunities. But Business Reporter gets stuck when I try to run my report. There is no error message or some sort, just the screen below which gets stuck. By trial and error, removing items and then test run the report, I discovered what caused the issue: it is item ‘Probability’ and ‘Description’, both under item Probability. When I remove that Item, my report runs without problems. But I do not know how I can resolve this issue? Help is highly appreciated because I want to display the item Probability in my report. Kind regards,Simon  

4
B
Sidekick (Customer)
2 years ago
D
Do Gooder (Customer)
DHPCALBRECHTDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR Reports - Required installation to open reports

Prior an individual was able to open a report without installing IFS Business Reporter.  Now if they open a BR Report it is blank.  Once BR is installed they are able to review the data, so not sure if there is a configuration that I can not seem to find that possibly changed.Thanks so much for your assistance. 

4
V
Hero (Employee)
2 years ago
Srikanth
Superhero (Partner)
SrikanthSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR Execution Server error

Hi,Version - Applications 10 Update 8We recently configured BRES by closely following IFS Documentation. The excel report is getting rendered but without any data. I see the following errors in the BRES log:I tried all workarounds incl. the one for COM Factory Class error but no luck so far.Any direction in this regard is very much appreciated.

4
Srikanth
Superhero (Partner)
2 years ago
Link
Superhero (Customer)
LinkSuperhero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Table name of users company and site

Hello,does anybody know the table or view name of the company and site?  Thank you

4
Link
Superhero (Customer)
2 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Issue

We have a few reports that have recently been crashing displaying OLE error.   After going through each Server Set Id.After recreating the Server Set within a new report to test it.   I found that if I had 12 or less Measure Item columns no error was received and data was output.  Out of the 19 DIM_REPORTING_ENTITY.CODE columns that we had it doesn’t matter which 12 DIM_REPORTING_ENTITY.CODE items used, so long as only 12 columns were used then no error, if 13 or more then report crashes with OLE error. Has anybody come across this, if so, what is the cause? Thanking you.

4
N
Hero
3 years ago
U
Do Gooder
USLA
asked in Insights (Business Reporter and Analysis Models, EOI)

Filter criteria in BR generate different format

Filter criteria of BR generated different code for different users in same organization. So, it is difficult to share the report among the organization. Is this known bug, limitation or are we use it with wrong settings? Could some one help.Ex User A: In operation request comma separated list  User B:  In operation request semicolon separated list  

4
V
Hero (Employee)
2 years ago
L
Do Gooder
LOLDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Database import into Business Reporter APP10

HelloI am new to IFS and the Business Reporter Application. I have not been able to import data from our Oracle Database (SQL), using the usual ‘Get Data’ option that is available in Business Reporter.  The connection timed out while attempting to consume the pre-login handshake acknowledgement. The server I am trying to connect to , works fine and is available when other people try to access it, so the issue is only between Business Reporter and the database.I have checked the following and can confirm that everything is correctly set up and works correctly:Username and PasswordServer details and portal numberMy access permissions Has anyone encountered this before and is there an easy way to resolve this issue?  

4
L
Do Gooder
2 years ago
Link
Superhero (Customer)
LinkSuperhero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Manage lobby permssions

Hi everybody,Is it possible in IFS Apps9 to manage the grants like quick reports?Is there something like this screen? Thank you and kind regards.

4
Link
Superhero (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

4
D
Do Gooder (Customer)
1 year ago
SMANUEL
Sidekick (Partner)
SMANUELSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS BR Upgrade Utility is not installed

After we installed the new version of BR 5.0.19.0 ,one particular user gets the error “IFS BR Upgrade Utility is not installed” while loading any report..This doesn’t stop the report from loading though..IFS BR Upgrade Utility is in fact installed and we upgraded the reports using that ..Tried uninstalling and reinstalling several times,however no luck..Appreciate any info on this ...

4
SMANUEL
Sidekick (Partner)
2 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Reporter Execution Server

BR reports that have worked previously are erroring stating an error in design.  Having been advised that no changes have been made to the reports.  It was decided to restarted the BR Execution Server as NO BR reports have been processed since the 3rd June.   On clicking Stop the service does not stop and the following error appeared in the Log: An error occurred while trying to stop BR Execution Server.  Reported error is.  The service cannot accept control messages at this time.   How can I stop and restart the service?   The log files appear to go back to the 06/06/2021 and there are a few reports flagged as errored. Any prompts much appreciated.

4
R
Superhero (Partner)
2 years ago
hhy38
Hero (Customer)
hhy38Hero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

About Hiding SHOW SQL option from Quick Reports

We want to hide SHOW SQL option from quick report. We checked debug console and couldn't find presentation object of SHOW SQL option. How can we find it? 

4
hhy38
Hero (Customer)
3 years ago
C
Sidekick (Customer)
CKemmererWNASidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Scheduling Reports in Apps 08

Does anyone know if there is a program to schedule quick reports in IFS Apps 08?We tried a product that didn’t work well enough for what we needed. Thank you for your help!

4
ROVECH
Sidekick (Partner)
2 years ago
ZTC ZTC JGOTA
Hero (Customer)
ZTC ZTC JGOTAHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

How could I connect IFS to a SSRS report?

I have a SSRS report that I created. However, I do not know how could I connect the report to IFS? any set up in IFS ? I am currently using IFS 9 

4
Nadeesh Herath
Hero (Employee)
3 years ago
M
Do Gooder (Partner)
manjareedDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Export Selected QDIM Draft(s) not visible

Hi All,Do you know why I do not see the  Export QIS Draft(s) or Export QDIM Draft(s) options in IFS Apps10? Is this something related to user permissions?Can you please send your expert solutions? Thank you!

4
N
Hero (Employee)
2 years ago
T
Hero (Customer)
TosohLBlumHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

api for exchange rate

I am trying to create a MTD sales summary for a Lobby.  We have two companies.  One uses USD and the other uses Korean KRW.  We have currency rates in the system for the conversion of USD to KRW.  Is there an api to get the currently active exchange rate?

4
jaryskorys
Sidekick (Customer)
1 year ago
B
Sidekick (Customer)
BZNSIMONSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - how to fetch only data from Purchase Orders with status not planned?

Hi, I have an issue with Business Reporter and data. I created a report which shows the Purchase Order Lines per week. But I only want to show the data from Purchase Orders with status not Planned or Cancelled. I tried to show only the data from Purchase Orders which were autorized, but I was not able to do so because that data is not present in the Information Source. Is there any way to do this?The Information Source which I use is ‘Purchase Order Lines’. We are on APPS10 update 7.  Kind regards,Simon

4
B
Sidekick (Customer)
3 years ago
R
Hero (Customer)
ronhuHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR - Aging Report

almighty community, i am trying to build an inventory aging report using IFS Business Reporter. i am trying to use Receipt Date this column in Inventory Part in Stock window as a calculation base.  but i cannot find this field any where in below 3 data sources.Inventory Transaction History Inventory TurnOver Total Inventory Valuekindly advise. Thank you.

4
R
Hero (Customer)
2 years ago
SMANUEL
Sidekick (Partner)
SMANUELSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS BR issue with Office 365

Upon login it throws the following error (Office 365)“This Add-in is installed for all users on this computer and can only be connected or disconnected by an administrator” The addin IFS Applications don’t show up in excel Can you help please ? Thanks Shibu

4
N
Hero
2 years ago
A
Sidekick (Customer)
AnnaSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Supplier Expiration Date

My company is wanting to set suppliers inactive and we know how to set the expiration date on the Purchase Tab > Misc Supplier Info sub-tab but the definition of the field says “The date after which details of the supplier are not to be retained. The expiration date only controls the creation of new transactions in the system for the supplier”. The first bit is what’s throwing us through a loop. Does this mean that IFS will purge the historical records of the supplier (e.g. purchase orders, invoices, etc.)?

4
PRODQ
Hero (Customer)
3 years ago
Link
Superhero (Customer)
LinkSuperhero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Join tables in custom fields

Hi all,is it possible to use join operators while creating a custom field?I want to join two views. Thank you

4
Link
Superhero (Customer)
2 years ago
F
Do Gooder (Customer)
fyz29
asked in Insights (Business Reporter and Analysis Models, EOI)

Attachment Window Permission Settings

Hello everyone, How can I give permission for this window?  I’m using IFS9 

4
F
Do Gooder (Customer)
3 years ago
L
Do Gooder (Customer)
LinksGrecianDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Report Crashes Excel, ".net framework" error

This regards the IFS Business Reporter add-in for Excel, specifically Excel in Office 2016, 64-bit. There is one specific BR report we run which I’m having these difficulties with, doesn’t seem to occur with any other report and, strangely enough, running this same report works when done on different computers. The error we’re having occurs when trying to “Run Report” once IFS is loaded. We pick the standard parameter values, press OK, then in the Report Execution Progress window, it seems to go through everything (goes through steps 1 - 3 , fetches data) then it crashes Excel, Excel restarts, and it opens to a blank worksheet. I’ve checked the event logs and found the following pop-up at about the same time it crashes, so this should correlate: Event Log Error #1Event Log Error #2I’ve tried many things, like running .net repairs and running as admin. I’ve officially run out of ideas, so I’ve come here, hoping I can be pointed in the right direction if not have the problem solved entir

4
L
Do Gooder (Customer)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings