SSAS Cube calculated measures - send back to relational data source

Question

Hello team, i have a scenario below

My cube source is Netezza which is a data mart. we do some calculations in the cube and want to send back the calculated data back to Netezza as some output columns, which will then push the data via ETL to SFDC.

Is there any out of the box feature that does that or any alternate ways to do it?

Otherwise, i have to do the same calculation in Netezza to feed those calculated values back to SFDC.

Any info is appreciated. TIA

---

Regards, KarthikShanth. "Mark as Answer" if this helps you! <p style=""><a target="_blank" href="http://feeds.feedburner.com/~r/karthikshanth/~6/1"><img src="http://feeds.feedburner.com/karthikshanth.1.gif" alt="Shanth's techwitz" style="border:0"></a></p> <p style=""><a href="http://feedburner.google.com/fb/a/headlineanimator/install?id=91i2ausjr5mqq9fu4im39uvnvo&w=1" target="_blank">↑ Grab this Headline Animator</a></p> Disclaimer: The contents, I write here are my personal views, not the view of my employer and anyone else.

Answer 1

Hi Karthikeyan,

Thanks for your question.

According to your description, you want to write the calculated data back to Netezza, right?

As far as I know, It is imposssible to do so. As the calculated data are aggregated data, which should be stored as a new table, not output columns. With SQL Server, you may try to use open query to store the query data as relation database table.

See below blogs:
https://sqlblogcasts.com/blogs/drjohn/archive/2008/09/27/mdx-and-sql-combining-relational-and-multi-dimensional-data-into-one-query-result-set.aspx
http://www.dataprix.com/en/blog-it/mdx/how-use-openquery-make-join-between-ssas-cube-and-table-any-other-database

However, I do not think this will work for your data source Netezza.

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]