1 Reply Latest reply on May 4, 2016 1:13 AM by apirak khemapirak

    Tableau 9.3 Performance problem when Extract with SAP BW

    apirak khemapirak

      Hello everyone,

       

      I have the following problem, when I try to extracts data source From SAP BW in Tableau Desktop 9.3

       

      I already  have a special license key for Extract data from SAP BW and Extract Success with Very Small Cube (1 Measure 1 Dimension 6 Record)

       

      but when tried  Connect to Bigger Cube (2 Measure 3 Dimension 890 Record) I spend time more 1 Hour for wait it Execution and Not finish

       

       

      After that I use Another tool  (Competitor of Tableau and not SAP Tool) to connect and load data to in-memory (Like Tabelau Extract)

      with same Cube it Finished in 5 Sec

       

      I don't know what is the Core of Problem.

        • 1. Re: Tableau 9.3 Performance problem when Extract with SAP BW
          apirak khemapirak

          Yes!! I can do it now.

           

          Because my SAP/BW Cube have 10 Dimension and 2 Measure

           

          and when connected i will Select "Hide" on fields if i don't use it.
          But It use more 1 Hour for run Extract

          BW Cube.png

           

          Today i test by Create Bex Query to That cube and Select Just field i use
          and clear anything in "Free Characteristics" Panel then save to "Billing_test_query"

          Bex Query.png

          and  Connect to that Bex Query instead. (Ref "Connect to Bex.png")
          It Success in 5 Sec lol!!

          Connect to Bex.png

           

          i think the Core of Problem is the Tableau MDX not Dynamic with "Hide" Field