Insights (Business Reporter and Analysis Models, EOI)
This will include the questions related to Business Reporter and Analysis Models, and Enterprise Operational Intelligence.
- 371 Topics
- 1,096 Replies
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
I wrote an SQL query using the SQL Query Tool in IFS App 9. But when I try to save the query as a Quick Report it states: SQL expression is wrong (SQL-Ausdruck ist falsch).The query runs fine in the IFS Query Tool and unfortunately the error message does not specify why the SQL expression is wrong. Does somebody know what is wrong with my query?
I’ve created a Dimension in IFS Apps 10. I’ve then used Custom Dimension Connections to connect the Dimension to the Appropriate Information Source. I can see the Dimension in IFS Business Reporter and add it to my report. When I run the report I get the following error. If I remove the field and re-run the report it runs fine. How do I find that specific item and set the appropriate permissions to it?
Hi, Does anyone know if it is possible to add more parents values in Business reporter to Enter Parameter Values. As you can see in my example now. If I want to choose department value, I need first choose parent value company. Based on choose parent value (Company) I get data for departments, but I would like to add one more parent parameter. But I am not confident how to do it.
I’m getting following error when try to run ModuleRep.rpt in new cloud installation.Cannot connect to the Crystal Web Service through http://XXXXXXX:80/IFSCRWebSetup/Ifs_ReportService.asmx. Please Contact your System Administrator.Web service call not received to IFSCRWebSetup logfiles even though Crystal web service is installed and able to test with blank.rpt and db.rpt.Thanks,Lakmal
Hi,According my understanding, as the IAL views, the Access views are configured (created on demand by an end user) and belong the IFSINFO schema.For the IFS managed-cloud hosted customers, that offer the opportunity to use them via a direct access to the database allowed only to IFSINFO schema. But something remains not clear for me.In the technical documentation for IFS CLOUD (https://docs.ifs.com/techdocs/21r2/045_administration_aurena/255_br_and_a/050_integrations/080_external_access/010_access_views/) it is mentioned: "Access Views are used as the source for loading the Tabular Models specific data layer in SQL Server." "When the Access Views have been created, the Tabular Models framework can be setup, necessary model objects can be deployed to the SQL Server database and then a data load can be performed where the Access Views are used as sources when transferring data from IFS Cloud database to the SQL Server database.".I assume that this SQL Server is optional, not provided wi
Hi All, Can anyone please show an example of using NVL2 function parameter in a BR report? I tried to use NVL but could not get what I wanted. And trying to use NVL2 function parameter, but not sure what should I enter for the first argument (ValueIfNull). please see the image.&CodeB is a standard parameter for DIM_CODE_B.CODEThe requirement is to get all CodeB values including NULL when the &CodeB leaves blank and the selected CodeB values when &CodeB has a value.Example:when &CodeB = say '45' , the report will only show the records with code_b = 45when &CodeB leaves blank (NULL) then the report will show the records where the code_b of any value plus the code_b IS NULL Thank you!
How can I add permissions for a user to can connects to see data in views by ‘SQL Developer’ tool (directly from the database Oracle) ?Currently, the user can see tables, but views can't - by SQL Developer. if I add IFSAPP perspective , then he connects but can’t see the data from view.-off course this view have the data : here is an example that user has connect to the table: The issuse related with IFS 10.
Hi , I have a requirement where the lobby must show the count when the reminder is due (from purchase order screen )and filter applied in reminder due as ‘ yes ‘ and on clicking the count it must navigate to purchase order confirmation reminders screen where it must show the data where the reminder due is yes . but for me it is showing the count for all the data in the page without recognizing the filter . if I add filter as reminder due is yes inside the navigation , it is not working properly . PURCHASE_ORDER_LINE_ALL - View used in datasource PURCHASE_ORDER_API.Get_Contract(order_no)= ContractAND Purchase_Order_Line_Api.Get_Ord_Conf_Reminder(order_no , line_no , release_no) = 'Print Order Reminder' - this is the SQL condition I have given page/PurchaseOrderConfirmationReminders/List - This is the navigation I have given in element designer for now . if I try adding reminder due = yes inside this navigation it is not working Now if I click on this count . it is taking me to the P
Hi All, When I preview a SQL Quick Report in EE, it correctly shows titles in mixed case. However when I preview the same report in Aurena, it only shows first word in mixed case and others in lower case. If you have any prefix like ‘%’ it then even shows first word in lower case.Does anyone know a solution/workaround for this? EE Aurena
Hello TeamAfter configuring the watermark in the one of the Order report, i am not able to get the watermark image in my generated PDF file. I already copied the .jpg file in Application server’s folder still not working. Can anyone help on this topic.RegardsImran Khan
Hi there!We are running IFS APPS10 in managed cloud and I want to establish the data pipeline to our data warehouse. I want to use the Information Sources for this purpose. While everything that comes with IFS is fine so far I am missing some information that are standard fields (like “Coordinator” in customer order). I have gotten some information on how to add custom attributes to information sources but not how to add additional standard fields to a pre-build information source. Has anyone encountered the same challenge and overcome it? I am thankful for any advice or explanation on how to achieve this. If you need more information please let me know. Thank you and regards,Sören
Morning,We are trying to create a new lobby, but we it come time to create the datasouce (using datasource designer), we are getting always the error “UNABLE TO FIND xxxxx View” (where xxxxx is the name of the view). I already change the grants in all ways possible, and I don’t thing the problem is it. Did anyone have the same problem and managed to fix? Thanks, Gianni
Hi,Is there a trick to dynamically change scheduled quick report file names, for example to include the date of the run YYYYMMDD_HHMM_MyQuery.xls?Some time ago there was a discussion on dynamic parameters for scheduled quick reports, but it does not cover file naming.
Background: Our users would like “Keyword Search's” enabled for Customers window, Quotes window, etc.…Problem: Each Keyword Search must have enabled “Search Domain” which contains three jobs: Synchronized, Optimized, and Rebuilt. The last job, Rebuilt, is failing. The Error Text is below (I’ve removed the App User ID from Error Text, as seen in blue highlight):ORA-29874: warning in the execution of ODCIINDEXALTER routineORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2025ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 508ORA-29960: line 1, DRG-10595: ALTER INDEX CUSTOMER_TIX failedDRG-50857: oracle error in drepopenORA-04063: package body "CTXSYS.DRVDML" has errorsORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRVDML"ORA-06512: at line 1ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 497ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_SYS", line 778ORA-06512: at line 1ORA-06512: at "SYS.DBMS_SQL", line 1721ORA-06512: at "APPOWNERNA
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.