{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 手持菜刀，她持情操 的问题《Use CSV or Text file as a data source for SSAS cub》','https://www.manongdao.com/q-1135426.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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.
相关问题
- How to calculate the likely size of an OLAP cube
- Distinct count to exclude NULL
- DateAdd Column caused an overflow
- SQL Analysis Services OLAP TIME dimension
- SSAS dimension processing makes underlying measure
相关文章
- Use VBA to select and deselect multiple slicer ite
- Process SSAS cube through c# code
- What should I have in mind when building OLAP solu
- Benefits of using Staging Database while designing
- Can OLAP be done in BigTable?
- C# amo get roles complete
- SSAS tabular model timeout raised during processin
- MDX - TopCount plus 'Other' or 'The Re
I've never really tried this, but I think this is possible if you have the ACE provider.
Source: Connect to a Flat File (SSAS)