export aggregated cube data to CSV using SSIS
Posted on 2014-09-23
I have a large sales cube housing most of our sales Measures and Dimensions. Basically anything I need to get is in there, however I'm trying to build a dashboard view using a tool that uses CSV's which are updated regularly. I have built several using straight SQL or Sharepoint connectors in SSIS but this time I would like to build one that pulls cube data based on common dimensions (say the current fiscal month or year). Does anyone have a good tutorial on what tools in the Toolbox I would use to facilitate that? So far I only have a OLEDB connector that connects to the Cube, but I cannot figure out how to do something as simple as transform the current fiscal year data into a single CSV field? I do know how to do the Flat File destination, it's just the part from the Source to the Flat File I'm clueless on. Any help would be greatly appreciated.