
OLAP
woothon
这个作者很懒,什么都没留下…
展开
-
Create Multiple Measure Group for one fact table
1, Double Click Data source view(DSV)2, Click New Named Query icon. <!--[endif]-->3, Create New Named Query for the fact table <!--[endif]--> 4, Click Ok.5, Double click ...2014-07-11 07:26:19 · 150 阅读 · 0 评论 -
Refresh Data Source View (DSV) after table or view updated
After you modify your tables or views for the OLAP.You need to refresh DATA Source View to get the update. And refresh is done, it will ask you if that change is you needed.if yes, click Ok,...原创 2014-07-11 07:32:58 · 139 阅读 · 0 评论 -
Add a yes/no flag dimension
Follow below instruction to add a boolean(yes/no 1/0) flag.First of all, you need a column/field which only contains 1/0, 1 stands for yes/true, 0 stands for no/false. Add a yes/no dimension....原创 2014-07-11 08:03:11 · 119 阅读 · 0 评论