Do we have a CSV or text file as a data source for SSAS cube, I work with a lot of data I keep the SSAS cubes (ROLAP) for the same analysis. Data (~ 2GB) comes in the form of a formatted text file every hour that I upload to a DB that acts as a data source for the cube. Cube then receives this data from DB and processes it. I would like to use the text file directly on the cube, it can save a lot of time.
I never tried this, but I think it is possible if you have ACE provider .
To connect to a flat file, the ACE provider must be installed on your computer.
Source:
No comments:
Post a Comment