Insights (Business Reporter and Analysis Models, EOI)

554 Topics

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

The filter with IN clause

Hi BR experts,Could you please advise me on the following issue?When the customer orders the BR report, they get an empty report.But when I order the same report I get the report with data.To investigate the problem, I removed filters from the report one by one, until only the company filter remained. The filter looks like this: DIM_COMPANY.CODE IN &CompanyI defined it with a parameter Company with the default value: 8031,8111,8114,8115. The report appears empty, but when I change the filter to:DIM_COMPANY.CODE IN '8031','8111','8114','8115'with hardcoded values, the report shows data. Have you encountered such an issue? Do you know any solution or workaround on how to define a filter with a multi value parameter so that the report displays data?I would be grateful for any suggestions.Best regards,Adam

8 hours ago

CGMRUNALDo Gooder (Partner)

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

How to turn on Machine learning service in ifs cloud

How to enable turn on

3 days ago

Adam MazurczakHero (Employee)

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

Empty BR report

Hi BR experts,I'm preparing a report in Business Reporter, and I've encountered an issue. When the customer orders the report, they receive an empty one, but when I order the same report, I receive a report with data.I tried to recreate this issue, but I couldn't do it until I turned on the debugger.When I turned it on, I received an empty report.Have you ever encountered an issue like this?Do you have any suggestions how to solve it, I mean how to ensure that when the customer orders a report using their credentials, they receive a report with data.I would be grateful for your assistance.Best regards,Adam

7 days ago

mrsweeneyDo Gooder (Customer)

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

'You have to set up the environment before using the tabular models

Hello,I was wondering if anyone knows why 'You have to set up the environment before using the tabular models’ is displayed and required after tabular models have already been set up and data has been accessible?

8 days ago

sevoDo Gooder (Customer)

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

Business Reporter Output

Dear All, i have created below test report via BR,when i want to take an output, it shows below message, and then i click the “ok” button, then system do nothing. so, how can i take output in ifs10?

10 days ago

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.

16 days ago

JannetteCHero (Customer)

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

Quick report run error

I have created the following quick report, but get this error when I try to run it. select part_no, ifsapp.Inventory_Part_API.Get_Description(CONTRACT,PART_NO) part_description, Contract, Case When Contract like Nvl(Upper('&Site'),'%') Then 'Y' Else 'N'End Rqdfrom ifsapp.Inventory_Partwhere contract Not In ('CPH','CTM','VMS','CGP') --and part_no='WMPI10067'and Nvl(Substr(ifsapp.Inventory_Part_API.Get_Accounting_Group(contract,part_no),1,2),'Y') Not In ('IS','PH')), PartsInStock As (Select part_no, Sum( Case When contract like Nvl(Upper('&Site'),'%') and Substr(warehouse,1,4) like Nvl(Upper('&Warehouse'),'%') Then ipis.qty_onhand Else 0 End ) End_Qty, Sum( Case When contract like Nvl(Upper('&Site'),'%') and Substr(warehouse,1,4) like Nvl(Upper('&Warehouse'),'%') Then ipis.UNIT_COST * Nvl(ipis.QTY_ONHAND,0) Else 0 End ) End_ValueFrom ifsapp.Inventory_part_in_stock_uiv ipiswhere contract Not In ('CPH','CTM','VMS','CGP') and Nvl(Substr(ifsapp.Inventory_Part_API.Get_Ac

20 days ago

ArcElhadCSidekick (Partner)

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

Reports not available in Document footer

Hello Community I have seen that It's not uncommon some reports are missing in Document Footer.The idea has been raised to give the customers the ability to connect every report in the document footer screen in IFS. in the meantime, is there a way of configuring the footer of a report without having to customise the report with report designer or another tool? And i want also to know why for some reports the standard ifs logo continues to appear even though we did this configuration t stup multi company for all reports :Upload your images to the “Report Images” page in AurenaCopy the exact “Image Name” from the fieldPaste the Image Name into the “Document Logotype” on the company It works for all our reports except for a few like SHPMNT_CONSOLID_PICK_LIST_REP. Which always keeps the ifs logo in the report.Is this something that can be modified by changing parameters on Aurena or do you have to use tools like report designer and edit the report? Thank you in advance for your help

22 days ago

sachini01Do Gooder (Partner)

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

The report is not populated in Aurena

I have created a quick report (SQL statement) in APP10 and the report is successfully populated when trying to view using IEE.The report is seen in the ‘Order Report’ window but when I try to view the report, it is not populated and shows ‘No Data’. The issue remains the same even if I log in as IFSAPP to Aurena.Could someone please advice if any security grants should be done in order to see the records in Aurena please?

23 days ago

MDDTJAMUDo Gooder (Customer)

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

Business Reporter - Report being used by another process (Shared Directory)

When we save a business reporter generated file to a shared location it initially runs fine then users begin to get to see a message that looks like this: “The process cannot access the file:’Z:\Test Reports\business_reporter_example.xlsx’ bause it is being used by another process.” We have checked the file is not open and ensured the locations used are listed in the Trust center locations. Has anyone else encountered this issue and/or have fix?

23 days ago

thprlkARCDo Gooder (Partner)

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

Upgrade concerns for Business Reporter - APP10 to Cloud

Hey All,I have a concern raised from a customer with regards to upgrading Business Reporters from APPS10 to Cloud. What implication is there for any reports that have been developed for Apps10 Aurena as and when we decide to upgrade to IFS Cloud? Does BR still exist? Will the reports just continue to work? Or will they need to be adjusted, or worse redeveloped, to work with IFS Cloud?I know we could run the Business Reporter Upgrade Utility to validate the reports but are there anything additional which we need to consider on above concerns? Best Regards, Thushila

29 days ago

sevoDo Gooder (Customer)

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

using custom querries via ifs business reporter

Dear all,Can we use database querries in ifs business reporter?How can we use our custom queries in the Business Reporter using this tool? I ‘m currently seeking know-how regarding this matter.

1 month ago

NorahmfSidekick (Customer)

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

Crysatl report issue

Dears, I create a new crystal report, but when I try to order report show blank page:is there a missing step?

1 month ago

TIVMAGFRISidekick (Customer)

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

Incremental load outside Azure

We are running IFS Cloud 23R1 in a, by IFS, hosted setup with self hosted BI setup in our own Azure tenant. However, our main datalake resides in Snowflake and we’re therefore pushing data from Azure to Snowflake. Currently this is done with full dataloads each time, which is not a sustainable model.We have enabled incremental loads between IFS Cloud and our self hosted BI (Azure). We are now looking into what we can utilize to enable incremental loads between Azure and Snowflake, and noticed that mvt_created_dt was populated in Azure. However it seem to be updated with the time of the latest incremental load, for all records? My exceptation was that this would only occur for newly added/updated records.Does anyone have any suggestion how to implement a solid incremental load funcationality between Azure and another datalake?

1 month ago

AccManisCDo Gooder (Partner)

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

Incremental Load Issue

Hello,I have a requirement to make the data source - FACT_GL_TRANSACTION as incremental data load and I have modified that in Data Load Definitions -> Data Source ->FACT_GL_TRANSACTION - Incremental Load (condition got auto generated based on mvt_created_dt).Although my existing access view FACT_GL_TRANSACTION_BI, has the data access type set as online and it is created based on FACT_GL_TRANSACTION_OL. Hence, full load will be sent every time when the data load runs as the mvt_created_dt in FACT_GL_TRANSACTION_OL is sysdate.I don't see any option to modify access view - FACT_GL_TRANSACTION_BI to change access type as datamart. Can you please suggest me how this can be handledRegards,Manisha

1 month ago

AccManisCDo Gooder (Partner)

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

Error in Data Load Run - FACT_GL_TRANSACTION

Hello,We have a data source - FACT_GL_TRANSACTION which needs to be sent as incremental load to Azure. But the load goes into error while the data load runs. Any idea why ?

1 month ago

Takesha KaluarachchiSidekick (Employee)

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

Report rules with the action “Routing to Connect” to send the report PDF to any mail address, I cannot able to use “ResultKey” as an OutputFile Name

Steps to recreate the issueCreate a Report Rule for any report. I have checked this issue for the Order confirmation report (CUSTOMER_ORDER_CONF_REP) with an Action type of “Route to Connect”. And use “ResultKey” as an OutputFileName So, When I print the Order confirmation Report, I got an Email with the Output name combined with ReportID_ResultKey. Not only with “ResultKey”.But if I use only “ReportID”, then It send an email with only ReportID as an OutputFile Name. Expected resultExpected result would be to only get ResultKey as an OutputFileName in the attachment without ReportID combined.

1 month ago

LuciaMDo Gooder (Customer)

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

Error #VALOR in cells where name of field should be shown

HI,In some cases BR reports that have been working properly stops reconginzing field names and show #VALOR or #¿NAME? in each cell that includes an IFS field. The formula ribon however shows the field properly. That change happens after running the report and going back the Design mode. In some of those cases the BR still works and show data when I press Run report, but in other cases the report stops working. Do you now how to resolve this problem?

1 month ago

Imalka BandaraDo Gooder (Customer)

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

Error in IFS Business reporter - error while calling the projection BrClientAuthorizationHandler

I get below error when I open IFS Business Reporter. Any suggestion/ solution is highly appreciated.

1 month ago

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

1 month ago

CD2022Do Gooder (Partner)

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

Business Report - Is it possible to supress rows with 0's in the values

Hi All, I am just having a play with the GL Balance information source and wondered if I can supress rows with 0 balances I currently have the 3 elements below with a row repeater of account There seems to a few account that has a 0 balance. I was wondering if i could exclude that from showing in the report. I have tried setting row filters and cell filters.(Is not Null and not equal to 0 ) doesn’t seem to get rid of them. Is there something obvious I am missing here ? Any advice is appreciated ThanksCameron

1 month ago

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

2 months ago

Luiz RSidekick (Partner)

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

IAL - Create Quick Information Source for Business Reporter Slicer Option

Hello, I created a Quick Information Source based on an IAL, I could enable the Zoom-In, however I can’t create Workbook/Sheet Slicers based on my QIS/Custom IAL.Is there a place where I need to enable the option?Also, does anyone have documentation on this? I.e., Documentation on creating IAL/QIS for Business Reporter. I’m also trying to make the Drill-down option work (it is enabled but giving an error message).Thanks in advance

2 months ago

gumabsSuperhero (Partner)

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

Business Reporter 2 Information Source Issue

Hello BR experts,I have created a business reporter based on structure where I am trying to compare GL and IL Balances. Column HFM Balance is using source Internal Ledger Balance and Statutory Balance is using GL balance.When I defined a filter for Ledger ID on HFM Balance column, report gives me error shown on the screen shot.The only way to apply a filter is on cell level. But I am afraid it will reduce report generation time if I apply filter for each cell in the report.Basically my question is how to enter the filter that will bypass this error? ThanksFurkan

2 months ago

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

2 months ago

Page 1 / 23

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded