Replies posted by Stefan Nyberg

19 Replies

C
Do Gooder (Partner)
CD2022Do Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Report - Is it possible to supress rows with 0's in the values

Hi.When using the “All” checkbox on the repeater you can decide if you want to show all accounts even if there are no balances for the columns in the report or if you only want to show the accounts that have balances for one of the columns in the report.However, the value 0 is a balance. It means the you have registered vouchers on this combination and the result is +-0.I tried with a cell filter FACT_GL_BALANCE.BALANCE <> 0. In my sample report it did not show the row for the account when the balance was 0.But I don’t recommend using cell level filters. The performance can become a problem and the maintenance of the report becomes difficult./Stefan 

4
Marcel.Ausan
Superhero (Partner)
1 month ago
C
Do Gooder (Partner)
CD2022Do Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Reporter- Issues using drill down function

Hmm, not sure I understand…In the standard FACT_GL_BALANCE Drill Down is not connected to the same Information Source but to a Measure item in another Information Source FACT_GL_TRANSACTION.Isn’t that what you would do? You have aggregated data in one Information Source and transaction level data in another Information Source. You would then link the measure item in one information source to the measure item in another Information Source.So the Drill Down should not point at a dimension, right? /Stefan  

3
C
Do Gooder (Partner)
1 year ago
P
Do Gooder (Partner)
PlaBhagyWDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Advanced Criteria not working

Hi!I am sorry I cannot exactly say why your advance criteria is not working.But in general I would recommend not to use advance criterias. It becomes very difficult to administrate and update reports that includes complex advance criterias. It is also bad from a performance point of view because the IFS BR client cannot optimize the excution by combining data sets when advance criterias are used.Instead I would try to create attributes based on the accounts and connect needed accounts to the attribute values. Then create a filter based on the attribute. Perhaps also fetch data into two datasets and then calculate the sum of the datasets by using MS Excel formulas if possible./Stefan

1
S
Do Gooder (Employee)
1 year ago
C
Do Gooder (Partner)
CD2022Do Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter -Using wildcard in a report parrameter

Hi!I think you should be careful with LIKE ‘%’ since LIKE can be very bad from a performance perspective.BETWEEN can also be bad from a performance perspective. You shoud try to stick with = and IN.Instead of LIKE &parameter and default value beeing ‘%’ I would use the “ALL” functionality.The filter would be IN &parameter and the default value for the parameter would be ALL.When using the “ALL” functionality and value the WHERE statement would not be added to the final SQL -statement. There could be a big difference in the performance when leaving out the WHERE statement for the filter instead of having a WHERE statement with LIKE ‘%’./Stefan 

6
S
Do Gooder (Employee)
1 year ago
S
Do Gooder (Customer)
setayeshDVDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Data Warehouse and ETL IN IFS Application

Well, modelling and implementing a data warehouse solution from scratch based on e.g. IFS Maintenance could be a huge task. With IFS Analysis Models you get a pre-defined solution including the tabular model. It could save you a lot of time and money. You have to evaluate what is the best solution for your situation./Stefan 

5
bpfrenchak
Do Gooder (Customer)
1 year ago
S
Do Gooder (Customer)
setayeshDVDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Data Warehouse and ETL IN IFS Application

Hi.IFS Applications / IFS Cloud does not include a solution for building general purpose Data Warehouses (data storage, ETL -tools, analytical models). However, IFS Applications / IFS Cloud includes a “pre-packaged Data Warehouse -solution” for the functional areas that are included in IFS Applications / IFS Cloud.The solution IFS Analysis Models is based on predefined Information Sources (star schema meta-data models and Oracle views), MS SQL Server (including SSIS -logic) and analytical models in SSAS (OLAP cubes in IFS Applications 10 and tabular models in IFS Cloud). In IFS Cloud the solution can be administrated directly from IFS Solution Manager.The IFS Cloud based IFS Analysis Models solution can be configured. As an example you can add Custom fields to the Information Sources and to the tabular models. But lets say IFS Applications / IFS Cloud is only one of many data sources. In this kind of a situation you would have to use “general purpose” DW and ETL -tools for building you

5
bpfrenchak
Do Gooder (Customer)
1 year ago
D
Do Gooder (Customer)
DexpneDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to add a dimension item to an existing dimention?

Hi!You can add certain items that are missing in a dimension by creating “Custom Attributes for Dimensions”. After creating the custom attributes you can publish the items to the dimension.You should not go to the Information Sources / Dimensions -page and try to modify the standard dimensions from there.However, you should be careful when creating custom attributes. When the relations are not technically optimal, you can get performance problems using the custom attributes in your report. Especially if you are using custom attributes for facts. Also try to avoide using function calls in your custom relation. Try to join the tables directly instead.Regards,                Stefan 

2
B
Sidekick (Partner)
7 months ago
12gAshanD
Do Gooder (Partner)
12gAshanDDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IAL Availability in Cloud 22R1

Hi @12gAshanD  in Aurena 22R1 IALs are available but one day they will be deprecated. I heard it in a IFS online webinar also. If you want to upgrade to IFS Cloud I recommend you don’t create new IALs there. Hi, “one day”, like @Link has written = “22R2” :) BR Sven Hi!In the 22r2 technical documentation (https://docs.ifs.com/techdocs/22r2/) you can find the following chapters:Create Information Access Layer Objects - Technical Documentation For IFS CloudIn the section reagrding configuring tabular models in 22r2 in IFS Analysis Services the following comments can be read:Ways of creating source views in schema: Using the IAL Object tool Creating Quick Information Sources or Quick Dimensions, publishing them as ordinary Information Sources/Dimensions and using standard functionality to, from an Information Source, create Access Views. Regards,                  Stefan 

8
A
Hero
1 year ago
M
Do Gooder (Employee)
Marc BOBENRIETHDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Reporting - Access view - 22R1

Hi!The tabular models in SQL Server is a part of the IFS Analysis Models offering. In the IFS Analysis Models solution the Access Views are used as the source for the tabular models. The transactions and dimension data in IFS cloud (Oracle) is transferred to the SQL Server using the access views to populate the tabular models in SQL Server.Regards,                 Stefan

1
S
Do Gooder (Employee)
1 year ago
K
Do Gooder (Customer)
KPalmieriDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to get BR Software Updates?

Hi!Do you mean “how to be aware of new Business Reporter software updates that IFS R&D is releasing”.If you use ClickOnce methodology for BR installation the users will automatically get the IFS BR version that has been delivered to your production environment.But if you want to get notifications of new updated client versions that the IFS R&D is releasing it is a different matter. There is an Excel spredsheet  with all client versions covered. 5.0.26 means that 26 versions of the client has been released. In every client release there are a number of corrections also listed in the same Excel sheet.However I don’t know if that document is available externally?/Stefan 

4
S
Do Gooder (Employee)
1 year ago
T
Do Gooder (Employee)
ThejanJayDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Question on loading data from IFS Cloud to existing Data Warehouse

Hi!The recommended standard way would be to create new Information Sources (and related views) as a standard modification. Then you can create Access Views based on the new Information Sources./Stefan

3
S
Do Gooder (Employee)
1 year ago
T
Do Gooder (Employee)
ThejanJayDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

Question on loading data from IFS Cloud to existing Data Warehouse

Hi!The concept of Access Views has been implemented for supporting loading of data to Data Warehouses. There are many benefits compared with using application views in IFS Cloud.If the standard Information Sources and the Access Views based on the Information Sources are missing some information I would create IAL’s to “fill the gap”. The Access Views and the IAL’s are both located in the IFSINFO schema. 

3
S
Do Gooder (Employee)
1 year ago
G
Do Gooder (Customer)
GT69Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Viewing Business Reporter report output

Hi!Thx for the comments.But I still agree with the original question that it is quite complicated to order and view a report in IFS Aurena without using the BRES.Using BRES requires a separate process. Order report => check if the report has been executed => when ready open the report.I think this will result in two options:If you want to order the report and wait for the result to be opened directly => use the IFS BR ClientIf you want to order the report but can leave opening the report until later => IFS Aurena interface can be used together with BRES./Stefan

8
G
Do Gooder (Customer)
1 year ago
G
Do Gooder (Customer)
GT69Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Viewing Business Reporter report output

Hi!Yes in the IFS Aurena interface and in the IFS Cloud version it is working the same way.I don’t think I have an answer. My comment was more to open a discussion reagrding the process of ordering and viewing reports in these versions of IFS Applications. Hope we get more comments in this Topic.Regarding Business Reporter Execution Server (BRES). BRES should not have a separate license so you should not have to pay extra for using BRES. But of course BRES need to be installed and configured that will require hours from technicians. /Stefan

8
G
Do Gooder (Customer)
1 year ago
Thiwanka Sandaruwan
Hero (Employee)
Thiwanka SandaruwanHero (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)

How to control access for a BI access view that is created based on Quick Information Sources

Hi!The BI access views are created in the IFSINFO -schema. This means that the IFSINFO user will automatically get access to the BI access views created.But you mean that you would like to use another Oracle user to access the BI Access view in the IFSINFO schema?I think it has been said that in IFS Cloud you can only access the database directly using the IFSINFO user and only for DW/BI purposis. Therefore it might be so that there are no separate control access for the access views.Do you agree?/Stefan  

1
S
Do Gooder (Employee)
1 year ago
G
Do Gooder (Customer)
GT69Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Viewing Business Reporter report output

In the IFS Cloud version I was testing the same area.When you order the report you cannot open it directly like in the IFS Apps 10 version, you need to download it.You could click on the report in the toolbar for downloaded files to open it directly but since C:\users\username\downloads is not a trusted folder it will not open up.You could go to the downloads -folder to “Unblock” -the file in order to open it. But when you open it you need to login and after logging in I cannot see the report mode only the design mode…Is this the same as what you are struggling with?/Stefan  

8
G
Do Gooder (Customer)
1 year ago
G
Do Gooder (Customer)
GT69Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

Viewing Business Reporter report output

Hi!Are you referring ro the IFS Cloud version?/Stefan

8
G
Do Gooder (Customer)
1 year ago
A
Sidekick (Customer)
Anders JanssonSidekick (Customer)
asked in Finance (Financials)

Business Reporter - writeback requirements

Hi!Yes it should be possible since an Information Source created based on a Quick Information Source Draft is technically the same as a standard Information Source.However, you need to implement a database method/function to retrieve the data that is written back from the IFS BR client. I don’t think you can (should) do this as a onfiguration, can you?/Stefan

6
M
Hero (Partner)
1 year ago
B
Sidekick (Employee)
bartlomiej.pobochaSidekick (Employee)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Do data of report from IFS business reporter tool is stored in database?

Hi!I know that when the BR report logic is converted into SQL statements and executed on the server side, the resultset in stored in an xml -format on the server side. The xml -data is then transferred to the BR client to be rendered in MS Excel. But I have never heard of getting hold of and/or using that xml -file for other purposes... When using BRES you can from the BRES administration window export the DSRD to a file, that includes the data for the report. But I don’t know if you can use that file/data in some way? Regards,                   Stefan

2
B
Sidekick (Employee)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings