We are trying to load data from SSAS. Since this is using MDX, a different approach is needed as opposed to 'simple' SQL.
The data can be loaded using MDX queries in QlikView using the very nifty software by xthview: Downloads | xthView
However, the syntax produced does not work in Qlik Sense.
Does anyone have any experience/pointers as to how to approach this issue? Right now the data is generated in QV, sent to QVD, and picked up bij QS, which obviously isn't a very pretty/sturdy solution.