I am connecting just to the database, I am building new "OLAP cube" in QV(if you have the DWH built properly, it's not much work I think), so I don't know, if mdx is supported in QV.
To connect to MSSQL use New ODBC Source - SQL Server (you have to login using windows authentication, otherwise it would fail) .
Thanks for the info. While creating the ODBC we need to select Sql sever - pl confirm . Also you mentioned u are creating OLAP cube in QV - can u explain pleease (is it the qvd files.)
Sorry for late answer. Yes, you choose SQL Server in New ODBC Source, then you have to choose Windows authentication (with SQL server authentication, it doesn't work).
You are building the cube by connecting fact table to dimension tables (if you need snowflake scheme, you can connect dimension tables and then use Qlikview qroups, then the illusion of OLAP is perfect).
Only risk is correct interpretation of aggregated numbers.
On the png attached - f_pom_prijmy, f_pom_vydaje, t_faktury, f_kontrakty are facts tables, the rest are dimension.
This is exact copy of prepared tables (structure prepared on SSID), I've designed in SQL Server, and then analyzed in Analysis Services.
You can load the data from SQL server or another source. Qvd files are just place, where you can store one qlikview table for later usage.
