A method for structuring a data store by analysing source data bases using the steps of relationship discovery, schema merging, hierarchy discovery, heuristic based attribute inclusion and optionally denormalising This is applied to products such as Navision in building an OLAP cube for use in business intelligence applications. Also disclosed is a security adapter to carry security settings from a source data base to an OLAP cube which includes creating a synthetic dimension in the OLAP cube which is a common trait related to all other dimensions in the cube and one role is created for each role in the source data base and users treated as members of those roles as defined in the source data base.
申请公布号
WO2010091456(A8)
申请公布日期
2010.10.21
申请号
WO2010AU00134
申请日期
2010.02.09
申请人
ZAP HOLDINGS PTY LTD;LEDWICH, MARK, JOSEPH;WILSON, JAMES, HENRY