Insights (Business Reporter and Analysis Models, EOI)

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

  • 555 Topics
  • 1,565 Replies

555 Topics

M
Sidekick (Customer)
MWitczakSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

SSRS Error

Hi all.  I’m new to using SSRS for Operational Reports.   In trying to develop a new report, while trying to preview the report in Visual Studio, I receive the error “Cannot set the command text for dataset ‘dsQuoteFromContract’”   Has anyone else received this error?  What did you do to correct it?  Thank you in advance.

1
D
Sidekick (Customer)
2 years ago
C
Sidekick (Partner)
CapAvinaKSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Filter reports on Project Invoice screen

Is it possible to filter Reports on Project Invoice screen?Suppose I have 12 reports for project invoice screen and I want that for a given company it should only show me few reports that are related to that company. Any suggestions would be appreciated. !! 

1
Lauri
Sidekick (Customer)
3 years ago
M
Do Gooder (Customer)
MichaelKowalukDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Route to connect enabling OutputFileName

Hello,How can I enable OutputFileName and OutputType in Action Properties for Route to Connect in Report rule? No matter how hard I try I can’t seem to find a solution. My action properties looks like:And I need this section:Thanks for your help!

1
paul harland
Superhero (Employee)
3 years ago
E
Sidekick
EvrKristNSidekick
asked in Insights (Business Reporter and Analysis Models, EOI)

Voucher row number vs Invoice Item

Has anyone attempted to join the gen_led_voucher_row to the actual invoice_items where the Sales Parts reside ? The requirement is to be able to view which GL row has been created by which invoice item row. I can’t find a direct link so it seems we have to go via inv_accounting_row by invoice_id and then to find the rows in invoice_item but then we fail to get a 1-to-1 

1
S
Superhero (Customer)
3 years ago
K
Do Gooder (Customer)
KPalmieriDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR: Copy Design Sheet to New File

Is there a way to copy an existing Business Reporter design and copy design sheet into another existing BR excel spreadsheet (two separate files)?

1
Dilmi Gunasiri
Hero (Employee)
2 years ago
A
Do Gooder (Customer)
astarkDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Zoom In option in a Business Report on a custom IAL information source

I am trying to right a business reporter report using a custom IAL information source.  I want to be able to zoom in on the data driving the summary numbers in the report but it is greyed out in the design area for the measured item.  Does anyone know if a zoom in can be performed on a custom IAL information source?  

1
N
Hero (Employee)
3 years ago
A
Do Gooder (Partner)
AIDA LOTFIDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

EOI

Hi,  If IFS will continue to support on IFS EOI? kind Regards,Aida.

1
O
Hero (Employee)
2 years ago
ZTC ZTC JGOTA
Hero (Customer)
ZTC ZTC JGOTAHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is Crystal Report 2016 supported by IFS 9? Where Could I see the list of Crystal Reports versions supported by IFS?

I am looking to upgrade to Crystal Report version 2016, I read the Crystal Report version 2020 is not supported 100% by IFS 9. I am currently using IFS 9

1
Randini Jayasundara
Superhero (Employee)
2 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Data Mart Refresh Categories

Trying to refresh a Data Mart Source and receiving the following error: ORA-20110: Error while refreshing Data Mart Source (CONSOL_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expired    How do I debug/resolve this issue?

1
Kalhari Dissanayake
Hero (Customer)
3 years ago
P
Do Gooder (Partner)
ProMagnusDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Developing Qfact tables for IFS Business reports

Hi! Please provide material for developing Qfact tables, which are used in IFS BR.

1
paul harland
Superhero (Employee)
3 years ago
P
Do Gooder (Partner)
PTI049Do Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Order Report

Hi, Can anyone help me know how an Order Report is created in IFS and how does it work? Thanks in advance

1
dhlelk
Superhero
3 years ago
D
Do Gooder
dnyandeDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Order confirmation print

Hi, I was wondering is someone could guide me in the right direction. We’re looking to set a routine in IFS  that automatically prints order confirmation when a customer order is released. Could anyone please guide me on how to go about setting this up?  Thank you 

1
Mohamed Infaz
Hero (Employee)
3 years ago
D
Do Gooder (Customer)
DAVIDODo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

HOW To Create a sub total for Project Cost on All Activity in Project

I äm trying to create a new lobby for Project Hour and Cost Analysis hence I have created the below sql query but I am finding it difficult to have a sub-total for every group of the same activityI wrote the following SQL query  select distincta.activity_description,a.resource_id as resource_id,b.resource_group_desc,a.qty_used as qty_used,a.qty_planned as qty_planned,a.project_cost,a.percent_usedfrom IFSAPP.activity_resource_proj a JOIN IFSAPP.activity_resource_proj_sum bON a.resource_id = b.resource_idAND a.project_id = '&Project_ID'ORDER BY activity_description Below is what I am gettting:I need a sub_total for Activity named 'DETAILED DESIGN’ as well as sub_total for '’ÍNSTALLATION SAFETY STUDIES'’  

1
EntNadeeL
Hero (Partner)
3 years ago
hapain
Do Gooder (Partner)
hapain
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Analytics - Measure item - min or max values

When I have a measure like “Price”, i don’t want this to sum up when in a BA or BR report, the summary happens based on repeater fields. If it was “Value” or “Qty” , Sum makes sense. Is this possible? Is there any way the Min or Max value (like in Oracle Grouping) can be displayed?

1
S
Do Gooder (Partner)
3 years ago
BEKEDE
Sidekick (Employee)
BEKEDESidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Client cannot be found - Deployment and application do not have matching security zones

thread needs to be closed.

1
Thiwanka Sandaruwan
Hero (Employee)
3 years ago
K
Do Gooder (Customer)
kyerdonDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter table relationships

I would like to create a report in Business Reporter that pulls together GL information plus customer order information but I can’t figure out how to create a relationship between these tables so that I can use them. How do you do this?

1
N
Hero
2 years ago
D
Do Gooder
dnyandeDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

How do I access IFS report designer

Hi am new to IFS and I was wondering if any one knew where to find the IFS report designer, when i search for it in the navigations pane nothing comes up

1
S
Superhero (Customer)
3 years ago
D
Do Gooder
dnyandeDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

lobbies behaviour

Hi guys is there a way of sending notifications to users when they have a task overdue on their lobby page

1
A
Superhero (Employee)
3 years ago
L
Sidekick (Partner)
LahiruDSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Information Source Dimension DIM_ACCOUNT_BI

Hi Community, Have you experience a situation where DIM_ACCOUNT_BI Access View in Business Reporter has multiple records for same Account and Company.  Thanks 

1
L
Sidekick (Partner)
3 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter report is not hitting the BR Execution Server

Does anybody know a reason why a Business Reporter report does not get processed by the BR Execution Server? Other BR reports do get processed by the BR Execution Server.The  BR report we have a problem with doesn’t even appear in the BR Execution Server logs? Any ideas.

1
Dilmi Gunasiri
Hero (Employee)
2 years ago
P
Do Gooder (Partner)
PrasadDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Standard Lobbies and Reports

Hi Fraternity,I would like to have the list of standard lobbies and reports available in IFS v10-Aurena.Kindly advise on source of information available for the same. Regards,Prasad

1
Yasas Kasthuriarachchi
Superhero (Employee)
3 years ago
A
Do Gooder (Customer)
a.georgeDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

ANALYZE (analyse) DEMAND DEVIATION

HiPlease could anyone possibly tell me what ‘ANALYZE DEMAND DEVIATION’ does and its impact Thank you

1
CallumW
Superhero (Partner)
3 years ago
U
Do Gooder (Customer)
Urvakshh.AvariDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is there a way I can generate customised reports in IFS ?

Is there a way I can  generate customised reports in IFS ?For Example , A quick Report is required to monitor all Cost Types. 

1
X
Superhero (Employee)
2 years ago
2
Do Gooder
2020
asked in Insights (Business Reporter and Analysis Models, EOI)

Crystal Reports as Operational report and row level security

Hi,I’m creating reports with Crystal Reports as operational reports on IFS Applications 10 Update 8 and I have question about whether row level security is applied or not when developing the report according to the guidelines. I would guess it is but the documentation is a bit ambiguous.I’m guessing that I don’t understand exactly what is referred to in the first text extraction below. I’m referring to this page: https://docs.ifs.com/techdocs/Foundation1/050_development/025_operational_reporting/200_cr_as_operationalreport/default.htmI’m making the confusing parts bold in the text below.In the ‘Design and Security aspects’, it is stated that:“The Crystal Reports executed this way always access the database using the same user as the Report formatter (i.e. no row based per user security is applied).“Further down in ‘Data integrity and row based security’ it is stated that:“As long as the Crystal Reports only accesses the report result table when querying data, the default IFS Applicatio

1
durette
Superhero (Customer)
3 years ago
K
Do Gooder (Customer)
KPalmieriDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - New "Information Sources"

Hello - BR comes with a standard list of “information sources”, how do I add additional sources from within IFS?My current specific example: I am looking to add the source “Inventory Parts Unit Cost” from the Warehouse Management-Financial Control path…Have few other needs so this would be very helpful!Thanks

1
paul harland
Superhero (Employee)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings