Thanks. The file name is explicit and does not use a parameter and the file name will be the same each time.
Also, I found the ‘NODE_ID_DESCRIPTION’ column in database view ‘DIM_ACC_STRUCT_NODE_ACCOUNT_OL’ contains the data I am looking to join to database view ‘FACT_CONSOL_BALANCE_OL’.
@Yasoda Can you please tell me which IFS Apps version and update levels are compatible with IFS BR version 5.0.9.0?
@tmurphy All users will need the BA add-on installed their PCs to view BA reports. This includes running reports from IFS IEE. The application basically launches BA for the user in the background and renders the results in Excel (BA). This would likely produce blank results if the BA add-on was not installed on the user’s PC.
Nisansala’s response lead me to the correct solution, which was all related to Data Configuration within IFS application and the SSIS Configuration Tool. Specifically, some Data Mart Sources needed to be Activated and refreshed manually within IFS IEE after the initial installation. I also checked the settings for the SSIS Config Tool and noticed I had not correctly set up the Master Company within Reporting Currency Rate Type Lookup and Reporting Period Lookup.I saved all changes and ran the ETL process again, which populated the Currency Rate tables and Sales cube successfully. Thank you again for your help!
Nisansala, thank you for your response. I checked the tables and DW_Fact_Reporting_Currency_Rate and DM_Fact_Reporting_Currency_Rate are empty. The IFSAppl_FACT_CURRENCY_RATES_BI_OPT table has data, however. I am looking into the .dtsx packages to see where the problem is occurring. Have you experienced this before?
Chamin, we encountered a similar issue while trying to develop and share BA reports before Publishing them into IFS. We used SharePoint to host the BA report files and instructed users to download them to their local PC (C:) drive for testing or development, as BA reports will not run from Network drives. We still currently use SharePoint as the main repository for the master copies of the BA reports published within IFS. Ultimately, once the report is finalized, the best thing to do is to Publish the BA reports into IFS and have users run the reports from within the application. Keep in mind, users will need the BA software installed on their PCs to run any type of BA report, even from within IFS.
Already have an account? Login
No account yet? Create an account
Enter your 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.