Dear friends,

I am trying to consume data from SSAS cube over a SSIS package. Concerning this, I created an OLE DB Provider for Analysis Services 12.0 connection type which is connecting to that Cube. It has connected to Cube successfully. Also I am able to see whole Dimension tables. HOWEVER, problem is that I cannot see fact tables. It just displays me dimension table. Normally, I have permission to get all fact table data. To test my permission, I've connected to that Cube over Excel and was able to see entire tables including fact and dimensions. Now, I am really confused.. Why can't I see that facts?? 

Thanks in advance.

Hi Arthur, thanks for you answer. However, I have just one account and using for both Excel and SSIS. I can see fact data in Excel but cannot in SSIS. Also, this is an external company's Cube. They gave me just one account. I've contacted them and they tried to solve this issue but could not overcome. Now, I am worrying is this a problem from my side or from their side. Am I missing something?

Thanks in advance.

Are you sure you are using the same MDX query in both places?

David

Hi David, I am not using MDX query to fetch data. On Excel side, I use connection by selecting "From analysis Services". SSIS side, I a use "OLE DB Provider for Analysis Services 12.0". 

Excel side, I can see fact sales data.However, SSIS side can see just dimension table no FACT DATA. 

I did nothing with MDX yet. 

Both SSIS and Excel are communicating with SSAS by sending MDX queries. In an multi-dimensional cube the measure groups don't really exist apart from the dimensions.  So you must specify which dimension you want to retrieve the measures across.

David

Hi Arthur, thanks for you answer. However, I have just one account and using for both Excel and SSIS. I can see fact data in Excel but cannot in SSIS. Also, this is an external company's Cube. They gave me just one account. I've contacted them and they tried to solve this issue but could not overcome. Now, I am worrying is this a problem from my side or from their side. Am I missing something?

Thanks in advance.