2 Replies Latest reply on Jun 26, 2018 3:34 AM by Shiva Karadi

    Tableau integration with SAP BW (Issues with Bex variables & Multiple BW sources in report in Tableau)

    Shiva Karadi

      Hi Team,

       

      Could you please help with below questions?

       

      1. Variables:

      a. Unable to enter multiple values for “Several Single value variables”

      b. Default values - Not all variables having default values from BEx are showing up in Tableau.

      c. Some of the variables available in BEx are missing in Tableau report.

       

      2. Multiple BW sources in report:

      a. When more than one BW source is being used in the report, it prompts the user to enter the User Credentials those many number of times.

      (Eg: if we have 2 BEx queries in the same report, when we open the Tableau report for the first time, it is prompting the user to enter the credentials two times)

      b. Variable screen doesn’t show up by default when we have more than one BEx queries. Every data source has to be selected to open the variable window.

      c. Variables are not being merged if there are common variables in the queries.

       

      Please let me know if you require more information on these questions.

        • 1. Re: Tableau integration with SAP BW (Issues with Bex variables & Multiple BW sources in report in Tableau)
          Shiva Karadi

          One more Question

           

          3. Radio Button/Buttons:

          Standard procedure of creating Buttons/Radio Buttons is not supported for BW sources.

          If yes,Please let me know the procedure?

          • 2. Re: Tableau integration with SAP BW (Issues with Bex variables & Multiple BW sources in report in Tableau)
            Shiva Karadi

            Please find the answers:

             

            1. Variables:

             

            a. Unable to enter multiple values for “Several Single value variables”

            Tableau does not initialize the  variables type  "multiple single value" , you can enter values as usual, but you don't see the default values established by the BW view designer.

            b. Default values - Not all variables having default values from BEx are showing up in Tableau.

            Variables in default level are missing.

            c. Some of the variables available in BEx are missing in Tableau report.

            Variables in column level are missing.

             

            From Question 1a & 1b, we find Tableau is not supporting column level and default level variables. So they are missing.

            We observed that Hierarchy variables are missing in Tableau.

            Tableau is supporting only filter level variables.

             

             

            2. Multiple BW sources in report:

             

            a. When more than one BW source is being used in the report, it prompts the user to enter the User Credentials those many number of times.

            (Eg: if we have 2 BEx queries in the same report, when we open the Tableau report for the first time, it is prompting the user to enter the credentials two times)

            Not yet found any information.

            b. Variable screen doesn’t show up by default when we have more than one BEx queries. Every data source has to be selected to open the variable window.

            Variable window is showing by default after log-in. No issues here.

            c. Variables are not being merged if there are common variables in the queries.

            Since we are using  two different data sources it is showing two different variable window.

             

            3. Radio Button/Buttons:

            a) Standard procedure of creating Buttons/Radio Buttons is not supported for BW sources.

            Not yet found any information.

             

             

            Finally,

            Below 2 are open points, could anybody answer?

             

            2. Multiple BW sources in report:

            a. When more than one BW source is being used in the report, it prompts the user to enter the User Credentials those many number of times.

            (Eg: if we have 2 BEx queries in the same report, when we open the Tableau report for the first time, it is prompting the user to enter the credentials two times)

             

            3. Radio Button/Buttons:

            a) Standard procedure of creating Buttons/Radio Buttons is not supported for BW sources.