随笔分类 - SSAS
摘要：The concept of incremental processing is well documented by T.K. Anand's fabulous whitepaper on processing (which you should probably digest before co
阅读全文
posted @ 2017-06-26 13:35
俊凯
摘要：There is not much documentation about how to do a ProcessAdd for a dimension in SSAS (SQL Server Analysis Services). Doing a ProcessAdd for a partitio
阅读全文
posted @ 2017-06-26 13:34
俊凯
摘要：There are several repetitive SSAS tasks that I perform on a regular basis and I want to know what options there are to automate some of these tasks su
阅读全文
posted @ 2017-06-22 14:00
俊凯
摘要：In my last tip about PowerShell for SQL Server Analysis Services, we offered an introduction to PowerShell. In this second tip we will demonstrate how
阅读全文
posted @ 2017-06-22 14:00
俊凯
摘要：Over the last few days I’ve been involved in an interesting thread on the SSAS forum regarding what happens when you do a Process Update on a dimensio
阅读全文
posted @ 2017-05-11 17:51
俊凯
摘要：MDX calculated member total http://stackoverflow.com/questions/31291094/mdx-calculated-member-total?answertab=active#tab-top https://blog.crossjoin.co
阅读全文
posted @ 2017-05-10 16:50
俊凯
摘要：http://blog.decentrix.com/cube-synchronization-through-analysis-services-ddl-tasks-in-ssis/ One of the most common things we do in the Business Intell
阅读全文
posted @ 2017-04-07 16:57
俊凯
摘要：https://blogs.msdn.microsoft.com/vhinz/2011/03/16/dimension-properties-as-tooltip-in-excel/ Step by Step:Dimension Properties as Tooltip in Excel Obje
阅读全文
posted @ 2017-04-07 15:34
俊凯
摘要：So you did everything correctly with your OLAP project. You had a trained Project Manager leading the team; users were directly involved from the begi
阅读全文
posted @ 2017-04-06 11:11
俊凯
摘要：http://www.ssas-info.com/analysis-services-articles/62-design/689-dimensional-model-components-dimensions-part-ii Written by Vidas Matelis on 18 Febru
阅读全文
posted @ 2017-04-06 11:03
俊凯
摘要：INVENTORY MANAGEMENT CALCULATIONS IN SQL SERVER ANALYSIS SERVICES 2005 A common business problem is how to calculate inventory based on incoming and o
阅读全文
posted @ 2017-04-06 11:02
俊凯
摘要：https://www.entsoftsol.com/Home/Blog/memory-analysis-and-caching-in-ssas If you have a MS SQL Server background, analyzing the SSAS memory usage patte
阅读全文
posted @ 2017-03-28 16:16
俊凯
摘要：http://www.sqlservergeeks.com/sql-server-implementing-calculations-in-ssas-using-mdx-part-3/ In this ending part of the tri series posts let’s check o
阅读全文
摘要：There are several aspects that can hurt performance of your Analysis Services cubes. Some problems could be on the source system, some could be becaus
阅读全文
posted @ 2017-03-10 11:42
俊凯
摘要：In the first part of this series we looked at processing performance, query performance and hardware resources for your SSAS environment. In this tip,
阅读全文
posted @ 2017-03-10 11:32
俊凯
摘要：https://ask.hellobi.com/blog/biwork/1083 开篇介绍 对于维度成员和事实数据直接的关系看到更多的可能还是一对一，一对多的关系。比方在事实维度(或退化维度)中一个订单和明细号组合而成的ID，对应的就是事实表中的一条数据，这就是一对一的关系。比方说在产品维度中，一个
阅读全文
posted @ 2017-03-01 13:51
俊凯
摘要：https://ask.hellobi.com/blog/biwork/1081 开篇介绍 这篇文章是基于上一篇 SSAS 系列 - 多维数据集维度用法之一 引用维度 Referenced Dimension 继续讲解多维数据集维度用法中的事实维度。 事实维度 事实维度，顾名思义就是把事实表 Fac
阅读全文
posted @ 2017-03-01 11:35
俊凯
摘要：Aggregations An aggregation is a data structure that stores precalculated data that Analysis Services uses to enhance query performance. You can defin
阅读全文
posted @ 2017-03-01 11:02
俊凯
摘要：优化前注意事项 1、数据质量。数据仓库中维度表的数据质量要严格保证。比如店仓的大区、省区、管理城市等属性和店仓代码没有一对多的上下级关系，这样在设计店仓维度时，就无法建立有效的层次结构。这会拖慢查询时的性能。 2、对报表分类。可按报表的使用方式和体积对用户报表进行分类。 1) 有的报表侧重分析，维度
阅读全文
posted @ 2017-02-28 16:36
俊凯
摘要：https://blogs.msdn.microsoft.com/sqlblog/2015/06/10/ssas-dsv-com-error-from-ssdt-ssas-design-data-source-view/ Recently I worked on a case regarding a
阅读全文
posted @ 2017-02-17 15:44
俊凯
浙公网安备 33010602011771号