Information Warehouse Ownership

Who will be the owner of Information Warehouse? It is really essential problem but tough to answer. Here are numerous examples from the practice of how you can apply Data Warehouse ownership.

First, there might be two levels of information ownership: production data level and cube/theme information level. Ownership on production data level is clear to define due to the fact users who want information from productions systems have to ask production program owner for permission and access rights. Production system owner permits information cube, information theme or report initiator to use data from production. Information organized in new environment like cube or theme mean new data. It is so since scenario is a lot more complex, cubes or themes are produced from commonly created from numerous production sources and information is worthless without excellent context. Who is the owner of the cube? It can be the individual who initiated cube creating, request who began constructing of the cube. Owner of cube or theme is second level owner. Anybody who would like to use data from reporting cube, reports or themes ought to ask second level information owner for access rights. Owner of the cube asks for information access from source systems but prospective users of the cube ask cube owner.

Making fragmented ownership by dimensions and measures ownership is too complex and messes total procedure.

Who is Information Warehouse owner? If the ownerships has to belong to only 1 department it is a little bit risky decision. For instance if It can be owner, they are just service providers without in deep information what to do specifically with content. Perhaps far better variant is to give ownership to technique or to finance, to be extra precise to controlling. Reason for this decision is general view over definitions. Definitions are important for solid external and management reporting. Controlling knows most effective what type of goods might be produced upon Data Warehouse for official reporting. If this solution is still not adequate perhaps finest remedy would be to establish committee of professionals from all business areas with lead from controlling and to give ownership to this body.

Without ownership there is going to be no strategic development of Information Warehouse system. It will only run for coverage of existing needs with out any pro active approach. Information excellent management is going to be really doubtful and at the end there will likely be no one to decide tips on how to deal with vast quantities of necessary actions.

There is actually a powerful must declare officially Data Warehouse ownership and to establish information security procedures as soon as possible.