In this post I’ll try to list criteria which has to be satisfied before going to production environment. All warehouse builder objects must be valid. No warnings or errors. All pages in dashboards are valid. Links working, filters rendered. Firewalls open on BI machine to access Dashboards from other machines.
Continue ReadingConverting An Enterprise Edition Database To Standard Edition
Recently I could not answer one question. Since Oracle Download page gives one setup file for Standard Edition One 11g, Standard Edition 11g, Enterprise Edition 11g, how can I install Standard Edition One 11g only? During setup I will not choose any options, is this enough? I don’t think so. In Oracle My Support I […]
Continue ReadingHow to Determine Number of Sockets for OBISE1
One of Oracle Business Intelligence Standard Edition One requirements (or limitations) is max 2 socket server. How to determine that? On windows machines I run WinAudit program. In summary page “Number of processors” it shows physical number of CPU, that means physical number of sockets. However, I know that I have two cores 🙂 So, […]
Continue ReadingIs There Data Model Alias Generator online?
I liked one feature of old good Oracle Designer – it automatically generated alias and title text from table name. I always have dilemma, what alias give for table when designing relational data warehouse. Does anyone knows any tools like this online or open source?
Continue ReadingSome Intelligence About Oracle Open World 11’ Events
Below there is the Europe map, where events will take place. England and Germany are the countries where the biggest number of events is planned. Does it mean, that in these countries have the biggest clients? Or, are they the most geographically convenient? It would be so nice, that at least one event happened in […]
Continue ReadingRules for data warehouse design and implementation
Here are some rules I follow when designing data warehouse. Fact attributes, which will be joined to dimensions can not be null. Instead add some predefined constant.
Continue ReadingOracle Workflow server is not mandatory to have ETL process scheduled in OWB
In Oracle Warehouse Builder 10g R2 you can schedule ETL mapping without Oracle Workflow server. Though, in tutorials in Oracle Library the only examples of scheduling ETL was through Process Flows, which are implemented in Oracle Workflow server. To schedule ETL mapping you should create Calendar and assign it to Mapping Object in Project Explorer. […]
Continue Reading