使用CSV或文本文件作为SSAS多维数据集的数据源 [英] Use CSV or Text file as a data source for SSAS cube

问题描述

我们可以将CSV或文本文件作为SSAS多维数据集的数据源吗? 我处理大量数据，并维护SSAS多维数据集(ROLAP)进行分析. 数据(〜2 GB)每小时以格式化的文本文件的形式出现，我上传到作为多维数据集数据源的数据库中.然后，多维数据集从数据库中获取此数据并进行处理. 我想直接使用文本文件处理多维数据集.这样可以节省很多时间.

Can we have a CSV or Text file as a data source for SSAS cube. I deal with lots of data and maintain SSAS cubes (ROLAP) for analyzing the same. The data(~2 GB) comes in every hour as a formatted text file which I upload to a DB which acts as a data source for the cube. The cube then fetches this data from the DB and processes it. I would like to process the cube directly using the text file. This can save a lot time.

推荐答案

我从未真正尝试过此方法，但是我认为，如果您拥有ACE提供程序，这是可能的.

I've never really tried this, but I think this is possible if you have the ACE provider.

要连接到平面文件，必须在计算机上安装ACE provider.

To connect to a flat file, you must have the ACE provider installed on your computer.

来源:连接到平面文件(SSAS)

这篇关于使用CSV或文本文件作为SSAS多维数据集的数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！