设置自定义日历表 [英] Setting up a custom calendar table
问题描述
在Rob Collie的Power Pivot第25章中,Rob讨论了使用Periods表来支持自定义日历。他还展示了如何将Periods表连接到Calendar表。但是我没有看到为什么一个单独的Periods表首先推荐
的解释。
In Chapter 25 of Rob Collie's Power Pivot book, Rob discusses the use of a Periods table to support a custom calendar. And he shows how to connect the Periods table to the Calendar table. But I don't see an explanation of why a separate Periods table is recommended in the first place.
我们不能只是在Calendar表中添加额外的列来处理自定义期间?通过维护一个单独的期间表获得了什么?
Couldn't we just add additional columns to the Calendar table to handle custom periods? What is gained by maintaining a separate Periods table?
除非我弄错了,这就是意大利人在撰写时在他们的分析数据手册中所推荐的,"重要的一点是本书的目的是让您不需要额外的表来顺利处理财务日历。如果您的日期表
的设计和使用方式正确,那么处理不同的日历非常简单,只需更新您的日历表即可实现。"
Unless I'm mistaken, that's what the Italians recommend in their Analyzing Data book when they write, "The important point for the sake of this book is that you do not need additional tables to handle fiscal calendars in a smooth way. If your Date table is designed and used the right way, then handling different calendars is very simple and can be achieved by simply updating your Calendar table."
我是什么?缺少?
创始人,ExcelUser.com
Founder, ExcelUser.com
推荐答案
你好Charley,
Hi Charley,
不需要单独的句号表,因为它会使查询复杂化。自数据仓库开始以来,具有所有必需周期的单个日期维度表已成为常态。因此,意大利人的陈述是正确的。
A separate periods table is unnecessary because it complicates queries. Since the beginning of data warehousing, a single date dimension table with all required periods has been the norm. Therefore, the statement by the Italians is correct.
这篇关于设置自定义日历表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!