TAILIEUCHUNG - Oracle Essbase 9 Implementation Guide- P33

Oracle Essbase 9 Implementation Guide- P33:Essbase is a multidimensional database management system. The name Essbase stands for Extended Spread Sheet dataBASE. Using the custom add-in provides the end-user with near seamless compatibility in the Microsoft Excel spreadsheet program. | Chapter 4 Repeat the steps above for all of the fields contained in the data source for which you are creating the data load rule until all of the fields are defined to Essbase. Now that you have updated the property settings on all of the fields it would be a good idea to validate all of the field definitions and properties against your database outline. In the very next step we will see how to validate the data load rule file. Step 9 Validating the data load rules file In this step we will validate the correctness of the definition that you have provided to the rule file. Please make sure you validate after making changes to the rule file. If there is any error you will get errors while loading the data. To validate the data load rules file 1. In EAS open the Data Prep Editor. 2. Click on the Validate button last button on the Data Prep Editor window or you can click on Options and then click on Validate. 3. You should see a message The rules file is correct for data loading as shown here 145 Download at Loading Data into Essbase 4. Let us actually remove the field definition for the Field6 go to Field then Properties then to Field 6 and remove the Field name and now click on the Validate button. You should see an error message stating Field6 is not defined as shown here Step 10 Saving the data load rules file Now that you have validated the data load rules file and there are no errors you can save the rules file. Remember to use the proper Essbase 8 character naming convention while saving the rules file. You can save the rules file in your local file system or on the Essbase server using the Essbase file system. We prefer to save all of the files on the Essbase server. The rule files will be saved with the .rul file extension in Application Database directory on the Essbase server. Whatever place you choose to save your data load rules files always try to be consistent to make things easier. Consistently saving files in the same location or .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.