Insights (Business Reporter and Analysis Models, EOI)

Hi All, How can I get SQL code behind this order report. (Please find screenshot below)Thanks in advance.IFS apps 10. Best Regards,Hari

Can I hide a field in a header with a visible condition in the report designer?e.g. I want to hide discount in the header when the value is 0,00% Thank you in advance!

I am trying to build a quick report that will pull all of our rework operations that we label with an “R” in our operation description. I cannot get this report to match shopfloor_clockings. It does not pull all of the same shop orders and operations. I started trying to test the database tables individually, but I need a left join in order to filter the content in the operations_history down to the operations with the operation_description found in the shop_order_operations so that I can see that they are working. I get the error that you can see in the screenshot and cannot find a way around it.

We are trying to install the Bi solution. In the tech documentaion it is refered to a Main.cmd that you should request from and IFS Consultant.https://docs.ifs.com/techdocs/23r1/050_reporting/450_self_hosted_bi_int/010_create_azure_resources/#upload_odac_installation_files_to_the_blob_storageAnyone that know where to get the Main.cmd. We have tried a support ticket without any luck. Have now been waiting for 14 days….

Dear Community,I have a quick report (sql statement) the report retrieve many columns but the report is very slow take time to load data when user open it from order reportcan I do something for that ? 

It is needed to add dynamic images into the report for each part. The image is not store in the database or an an attachment, it needs to be fetched from an external image URL.

Is there any recommendation to select the SQL server version for IFS AM?. I needed to install IFS AM for APP10. Can we go with Standard edition without Enterprise?      

why multiple  same file is coming? what’s the logic behind that?  

Hi,We need to login to the business reporter using SSO with IFS Cloud. Can you let me know how to enable SSO for BR?

hi everybodyI try to one value rotate on report with rotate text function, but when I use that text dont wrapdo you have any solution for that?

Hi,I have seen announcements on that external data sources can be connected to Lobbies, since this is still new I have not found anyone who would have knowledge on how this is actually done. Is this for PowerBI lobby elements only or can it be used for all lobby elements? How do you set up an external data source for a lobby? Any advice is welcome.BR, Jukka

We are wondering if you can directly from running a quick report in IFS export it into PDF format instead of exporting it to Excel as per usual. The background is that the Swedish Maritime Administration wants to be able to issue quick reports to its auditors and then assure them that the data has not been manipulated. The customer is running Cloud 22R1. If it is not possible to do this, which is the best solution for PDF reports directly in the system, do only the resource-demanding report designer reports apply or is there another alternative?Use case the customer wants to build his own report where he/she himself chooses which data should be in the report and then he/she wants to run it in PDF format directly in the IFS system  

Hi Community,I have one problem. I have a report in BA (IFS9). The report is stored in IFS and is scheduled for automatic startup. Usually the report generates fine, but occasionally returns the error: "CreateExcelePortwithdsrd: EJB Exception: ORA-20105: WebServicesutil.utl_http_fault". Please, do you have any experience with such a problem? Or some idea, what can I check?

SSRS report is working when open from SSRS reporting server but when try to view it within IFS Cloud it’s blank.Followed cloud documentation and done followingConfigured SSRS parameters. IAM Client IFS_ssrsor_integration created as it was documented. Done SSRS data source setup,  it is connected successfully.Does anyone came across similar issue in IFS Cloud?

All in Apps9 is there a way to use more than one view when creating a data element for a lobby? I’ve used the SQL rather than query builder as it’s a custom view I need to use along with another standard view.

Hello, We have created several custom Quick Reports to our IFS Apps 10 UPD 12 instance. I can see them in Order Report on Aurena, however, I do not have any options to configure the report parameters prior to running. Do QRs created for IEE need to be recreated in Aurena, or can they be run and parameters specified?Thank you!

I am trying to create a simple Project Cost Report using the Project Activity Information Online Source as I done before.I keep getting a The Given Key was not present in the Dictionary. What key, which dictionalry but how would I fix it ? Probably user related as I get it in APP10  nd IFS Cloud 21R2  but user not smart enough to figure it out (ie me) 

We have a quick report that outputs different results when it is sent via a scheduled data base task compared to when it is run manually. These sums are done using simple “select sum() from table where X” and are listed in rows using union. As you can see in the table. Only sum 7 and sum 8 are inorrect when using the scheduled quick report. The others are correct. Any ideas why this might be happening? Manual output: sum1 1263584 sum2 8608567 sum3 4872151 sum4 55863 sum5 6525876 sum6 3413890 sum7 4532101 sum8 9021000 sum9 7553101  Scheduled Quick Report:sum1 1263584 sum2 8608567 sum3 4872151 sum4 55863 sum5 6525876 sum6 3413890 sum7 8428850,52 sum8 9021000 sum9 11449850,52  

The following error occurs while opening IFS BR (Office 365) 

Is there a way to see what permission’s or Privilege's are attached to a specific business role? 

Hi All, Is it possible to use the drill down function but point it at a dimension instead of the original info source ?  Current report - The report currently uses a custom Info source that has grouped data in the IAL so the drill down wont go further down if I point it to the info source.  I am wondering if its possible to point the drill down function to the Dim showing the same columns just without the grouping ? When I have tried to do this - I set up the custom dimension connections and it seems to wipe out my information source in my report as if there was a failure of the connections.  Any advise would be appreciated  ThanksCameron

I create a quick report from view created in database but when try to order report I faced this issue I need urgent help please.is there any missing step or something?

Hi, I am trying to create a Business Report in APP 10 using advanced criteria for a cell. It is not working as expected. Appreciate any support in solving this. Advanced Criteria:DIM_ACCOUNTING_PERIOD.ACCOUNTING_YEAR = 2022 AND(DIM_ACCOUNT.CODE IN '60900';'61900' OR ((DIM_CODE_G.CODE LIKE '10%' OR DIM_CODE_G.CODE IN '4000';'4100') ANDDIM_ACCOUNT.ACCOUNT_GROUP = 'G13' ANDDIM_ACCOUNT.CODE NOT  IN '60900';'61900';'60999';'61999'))Report Result is -915,006.71.Expected result (Querying through SQL) is as below. When you analyze the data set in business report it shows without the brackets. 

When we install IFS BR as ClickOnce or MSI, it did not provide the publisher. So we are facing security issues. How we get these information.    

We can see Order Report menu to run Operational Report in MWO is not visible.please let us know how we can run the operational report in MWO Service App