Hi @sevo ,Yes, It is possible.By creating IAL based quick information sources, You will be able to create BR reports.Create an IAL using your DB query. Draft a quick information source or quick dimension. Create information source.Please refer below documentation to get more details about quick information sources and IALs. IAL Object Developer (ifs.com) Overview (ifs.com) Quick Information Source Examples (ifs.com) If you need any further support or information please let me know.
Hi @Arifmd1705 , IFS analysis model is the solution to extract data and create data warehouse/multi dimensional models to analyse data by using it as the data source instead of directly fetching data from back end table/views .It consists of a framework that supports an ETL process, transferring data from IFS Applications to a Data Warehouse hosted in MS SQL Server.Please refer the below documentation to get more information about that solution.IFS Analysis ModelsI don’t have any idea on the accessibility of your target database when it comes to managed cloud mode application. If it is not possible to make the connectivity with target database to extract data please contact managed cloud team to get access. When it comes to IFS cloud solutions, there are suggested ways to get data from managed cloud environments.
Hi @washton ,Great. You too!Please do not hesitate to contact if you need further support.
Hi @washton , Got it, You have to add a data access details for the QDIM. Just copy and paste the same view name available under the online view.
Hi @washton , One more suggestion. If your ultimate goal is to generate an access view for just a custom dimension, You can develop a custom information source(QFACT) instead of QDIM. Then you can directly generate access views.
Hi @washton , You can use Custom dimension connection window to create the required connection between FACT and QDIM. for more detail check the the below documentationOverview - Custom Dimension Connections (ifs.com)
Hi @aruru, There is an inbuilt solution called IFS Analysis models as a BI solution in IFS Cloud.IFS Analysis Models consists of a framework that supports transferring data from IFS Cloud Information Sources to a Data Warehouse hosted in Microsoft SQL Server, and a set of Microsoft Tabular Models connecting to this Data Warehouse.By using that Data warehouse or Tabular Models, you will be able to create BI reports such as power BI reports and dashboards. Based on your requirement, you can retrieve data to the data warehouse which are not available in IFS standard models.
Hi @NECMIOH , Ok, You will be able to find the capabilities of every permission set that is related to the IFS business reporter by referring to that document.
Hi @NECMIOH, Please refer the below documentation to get a clear idea about IFS business reporter related permissions.Manage User Permissions - Technical Documentation For IFS Cloud
Hi @NMALKI, Please try the steps available in the following article instead of trying macros. https://www.causal.app/excel/hiding-columns-based-on-a-cell-value#:~:text=Hide%20the%20Columns-,In%20the%20%22Format%20Cells%22%20dialog%20box%2C%20go%20to%20the,formula%20evaluates%20to%20%22TRUE.%22 I have tried this as above screenshot and it worked for me when company value of cell D7 is 100.Note: Apply this rule in business reporter design mode and then run the report.
Hi @Viitati, If I got your question correctly, I have manged to run the flow successfully using the below design. I have used IFS projection task for those 3 task and the projection value(CustomerOrderHandling) and entity set(CustomerOrderSet) value are same for the last two tasks. It seems that you have defined a collection variable in your design. If there are multiple returns in you first task please make sure to handle them using sequence techniques.
Hi @WellactuallyjustBenny, If I get your question correctly, you are trying to take a custom attribute by using a function call. Please refer following documentations to get clear idea about that. To create a relationship for fact by using function call source typeSource Relations for Facts (ifs.com)To create a custom attribute by using the created relationshipCustom Attributes for Facts (ifs.com)
Hi @TopDeepaW, Sorry, just saw your comment. Were you able to fix the issue? or is it still available?
Hi @TopDeepaW , Please try following steps and the check the information source window.Open PL/SQL Developer File → Open → SQL Script Select the Exported “MetaData_GenledBIFactGlBalance.ins” file. (if it is invisible please choose file type as All Files”) Execute Commit
Hi @TopDeepaW , My suggestion is to get support from a developer who has access to the database and deploy the file in the database. Is it a standard information source? if so what is the reason that you want to import it on another environment?Please note that all the custom attributes and custom dimension connections can be exported and imported from IEE itself instead of move entire information source.
Hi @TopDeepaW, If you have all the connected dimension in the target environment, by deploying that exported “.ins” file in underline database you will be able to restore the same in the target environment.
Hi @Sshirley , Are there any row level repeaters available for the benefit accounts in the report design? If so please use the excel summation function like “=SUM(G10+G12) “ instead of using “=SUM(G10:G12)” range.
Hi @TopDeepaW , When it comes to calculated functions like Count, Max, Min, I have followed the below approaches based on the report design. Since we can use inbuilt functions of MS Excel when designing BR reports, if there is any possibility to generate the ranges we want to calculate in report design, we will be able to use excel functions to get the required result. And we can hide those ranges from design if they are unwanted. By creating custom attributes for the fact using required functions, we will be able to use them directly in report design. Best regards,SandT
Hi @Sshirley, Please use “NOT IN” operator to exclude multiple items from that filter. Best regards,SandT
Hi @WellactuallyjustBenny, I believe that the best way to create your report with required status, you have to add it to the fact using custom attribute feature. Best regards,SandT
Hi @WellactuallyjustBenny , If there is a light item named “PO Line Status” in your information source, Please try with it. Otherwise you can add the status field to light item by adding a custom attribute to the information source instead of following above manual workaround. Best regards,SandT
Hi @TopDeepaW, It works in both clients for me. I have attached a sample report for your review. I followed the following steps when developing that report.Put column repeater to company. Select the entire column. Enable Group functionality. Please check the attached report. If it also does not work for you please let me know your BR version. I did it on a cloud version 22.1.4. Hi @EntNadeeL , I think that the requirement of @TopDeepaW was to collapse the columns of the GL balances of all companies. As per my knowledge the company repeater should be there to repeat the balances within all the companies against GL accounts. Please correct me if I’m wrong. Best regards,SandT
Hi @TopDeepaW, Were you able to get the collapse option when you order the report from the Business Reporter client? or didn’t it give that option from both Business reporter client and your IFS client? Best regards,SandT
Hi @PennyB , If it is available in the Apps9 business analytics platform, you can use a “DATE_TO_CHAR” type functional parameter with your date format in your report design. This feature is available in the "Business Reporter" which was introduced from Apps10 onwards. Best regards,SandT
Hi @Christophe BUSSI , Yes, We did it for a customer by using the IFS analysis models solution. Instead of using IFS standard tabular models, We created our own power-BI reports using a SQL database as the data source which can be configured as a part of the IFS analysis models. If you need any further details please do not hesitate to contact me. Best regards,SandT
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
