Skip to main content

Ron Liu

Blogs from this Author

Generating Surrogate Keys in SSIS

 As we know, in MSSQL, we could set column identity property as yes to get incremental value, and we could also use sql function RowNumber() to get this. But in SSIS, there is no RowNumber() function, and setting column identity property is also not very flexible, and here is another way that using script to […]

Using Metadata Integrator

Business Objects provides a tool named Metadata Integrator to import relationship between universe and report. You need configure CMS(Central Management Server) and target database in Metadata Integrator first, then run, then it will load those relationship into target database. Below is window when data loading starts Here is description of related tables: Table Name Description […]

Several Performance Tuning Suggestions in SAP Business Objects Data Services XI 3.2

1.       In Table Comparison component   1.1.    Use ‘Row-by-row select’ if a.       Target table is nearly or more than 1GB b.      The daily loaded row count is stable and small (less than 5%)           Note: should create index for columns in ‘Input primary key columns’ section   1.2.    Use ‘ Cached comparison table’ if a.       […]

Using SAP Business Objects Query Builder

Business Objects has a CMS repository which stores all information about reports and universes. Since the data is stored in a binary format in database, then we could not query directly to get all these information.

Use Local Variable to Pass Value in Rows

Sometimes we need to calculate one column with cumulative value based on other columns value and value from previous row, here is one case Column BUSINESS_DAY_OF_MONTH should have a cumulative value of business day count in one month. You might have some sql script to get this value, but here is a simple way in […]