I have been working on connecting the SSAS Cube from Qlikview. I took help of the community to execute the script. Most of the answers shows the adventure works sample query. Based on this here is my Facts and Dimensions.
Total Qty, TEM, Fact Sales Count
Dim Customer, Dim Time, Dim Product, DIM ALIGNMENT ZIP TERR
The above is the structure of my cube. It is a star schema.
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CUBE NAME;Data Source=SERVER NAME(wher my cube is deployed);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SERVER NAME (QV is residing);Use Encryption for Data=False;Tag with column collation when possible=False];