Forum Discussion
Output DAX Evaluate results to a SQL Server Database table
Ok so that does make sense.
Only issue is how do you format such a query in sql server? how can I refer to an SSAS server instance/model to point the query at?
create view vw.DAX
as
Evaluate( xyz )
Thanks, your helps been very appreciated thus far parry2k
Anonymous not sure fully what you mean by pushing DAX result out. You can sure DAX Studio tool and run DAX expression there and it will show you the output, although I'm not sure if there is option to export the result set or not.
But in general this approach doesn't seems right.
thanks for the reply parry2k
So yes what I need is the results of that DAX query to be exported/pushed into a sql table. Is there not a way of pushing the results into a sql temp table or any table in a database?
Reson I need to do it this way is my software app can't connect to SSAS to retrieve the results but can connect to a SQL server table to read the data. The idea is to output the aggregated results of DAX into a SQL Server table
Anonymous hmm still this doesn't seems to be the solution, I'm sure SSAS has some data source that should be your source for your app, and you shuld be converting DAX into Views and use that in yrou APP, rather exporting DAX to SQL Server. This all doesn't make sense even though you want to do it, just a suggestion and my feedback.
Sorry how do you mean 'Views'? are we talking SQL Server table Views?
Anonymous yes, and reason I mentioned that because you can have business logic in those views (translate DAX in those views)