需要在我的SSAS多维数据集中添加日期维度。 [英] Need to add a date dimension to my SSAS Cube.

问题描述

我需要在我的SSAS多维数据集中添加日期维度。

我的表格结构如下：



我有我的度量表ABC_Metrics包含所有度量。此表格自2010年起有一个日期字段

即自2010-01-01至今的每一天，即2015-11-13，我有大约900行。



我有一个事实表ABC_Master，它包含所有主要属性，如郡，地区，市场等。



我如何去做添加日期维度。我要求的是用户能够向特定日期/日钻取数据。我不需要时间维度。



这听起来像是一个基本问题，但这是我第一次尝试创建SSAS Cubes

非常感谢任何帮助。

I need to add a "Date" dimension to my SSAS Cubes.
My table structure looks like this :

I have my metrics table ABC_Metrics that houses all the Measures. This table has a Date field since 2010
i.e. for each day since 2010-01-01 up to today i.e. 2015-11-13, I have around 900 rows.

I have a Fact table ABC_Master that houses all the master attributes such as County, Region, Market etc.

How do i go about adding the "Date" dimension. All I require is that the users to be able to drill down
the data to a particular date / day. I would not require the time dimension.

This might sound like a basic question, however this is my first attempt at creating SSAS Cubes so
any help would be much appreciated.

推荐答案

你好，



你需要创建一个表为您的日期维度。您可以自己创建一个，也可以使用SSAS向导为您创建一个。如果您的日期具有财务映射或企业特有的其他逻辑，则最好自己创建并填充表。



完成后，将表格添加到数据源视图中。表格在数据源视图中后，您可以创建新维度，并将其链接到您的事实表。

Hello,

You will need to create a table for your date dimension. You can either create one yourself, or use SSAS wizard to create one for you. If your dates have fiscal mappings, or other logic unique to your enterprise, you would best create and populate the table yourself.

Once complete, add the table to your data source view. Once the table is in your data source view, you can create the new dimension, and link it to your fact table.

这篇关于需要在我的SSAS多维数据集中添加日期维度。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！