Insights (Business Reporter and Analysis Models, EOI)

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

  • 559 Topics
  • 1,581 Replies

559 Topics

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

FACT_ACTIVITY_CALCULATION_BI Error

Hi,We have encountered an error with the view FACT_ACTIVITY_CALCULATION_BI which I believe is part of the Analysis Models.The error is:ORA-00904: "ACTIVITY_CLASS_SEQ": invalid identifierHas anyone else experienced this?It seems that it is because the view thinks that "ACTIVITY_CLASS_SEQ" is a column in FACT_ACTIVITY_CALCULATION_OL but that view does contain that column.This is causing failures for us when we are trying to load the data into the SQL database.Any help would be appreciated. Thanks,Mark Mruss  

7
M
Sidekick (Customer)
2 months ago
T
Do Gooder (Customer)
tgriffinDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Crystal Reports Shop_Order.Operation_No report layout

Hi everyone, Having some issues with Crystal that I can’t seem to wrap my head around. I’m trying to pull through the list of operations on a Shop_Order as they appear within the view, however Crystal is splitting each onto a new page. No ‘keep together’ options are working to resolve this either… Am I missing something? I’ve attached a screenshot of what result I’m getting, VS what I’m TRYING to get to.Appreciate any insights!   

0
T
Do Gooder (Customer)
3 months ago
I
Do Gooder (Partner)
InisrinipDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Rename Report Attachment in Email

Hi,We have a report rule setup for the report CUST_STMT_ACCT_REP which sends an email for users. we have renamed the attachment as below to take the customer no.Environment = Apps9 But the attachment name is not getting the customer no and we receive attachment name as below. Are we missing anything here? Any help would be appreciated.Thanks!

1
Thirunavukkarasu Kapilan
Hero (Partner)
3 months ago
hrdilshan
Sidekick (Employee)
hrdilshanSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is there any way to kep the Reports stay in the Reprot archive for 3-5 days.

Is there any way to kep the Reports stay in the Reprot archive for 3-5 days

4
hrdilshan
Sidekick (Employee)
3 months ago
A
Sidekick (Employee)
Alex_MeeSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Escalation Handler

Hi, Has anyone ever set up an Escalation Handling rule in IFS? My team has tried to set up an Escalation configuration that would dispatch a “Case” based on criteria but we can’t seem to get it to trigger.  Any help would be greatly appreciated.Note: We really have yet to see a single Escalation Trigger work in action. A simple example of an Escalation Handling trigger in action may be enough to get us to the finish line.Thank you,Alex

0
A
Sidekick (Employee)
3 months ago
K
Do Gooder
kpiorunDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

"Order Report" greyed in Operational Reporting / Reports

In IFS10 on ifspp account one of reports in Operational Reporting is not available (C_PAY_GRIDLOCKS_REP). It has greyed submenu options: Order report, Show Archived Reports, Schedule Report, View Schedules. Other reports are available for print. When I try to add it to Report Schedule I got message: Report “C_PAY_GRIDLOCKS_REP” is not available for scheduling for current User (IFSAPP). In solution Manager / Operational Reporting / Report Definitions “Domain” and “Category” boxes are empty.Where can I unblock this report?

4
T
Hero (Partner)
3 months ago
A
Do Gooder (Customer)
AHOSZEBESTADo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - 23R1 Update 7

Hi everyone, I’m a new user on IFS cloud and I can’t connect on Business Reporter. On my test environment everything is OK however on the production environment it’s impossible. I have this message “Oops! Something went wrong - Invalid parameter : redirect_uri”. Do you have an idea in order to help me. 

2
Marcel.Ausan
Superhero (Partner)
4 months ago
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
Sachitha
Sidekick (Employee)
SachithaSidekick (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Excel Add-In don’t work on Jump server

When logged into the Windows 2019 Jump server with a user with administrator rights,  encountered an issue while attempting to initiate the IFS Excel Add-in.Upon starting Microsoft Excel and clicking on the IFS Excel Add-in icon, the Add-in launches successfully.However, when attempting to log in, encountered the following error:  Web browsers are up-to-date and not working for both edge and chrome,versions installed on this jump server,Also installed WebView2, Would appreciate your insights on what could be the root cause of this issue

5
E
Sidekick (Partner)
2 months ago
C
Do Gooder (Partner)
cdczdenehDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Consume Information Source/Access View via REST API

There is any option how to consume Information Source/Access View via REST API?I know that Information Source can be used in IFS Business Reporter and Access View I can read from database via IFSINFO user.But there is any other option? I mean eg. wrap Access View to Projection Configuration? I tried it but Access View cannot be used in Projection Configuration.Is any chance how to publish Information Source/Access View via REST API only by tailoring, without programming standard customization?Thanks. BRZdenek

3
W
Hero (Employee)
7 days ago
I
Do Gooder (Partner)
IniVismiMDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter-How to add a chart

Hi,Can someone advise me on how to add a chart for a table (Column/Bar/Pie chart) in business reporter.Thank you.

1
S
Hero (Employee)
4 months ago
baris.halici
Hero (Customer)
baris.haliciHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Fillable Order Report

Can we create an order report with fillable fields like the attached PDF document using IFS Report Designer? 

2
baris.halici
Hero (Customer)
4 months ago
A
Do Gooder (Customer)
Alex IvkovicDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Scheduled SQL report formatting

When we schedule a Sql report it comes through with a lot of unnecessary formatting that makes the resulting spreadsheet impossible to use.  All of our financial number fields have a carriage return and spacing. The reports export fine within IFS. Is there a place to tell  the system to send scheduled quick reports as data only?  This was not the previous behavior in Apps10 We are 23R1 UPD7

0
A
Do Gooder (Customer)
5 months ago
A
Do Gooder (Customer)
al-vDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Is it possible to alter a standard report without Developer Studio?

[I’m very new to IFS, so apologies in advance for incorrect terminology / an obvious question / etc.] My company are moving to IFS Cloud, and want to customise some of the standard report templates. From the docs and this post, it looks like the process for this is:Install Developer Studio, and link it our IFS instance via IFS Lifecycle Experience, Azure VPN etc. Use Developer Studio to download the .rdf and .xsd files for the report we want to customise. Install Report Designer and edit the report template, creating a new .rdl file. Upload the new .rdl file to IFS Cloud, and link it to the relevant processes.Is there another way to do this? E.g. is it possible to download the .rdf and .xsd files directly from IFS Cloud, and edit in Report Designer; or better still, clone an existing report template from within IFS Cloud and edit that directly? [And if not, is there anywhere I can vote for that functionality?!]

2
dsj
Superhero (Partner)
5 months ago
SandT
Hero (Partner)
SandTHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Context Substitution Variables with QIS in BR reports

Hi All, I’m trying to create a Business reporter report by using a quick information source that fetches values from an IAL. And I want to take the user details who ordered the report to the report designer. But when I trying to take it using a context substitution variable it gives the below error. BR client version is 5.0.23 of Apps10.  If anyone of you know how to use context substitution variables with quick information sources please let me know.  

1
W
Do Gooder (Customer)
28 days ago
C
Sidekick (Customer)
christianrothSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Anti-join in query designer/datasource designer

I am trying to create a data source in datasource designer based on a query that I am designing in query designer. The end result should be a list of all Work Orders with a Work Leader that is missing a specific competence.In Query designer, I am able to retrieve a list of ongoing Work Orders with Work Leaders and I am also able to retrieve a list of competence per Work Leader but I fail to remove the Work Orders for those with a Work Leader that has the specific competence.The filter in Query Designer seems to be applied as a final step which makes it hard to just get a list of the specific competence at hand, and eliminates the possibility to use left outer join and search for null values.Is there anyone that knows a good way to solve this challenge?

0
C
Sidekick (Customer)
6 months ago
H
Do Gooder (Partner)
himasha.abeywickramaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Power BI - Quick Reports

Hello,Is it possible to setup a Power BI report to run as a quick report in IFS Cloud?

0
H
Do Gooder (Partner)
6 months ago
H
Do Gooder (Partner)
himasha.abeywickramaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Analysis Models - Issue in setting up Tabular Models

Hello,I’m trying to set up tabular models IFS_INCIDENT_ANALYSIS and IFS_SALARY_REVIEW_ANALYSIS and it seems it’s missing Fact IDs referenced by above Tabular Models. It gives below error when trying to deploy tables and views to SQL Server, This environment does have some inactive components. Could you please explain the reason behind this behavior? what are the expected components that need to be active?

2
H
Do Gooder (Partner)
6 months ago
Marcel.Ausan
Superhero (Partner)
Marcel.AusanSuperhero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Schedule Business Reporter report - application message failed

IFS Cloud 23R1 SU4I’ve tried scheduling a Business Reporter report with the scheduling functionality introduced in 22R2.I’ve noticed the following:3 application messages are created for below settings the first 2 app messages I understand what they are and I get the email for these notifications The 3rd application message fails with NO ROUTING RULE FOUND. Also the input message only refers to data from report Archive.Does anyone have any idea how is this supposed to work? I don’t wanna have failed application messages. I could create a Routing Rule to catch this message and don’t do anything with it, but I’d like to understand what’s the purpose of the 3rd application message. 

1
Marcel.Ausan
Superhero (Partner)
6 months ago
Chamaka Wimalarathne
Hero (Partner)
Chamaka WimalarathneHero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Can we sort the devtool network tab by Time

For performance issues it is better if we can sort the columns by time . but how can we do it in the Dev Tool ?

0
Chamaka Wimalarathne
Hero (Partner)
6 months ago
H
Do Gooder (Partner)
himasha.abeywickramaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Analysis Models - Data Load Run Error

Hello,Below error is received when running a data load run,DataLoadScriptORAToSS - Copy Data from Oracle to SQL Server - 2 - ERROR: ORA-28000: The account is lockedAny idea why?

2
H
Do Gooder (Partner)
6 months ago
N
Hero (Customer)
NMALKIHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Macro with Business Reporter

Hi ,Can Macro be used in Business Report. looks like it is not saved when I save the report.I need to hide a column based on it’s value. Thanks 

2
N
Hero (Customer)
6 months ago
S
Do Gooder
SKA123Do Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick report default values in parameters

Hello community,I need to set a default value in quick report parameter.Here is my query in quick report:                            “  select *                               from customer_order                               where order_no = '12345'                                   and customer_no like '&customer_order.customer_no' “Result of “select *  from customer_order  where order_no = '12345'  “ in SQL :When executing on ifs, I got the list of all customers, it doesn’t take the filter into consideration :  Is there a solution for this please?Thanks in advance!

1
ashen_malaka_ranasinghe
Hero (Employee)
6 months ago
W
Do Gooder (Customer)
WellactuallyjustBennyDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Custom attribute for fact from &AO.[...]API.Decode(&AO.[...]API.[...](Parameters)

A beautiful good afternoon, I am currently trying to add a column from the receipt_Info view that seems to be somewhat customized. Usually I would use the “SQL Column” from the “System Info” Panel.But this one is not a regular term like “STATE” that can be used there but instead “&AO.[...]API.Decode(&AO.[...]API.[...](a list of parameters from the view)”.Can I integrate that column somehow into the information source and if so how?Best regards,Benny (Edit: typo)

1
SandT
Hero (Partner)
6 months ago
T
Sidekick (Partner)
TopDeepaWSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Import Information Source IFS Apps 10

Hi,There is an option already to export information source as .ins file. But I couldn’t find any option to import that file into same or another environment. I’m very grateful if anyone have idea for that. Thank you.  

8
Link
Superhero (Customer)
5 months ago

Badges

  • 1st Reply
    uaksoyhas earned the badge 1st Reply
  • 1st Reply
    Jon1981has earned the badge 1st Reply
  • 25th Reply
    Chethanahas earned the badge 25th Reply
  • 1st Reply
    ti01brhas earned the badge 1st Reply
  • 1st Topic
    shalikakkhas earned the badge 1st Topic
Show all badges
Terms & ConditionsCookie settings