Data warehouse objects must be loaded in certain order. This order could be like this: Stage or temporary tables Disable all constraints Dimension tables Fact tables Enable all constraints
Continue ReadingBlog
Transform MSSQL Tables to Views for Input to Oracle Warehouse Builder
This code is written by myself. You can use it to generate views from tables in MSSQL database. These generated views are input to Warehouse Builder as a source database objects. The best part of it, that it does a bit of validation and transforms CamelCase notation (which is used in MSSQL database object names) […]
Continue ReadingKomentarai MS SQL duomenų bazėje
Duomenų sandėlio kūrimą dažnai prilyginu “reverse engineering” procesui, kai reikia suprasti, kas ir kodėl buvo padaryta. Komentarai DB lygyje yra labai didelė pagalba. Dėl to man patinka dirbti su Oracle. Komentarus paprasta įterpti, perskaityti. Yra daug nemokamų įrankių, kurie sugeneruoja dokumentaciją pagal komentarus. MySQL irgi panašiai, kiek pamenu. Microsoft SQL atveju..na tai tiesiog užknisa. Net […]
Continue ReadingChecklist to Move BI solution to production environment
Items need to be done or checked, when moving BI solution from test environment to production environment for the first time. Open firewall port 1521 for Oracle listener Open LDAP ports if using Active Directory. 389 for non SSL and 633 for SSL ….
Continue ReadingSchedules or Multiple Configurations licensing from OWB 10R2
It appears, from reading Oracle Warehouse Builder 11gR2: Feature Groups, Licensing and Feature Usage Management, that schedules or multiple configurations requires Oracle Warehouse Builder Enterprise ETL license. If you have OWB Core, then scheduling a OWB mapping has to be done using Enterprise Manger Grid Control, Database Control or any other application that can manage […]
Continue ReadingKaip importuoti egzistuojančias lenteles į Oracle Warehouse Builder
Į Oracle Warehouse Builder 10g importuoti lenteles tenka, kai lentelės sukuriamos per SQL skriptus, o ne per OWB įrankį. OWB11g versijoje labai panašiai vyksta lentelės importas. Daroma prielaida, kad lentelė jau yra duomenų sandėlio schemoje. Atsidarome Design Center. Ant duomenų sandėlio duomenų bazės modulio spaudžiame dešinį ir Import… Atsidariusiame lange spausti Next> Palikti pažymėta tik […]
Continue ReadingEnterprise Manager and Oracle Workflow Manager to Oracle Business Intelligence Standard Edition One 10g
It is possible to manually install Enterprise Manager Database Control and Oracle Workflow Manager to Oracle Business Intelligence Standard Edition One 10g. To install Oracle Workflow Manager you need to start Oracle Universal Installer. Modify current installation. To install Enterprise Manager Database Control you need to use console application emctl.
Continue ReadingEnvironment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da tabase unique name
emctl status dbconsole command gives error “Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name”. How to fix this error? Add environment variable. Go to Start > Control Panel > System On the left press Advanced System Options Go to Environment Variables… Pres New… Enter Variable name “ORACLE_UNQNAME” and Variable value “orcl”. […]
Continue ReadingHide physical folders depending on user role
One client asked us: “Is it possible to hide/show folders in repository physical layer depending on user‘s GROUP? One company departament sees just Forecast dababase (also related bussines layer and presentation), other Paint, etc.”. As much as I know, it is not possible. Is this right?
Continue ReadingBI project life-cycle
Usually I make 3 iterations Initial development from analysis and requirements documentation. Showing to clients. Receiving feedback. Updates to reports depending on first iteration feedback. Again showing to clients and getting final feedback before release. Final updates after second iteration feedback. Going to production environment. Support period.
Continue Reading