摘要：
I think I have forgot most ofmy knowledge about SSAS.Now I just want to remind me about how to create a cube:Cube is on the basic of dimension, now I have three dimensions:time,product,employee.FirstThen select related fact tables we will use in cube:Then we will select the meric that we need next p 阅读全文
摘要：
Now I have SSAS solution project :Adventure Works SSAS Riight click on the 'Dimension' and select 'new dimension' then: next:select the right data sou 阅读全文
摘要：
When the first I get in touch with BI,I heard about the word 'CUBE'.But,what's the exact meaning of cube?I have no idear.Now,I am readind a book about SSAS that written by Chinease and have a little knowledge about CUBE.We call it '多维数据集', and in my opinion, it's used to anal 阅读全文
摘要：
learnt how to create dimension by SSRS.Just do as the book said and encounter a problem:When I was deploy a date dimension,throw the warning:OLAP 存储引擎中存在错误: 处理时找到重复的属性键:……To solve it:In the attribute of the dimension,modify the ErrorConfiguration-->KeyDuplicateas IgnoreError. 阅读全文
摘要：
SSAS中的维度表（dimension table）指的应该是一个事件中的某方面（时间，地点，人物……）事实表（fact table）就是由几个维度组成的事件（时间，地点，人物构成这个事件） 阅读全文
摘要：
Here is a sample for restore and bak sql server database:alter database pubs set SINGLE_USER with rollback IMMEDIATE use master RESTORE DATABASE pubs FROM DISK = 'c:\pubs.bak' WITH NORECOVERY, MOVE 'pubs' TO 'C:\xx\pubs.mdf', MOVE 'pubs_log' TO 'C:\xx\pubs_log.ldf 阅读全文
摘要：
First, we shoud configue by the Report Service configuration manager,here we can configue the report database and the URL. Then create a report projec 阅读全文
摘要：
OLAP(online analytical processing),and there are 3 advantages: 1.Continuous fast response. Because the values that needed is pre-calculated before the 阅读全文
摘要：
用电脑WiFi热点，手机连接上网（非connectify,APwifi）开启windows 7的隐藏功能：虚拟WiFi和SoftAP（即虚拟无线AP），就可以让电脑变成无线路由器，实现共享上网，节省网费和路由器购买费。Sensation，还有笔记本亲测通过,方便，稳定，网速好！ 以操作系统为win7的笔记本或装有无线网卡的台式机作为主机。 主机设置如下： 1、以管理员身份运行命令提示符： “开始”---在搜索栏输入“cmd”----右键以“管理员身份运行” 2启用并设定虚拟WiFi网卡： 运行命令：netsh wlan set hostednetwork mode=allow ssid=w.. 阅读全文
摘要：
23 阅读全文