6 Replies Latest reply: Feb 24, 2011 10:42 AM by subashsivaji RSS

    Simple information

    frankmed

      Please can i have any informations of Qlikview ? What's a platform architecture needed ? Characteristic of Workstation, ram, disk and other What's a price ? what's the political licensing ? What are the possible connections, is possible to connenct SQL SERVER (and which version ?) is possible to connect at OLAP Cube in Analysis Services ? And is possible to have quantification of stress test (How many row elaborated ?)

      I could testing the connection to SQL Analysis Services with downloaded version ?

       

      Thanks

        • Simple information

          Hi, answering your questions

           


          frankmed wrote:
          Please can i have any informations of Qlikview ?


          Sure, check this community, www.qliktech.com or get in touch with your local distributor/partner

           


          frankmed wrote:
          What's a platform architecture needed ? Characteristic of Workstation, ram, disk and other


          To develop, Windows based machines (XP, Vista, Seven, Server 2003, Server 2008 etc)
          To deploy, Windows based server (2003, 2008 etc)
          To view/analyze, Windows based machines just if you want to use the ActiveX for IE, if you don't, the ajax client works in any platform/browser

          The characteristic of the PC, depends about the size of your models, number of records etc....

           


          frankmed wrote:
          What's a price ? what's the political licensing ?


          Ask for commercial support, but a small server with 10 users (CALS), it's around 10.000 USD

           


          frankmed wrote:
          What are the possible connections, is possible to connenct SQL SERVER (and which version ?) is possible to connect at OLAP Cube in Analysis Services ? And is possible to have quantification of stress test (How many row elaborated ?)


          You can connect to any database if you have the right driver (by ODBC or OLEDB), but also can retrieve information from XLS, CSV, XML, HTML etc etc... any file with a defined structure

           


          frankmed wrote:
          I could testing the connection to SQL Analysis Services with downloaded version ?


          Yes, Personal Edition (P.E) only has restrictions about open QlikView Files (qvw), from other P.E or a licensed user, and some other functionalities like import layout

          Check the online courses (there are some free ones), to start with the software, that will help you a lot.

           

          Hope this helps

          Rgds

           

            • Simple information
              frankmed

              Thanks for all, perhaps Qlikview gain a new fans if i to be able to configure in the downloaded version the connection to MSSQL OLAP Cube.

              And sorry, if i search server in the possibilities "OPEN FROM SERVER" how do configuring a driver MSOLAP ?

              Another thank

                • Simple information

                  Hi

                  The steps are:

                  • Create a black document (New File, save as..)
                  • Go to the script editor (Ctrl + E)
                  • At the bottom left you will se a radio option, ODBC/OLEDB choose one option
                  • Press the Connect button and choose the source/driver for your connection
                  • Then, pressing the Select button, the wizard will appear and you can select the tables/views (this can be achieved also typing the query by yourself)
                  • Press the Reload button or Ctrl + R
                  • Then, the records will be retrieved and you can start make the objects

                  Hope this helps

                  Rgds

                    • Simple information
                      frankmed

                      Thanks so much, now is simple.

                      Best Regard

                      • Simple information
                        subashsivaji

                        Hi Hector,

                        I am trying exactly the same thing loading a MSOLAP into QlikView. The test connection is success and able to select data... but I am not able to retrieve the records. I get "script error".

                        My script as follows:

                        OLEDB CONNECT TO [Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Altius MIS Cube;Data Source=mis;Location=aclappserve1];

                        SQL SELECT *
                        FROM [Altius MIS Cube].[$Date];

                         

                        When I do reload I get the Script Error.

                        Kindly guide me to sort this out. I am using QlikView 10 (32 bit version) and drivers with same versions

                         

                  • Simple information
                    s j

                    you can also connect to SAP R/3,SAP BW,Salesforce system.