Hello, Some advice or how to guide on adding a dimension(s) to an existing FACT table.We would like to use FACT_IL_ACCOUNT_BALANCE table for Business Reporter, we have also recently started using Accounting Structures from which the dimensions from accounting structures do not exit on the main FACT table or the underlying database view (as a persistent field)I believe we have to add the dimension to the FACT as below. From the existing set of dimensions here Any ideas or help as to what I need to do to join/link the DIM_ACC_STRUCT_ACCOUNT to the existing FACT_IL_ACCOUNT_BALANCE table?Any guidance appreciated Thanks,Rob
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.
Hi,I have written a IAL and quick information source has been created using IAL. Data from IAL looks like below . Above 5 fields are parameters of the report and as you can see in above screen shot SITE, BUYER_CODE and PROJECT_ID can be null. If user only enters COMPANY and TEMPLATE_ID as parameters (leaving site, buyer_code and project_id blank), I want to query records WHERE company = ‘XX’ and template_id = ‘YY’. But if user enters value for other 3, then that parameter should also be included in the WHERE clause (e.g if value for site is entered, query records WHERE company = ‘XX’ and template_id = ‘YY’ AND site = ‘ZZ’).How can this be done? Currently if I enter company and template_id only as parameters, it is not returning any data to the report.Help is much appreciated.
Please help to fix following error appearing while create an information source from selected QIS.
Hi,I need to modify an information source, however once created there is no option to move it back to draft status so it can be modified or deleted.I have looked in all the info source related pages and can’t find anything.Many thanksRodolfo
Hi Community, I migrated SSRS reports from VS2013 to VS2019 for IFS10 upgrades. I installed extensions required by Visual Studio 2019 in order to connect with IFS Oracle Database which includes, Oracle Dev tools for VS2019 and ODT.NET.I am able to test connection with the Report Server. However when I try to preview the SSRS report (inside Visual Studio) I receive this error: Has anyone encountered this issue before?
HiI have made a Profit & Loss report in IFS business reporter, only with actual figures.Now I have created a Budget version with some test budget data, which went OK, but I have problems getting them included in my P&L report. I want to make columns with Actual Data, Budget data, Deviation.But I can’t figure out how to include the budget figures in the P&L report. I can’t find any budget measure, no measure to select budget version etc.Are there no budget figures in Business reporter? ThanksSøren
Hi all.I have a simle QIS without security filter and as I run the report in excel it fetches just one row.Even running with the owner.How please could I fix this?Tks
Hello, Is there a way to pass multiple values in a given parameter in report designer (apps 10)? For example, if we add ‘supplier id’ as a parameter and the user wanted to get three suppliers (2654, 1759, 1953), is there a way to pass all three values in a single parameter that the report could then parse out to get the results? If yes, is there an out-of-the-box IFS report where I can see it working?Thanks,Tom Bowe
Hi,I have created a parameter “&Activity” for getting project activity short name. (Figure 1).And also created function parameter “&Activity_2” because “&Activity” is not mandatory while running the report (Figure 2).After I checked “multi value” checkbox of “&Activity” and also changed operator to “IN” for holding multi values in filter criteria (Figure 3). When running report with multiple values its showing blank pageAnyone can help me to solve this problem?
HelloI am new to IFS and the Business Reporter Application. I have not been able to import data from our Oracle Database (SQL), using the usual ‘Get Data’ option that is available in Business Reporter. The connection timed out while attempting to consume the pre-login handshake acknowledgement. The server I am trying to connect to , works fine and is available when other people try to access it, so the issue is only between Business Reporter and the database.I have checked the following and can confirm that everything is correctly set up and works correctly:Username and PasswordServer details and portal numberMy access permissions Has anyone encountered this before and is there an easy way to resolve this issue?
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.