摘要：We recently had a project reading data from a Oracle database using 'Microsoft OLE DB Provider for Oracle'. But since both of our database and OS are in 64bit version, we usually encoutered an error below: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider MSDAORA.1 is not registered -- perhaps no 64-bit provider is available. 阅读全文

摘要：SSAS中的主动缓存，的意思就是主动处理类似，当一个条件触发，则cube开始处理维度和度量值聚合，所以主动缓存，可以理解为主动处理。 阅读全文

摘要：A database snapshot is a read-only, static view of a SQL Server database (the source database). The database snapshot is transactionally consistent with the source database as of the moment of the snapshot's creation. A database snapshot always resides on the same server instance as its source database. As the source database is updated, the database snapshot is updated. Therefore, the longer a database snapshot exists, the more likely it is to use up its available disk space. 阅读全文

摘要：当我们使用Qlikview straight table来表现数据时，经常会遇到有很多的维度列或表达式列需要在表中表现出来，往往超出了屏幕的宽度而需要拖动滚动条，非常不方便。而实际上，并不是所有的列对于用户来说都是有意义的，甚至在不同的时期用户只关心其中某些列内的数据。但是，为了满足所有用户的需求，我们有时需要让所有的列对用户有效。 Dynamic dimension能够让用户可以方便的选择他关心的列，本文将要教你如何如何创建动态维度列。 阅读全文