Hi, Select Database Task in folder Database Task and Chain Grants. Then select the permission set from the list of not granting permission sets and click Grant. Kind regards, Paul Beekmans
Hi,No, you cannot use multiple values in combination with the like statement. If you use multiple values, you can use the IN condition instead. Combining both conditions (LIKE and IN) would be very useful but isn’t possible as far as I know.Cheers, Paul
Hi, I normally select ‘%’ as default value in the parameter defintion and then apply condition 'LIKE &Parameter’. Best regards, Paul
Hi,You can do this by creating a design row where you repeat on account and create three design columns, one for each period. Don't set filter on accounting period in the report header or on sheet but apply filters on each column. Create 2 parameters to select year and period (or one for yearperiod). Then you add function parameters to calculate previous accounting period and last year period. You can use advanced function GET_YEAR_PERIOD_INCR to calculate previous period. You need to add some parameters to calculate year period and convert to string value before you can this function. In a similar way, you can build up a string value for last period from previous year. Use these parameters to filter accouting periods in relevant columns.
Hi Rakesh,The BR's that you save as loca lfiles must be stored in Excel trusted location. You can select a folder in Excel > Options > Trust Center > Trust Center Settings > Trusted Locations.I prefer to save the reports in the database and create a local copy just as back up. You save in database from BR ribbon in developmen mode.Kind regards, Paul
Hi Rakesh, There are some finance reports in BR client, provided by IFS. Also the Designer's Guide under Help button is very useful to get you started. Kind regards, Paul
Hi Cameron,I have not come accross that. I have created several information sources and dimensions and can use filters in IFS Business Reporter as it works for other information sources.From your post I cannot tell what exactly goes wrong in your case.Does the filter in BR work when you apply a filter on light items from the information source? I guess that works fine. If a) works and filters are not applied when you filter on dimension items, I guess something is wrong with the connection between information source and dimension.Do you know you can find the query that gets prepared for your report in 'Information Sources - Runtime Log’. If you know how to read SQL statement, maybe you can identify from there what is incorrect.
Hi Melissa,You can find it when you search on pivot in online documentation :).
Hi,If I'm correct, you do have 1 or more transactions related to the object, but you don’t want to see the objects where the sum of the transaction values is zero.You cannot manage that with the filter options in IFS Business Reporter. Based on your design, SQL query statements are prepared and filter criteria are applied in the where clause of those queries. The repeater items result in a group by clause. What you are asking for is to apply the filter criteria in the having clause of that query and that is not supported by IFS Business Reporter.To surpress those rows, you will have to use Excel features. E.g. fetch transactions on one sheet and build a pivot table on another to show the results. You can apply filters in the pivot table. Using pivots in IFS Business Reporter is supported but not straight forward. The online documentation describes how to do it.Best regards, Paul Beekmans
Hi Martin,You have to create a ‘Custom Dimension LoV’ for this. The technical documentation explains why this is needed if you run the report from IFS client and not when you order the report from IFS Business Reporter client. It also describes how to add a custom dimension LOV.To test the custom dimension LOV, don't forget to unpublish and publish the report after you apply changes to Custom Dimension LoV.Kind regards and good luck, Paul Beekmans
Hi Sören,Adding standard fields that are missing in the information sources as delivered by IFS, is not much different from adding custom fields to the information sources. You can add it as attribute to fact (after you created relations for fact). In this case, probably you can use View as source type. Technical Documentation gives an example for each source type.Kind regards, Paul
Hi,In Google Chrome, you can change settings to ask user to which folder files must be downloaded. When enabling this, user must select a folder for every download, also not related to IFS, and can select a trusted folder for IFS Business Reports.Kind regards, Paul
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.