Insights (Business Reporter and Analysis Models, EOI)

607 Topics

TopDeepaWSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

I'm trying to install analysis model on IFS race environment but unable to test connection due to following error message. Anybody can help me to resolve this?

983

1 year ago

karllinderSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

User pictures from AD

Hi! Have anyone done a integration between Active Director and IFS10, where the user pictures are imported? We have user pictures in AD and would like to have the same in IFS10. /Karl

7458

1 year ago

Dee21292

asked in Insights (Business Reporter and Analysis Models, EOI)

Sorting issue in BR report

Soring on one specific column on an Business report is not working, seems excel is working fine but there is some issue in this BR report design on a specific column, Can able to sort other columns easily , may you please assist.

1010

1 year ago

DavMoDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

SQL join error, what am i missing

Hi All, i have a SQL query to join 2 simple datasets, i am receiving an error saying "PROD_STRUCT_ALTERNATE_CFV"."PART_NO": invalid identifierFailed executing statement (ORA-00904: "PROD_STRUCT_ALTERNATE_CFV"."PART_NO": invalid identifierrelates ot the ON part of the statement.If anyone can help i would appreciate it.the basic select query was working before i modified it to include the join from the other table.SQL is as belowSELECT objid,objkey,bom_type,alternative_no,contract,part_no,cf$_total_plastic_weight,cf$_total_regrind_weightweight_netFROM ((SELECT objid,objkey,bom_type,alternative_no,contract,part_no,cf$_total_plastic_weight,cf$_total_regrind_weightFROM prod_struct_alternate_cfv WHERE alternative_no ='*' AND bom_type ='Manufacturing' )LEFT JOIN (SELECT part_no, weight_net FROM part_catalog where part_no is not null)ON part_catalog.part_no_cfv = prod_struct_alternate_cfv.part_no )

5505

2 years ago

Chanodhi De SilvaDo Gooder (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))

Hi all,I am getting the following error while opening the Business Reporter. Any suggestions to resolve this issue? ************** Exception Text **************System.Runtime.InteropServices.COMException (0x80004004): Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT)) at Microsoft.Office.Core.COMAddIn.set_Connect(Boolean RetValue) at Ifs.Application.ExcelReporter.AddInManager.GetConnectionAddInObject() at Ifs.Application.ExcelReporter.AddInManager.SetConnectionAddInProperty(String name, Object[] values) at Ifs.Application.ExcelReporter.ReportLoaderOperations.PerformBasicValidationOnLoad() at Ifs.Application.ExcelReporter.ReportLoaderOperations.LoadReport(IUiCallback uiCallback) at Ifs.Application.ExcelReporter.MainWorkbook.ThisWorkbook_Startup(Object sender, EventArgs e) at Microsoft.Office.Tools.Excel.WorkbookImpl.OnStartup() at Ifs.Application.ExcelReporter.MainWorkbook.FinishInitialization() at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator

17182

2 years ago

danshelton416Do Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Individual Efficiencies / IFS10

Would like to find a way to track individual efficiencies: operations, lines received, lines picked, etc. Is there a way to do this using query builder or some other means of tracking efficiencies of employees?

281

2 years ago

RakeshChangeshpurSidekick (Partner)

posted in Insights (Business Reporter and Analysis Models, EOI)

IFS BR report samples

Hello guys, I am exploring the options on IFS BR reports, Can anyone share some sample reports or some documents here it will be helpful for me Thanks,Rakesh Changeshpur

1285

2 years ago

hrdilshanHero (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

Error - Auto Grating of Permissions to all Permissions sets when Publishing Quick Reports

We have noticed that Auto Grating of Permissions when Publishing Quick reports In our UAT and PROD environments.We this this is a security issue and it should be corrected ; as per the current setup when publishing Quick reports , it will modify FND permissions and adding quick reports to the Core Permissions sets and other all permissions sets in the system

772

2 years ago

AsadanSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Where can I find link to install Excel Add-in? App 9

Hello Community, We want to install exel add in for App 9 via link and wonder where we can find the link mentioned in below documentation. Please see marked in yellow in the attachment. Note: we have ATU licens. Thanks.

992

2 years ago

MANI0202Sidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

adding a custom field which auto populates

Hi, I want to create a custom field under “Work Task” which auto populates the id of the person which closes the ticket. Need guidance regarding this. Need to know If there is any field which is by-default given by IFS which we can use for the above purpose. ThanksMani Shankar

1142

2 years ago

JJäthingHero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Work Task WIP handling when error not identified at year end

We have situations where reported faults may need quite some investigations before the origin of the error is identified. In such cases we wish to be able to enter an intermediate pre-posting against the work tasks which will be updated once the true cause is identified.In the normal case this is not an issue, but at year end we will want these intermediate work task cost postings to be posted to the balance sheet. Is there any way we can do that to just selected work tasks or is there a clever way to do it? We do not want all our work task postings registered as WIP.@Thommy : Would you have any input on this?

965

2 years ago

JuniSihombingHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Is Field in Ad-Hoc Report translateable?

Hi community,can fields of Ad-Hoc report be translated? I created an ad-hoc report from a custom view. In metadata label-message-id is added for each field.I created message translation type Label and Report Label for the messages. Columns of ad-hoc report are still not translated. How to get the columns of ad-hoc report translated? Thanks in advance for your feedback. ~Juni

320

2 years ago

bytsophanHero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Filter in Business Reporter after the repeater

Hi Expertsi have created a Report of fix Assets object Transactions. Now i have objects (rows) where the total value of the obect at the starting periods are 0. That means the total of the object transactions equals 0 Is there a Solution or workarround how to filter these Rows from the report automatically? I tried to preset a filter in the design but it didnt work. The filter gets deleted as soon as you run the report I also tried to add a advanced filter on the repeater and also on the field

1815

2 years ago

HDZANUSHAKHDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

How can I know various tables in which my cloud data is stored

How can I know various tables in which my cloud data is stored? I created some sites, service requests, work tasks etc. & now I want quick reporting on them, so how can I know in which table that info is stored so that I can use SQL statement?

421

2 years ago

CD2022Do Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Issues - Creating information source's from IAL'S

Hi Everyone, I was wondering if anyone else has come across issues when creating custom information sources and dimensions. When ever i create one from an IAL i find the filters in business reports utility don’t seem to work and i end up filtering my fields in the IAL before converting it to info source. If anyone else has a solution or idea for me to try please feel free to let me know. ThanksCameron

3143

2 years ago

tariqDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

create new order report

who to create new order report.thanks.

670

2 years ago

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?

3484

2 years ago

JohnnyDo Gooder

asked in Insights (Business Reporter and Analysis Models, EOI)

how to disable PDF archive

this is my operational report setting, every time the crystal report will be invoked and generate PDF automatically. I’d like to archive only, but don’t like to trigger crystal PDF. how can I accomplish it? I know I can do it via “order report” with “archive only” check-box manually.

581

2 years ago

EmiliaUsaDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

List of transactions id in IFS

Hello community. It is a way to have a list of transactions IDs and their use ?thanks a lot,Emilia

7536

2 years ago

SEFLNDADADo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Double lines when entering a time report

Hi,When adding a time report we get double lines in Aurena.It looks correct in IEE for the same work order.When select 1 line in Aurena it automatically selects both of the lines.I have create an employee to several companies where this doesn’t happen, it’s only in one company we can see this issue.Someone that knows what the reason can be?Thanks!

460

2 years ago

gianni.nevesSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Cloud - IFS Analysis models

Hi guys, Need help to understand how show the menu Analysis models in IFS Cloud. I see BIBASE component installed, but the menu is not available. I already configured SQL Server and all requirements from here IFS Analysis Models - Installation Checklist - Technical Documentation For IFS Cloud, but when I arrive to SETUP ENVIRONMENT ASSISTANT, I cannot find this item. I tried PERMISSION SET, YAML file, reconfiguration of SQL Server, but nothing works. Did anybody have any idea? Thanks,Gianni

1080

2 years ago

zuhaibSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Report Error

When I run a quick report through IFSAPP it works fine, after that I run it on any user it shows the error. When I run Quick report on user ID that error is show

15512

2 years ago

mwilliamsDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-Value cannot be null.

1484

2 years ago

BeaParisBDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Sort data by measure item in business reporter

Hi all, I am having trouble sorting data by measure item in business reporter. Does anyone know if there is a BR functionality that enables you to do so? If not, any good work arounds? Any help would be great, thanks!

483

2 years ago

Martin GestingerDo Gooder (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

Missing LoV in Client for Business reporter

Hi, Please, can someone advise me how to add LoV while ordering Business Report in IFS Client. For one parameter there is no list of values and I don't know why. If I check the dimension for this parameter in Dimension Item Details I see this set up. Is it publishing Info window where I should set something to get LoV in Client. Anyone any Idea ? Thank you Martin Gestinger

2732

2 years ago

Page 11 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded