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 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)
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
Did you find a solution for this? I have a similar issue, so if you managed to solve it, could you maybe post the script for the view you used?
Best regards.
