Bookshelf Home | Contents | Index | PDF |
Siebel Business Analytics Server Administration Guide > Completing Setup and Managing Repository Files > Process of Completing the Setup for a Repository File > Test and Refine the RepositoryWhen the repository is created and you can connect to it, run sample queries against it to test that it is created properly. Correct any problems you find and test again, repeating this process until you are satisfied with the results. Tips For Performance TuningThe Physical Data Model should more closely resemble the Siebel Business Analytics metadata model (for example the star schema) instead of an transactional database system (approximately 3NF). If the Physical model is set up like the underlying transactional model, performance problems and configuration problems could likely arise. For additional tips, see Guidelines For Designing a Repository. NOTE: Make sure the metadata is generating the correct record set first, then focus on performance tuning activities (such as adding sources).
|
Siebel Business Analytics Server Administration Guide |