Hi there. It's possible if you are using the normal way of logging in. As of now, I'm not able to reliably automate SSO login. You can refer to the link here to learn more about logging in SAP using scripts. joelting.com/articles/sap-gui-script/login-sap-using-vba/

Hi there. I'm not sure if I understand you correctly. I believe you are trying to send data from different Excel cells into SAP. If my understanding is correct, you can refer to the link below on how this could be done: joelting.com/articles/sap-gui-script/send-data-from-excel-to-sap-gui-with-excel-vba/

Hi there, to create dynamic column headers based on user selections in both slicers, you can have a measure that adds selected and comparator total together. Then create a version table that has relationships with both the selected and comparator tables. Use this version table as a column in your visual. This way, you will see the column header changes according to the users' selection. However, it's important to note that this method has a limitation: you won't be able to visualize variance in the same table, as the version is now being used as a column.

@@sunoklee8803 hi there, yes. Both can do a clipboard copy. For Excel VBA, it would be the copy method on the range. For Python, there could be multiple ways to do so. One way is to use dataframe.to_clipboard function after loading your data into the dataframe.

Hi there. I think for a quick and easy solution, you can try to have a folder sync with the sharepoint site folder. Then just save it in that synced folder and it should automatically be uploaded.

I'll take note of that. Thanks!

Hi Klaus, sry for keeping you waiting, but things have been quite busy at my end recently. I will try to come out with something asap. Any specific topic that you would be interested in?

@@JoelTing Hi Joel, thank you for your response. Have you ever worked with GUIXT on modifying SAP-screens? This is actually very promising, but I only started looking into it. I don't know how far one can get with only the free version, but maybe you have experience here?

@@user-kq2gd1hj9y Nope. I have not work with GUIXT before. I'm probably not the best person to advise on this topic.

@@JoelTing Understood. No problem. I will just look forward to the topic you will bring up. Thanks.

Hi there. You mean to login into SAP via SSO? Or you are not able to establish a connection for SAP script to run?

Hi there, as of now, there does not seems to be a way to have the columns change dynamically based on the measure that is getting displayed. Workaround would be having the "Version" as column in the matrix, then the column name will change according to what you have selected but you will not be able to visualize the variance nicely.

Hey Stefan, thank you for commenting! Thanks for developing and sharing such a useful tool with us! 😊

Hey there, may I know specifically what T-code you are usually looking at for CAPEX analysis and sales analysis?

@@JoelTing thanks for replying . I'm open to anything do what you can do i know you don't have much time i really appreciate every type of information you give us

Thanks for your kind words. Sorry, I have been quite busy recently. I'll see what I can do.

Hi there, this tutorial is about SAP GUI. For SAP Fiori, which I believe it web based, requires a different approach to automation.

Hey there. Did you use "/n" in front of the Tcodes that you are running in the command bar? Eg. "/nKE24"

Hi there. For the column names, it's possible if you don't have a column to compare the variances. I have an example (may differ slightly for your use case) in a different video where you can use VALUES function to calculate the total of selected and comparator and put the version in the column field of matrix visual. kzfaq.info/get/bejne/rsqioJh3vcvZmmg.html

Hi there, not too sure about that. The difference may be coming from different SAP Logon version. Can you check if both of you are having the same version?

Hi there, are you looking to build it in a waterfall visual as well? I believe you can bring in the date table months and it will work just like how the categories are working.

Hi there. Yes, that's possible. Just make sure the sequence of your copy is the correct one. 1) Copy the country in range A2:A4 2) Open the multi select option in SAP for country and click on paste from clipboard button, click on "OK" to close 3) Copy the City in range B2:B10 4) Open the multi select option in SAP for City and click on paste from clipboard button, click on "OK" to close This way, the correct value should appear.

Hi there. Is it possible that the Excel took quite some time to load? There are other alternatives that can be considered to make it work if this specific use case is not working for you.

I made it ! thank you !

If you are using Excel, you can try checking my other videos when automating is VBA. It will be of similar concept, just replace the values in the scripts with values read from an Excel cell (by storing them as a variable).

May I clarify, what was your question?

Hi there. If it is disabled for end user, then there's no way to enable scripting without the admin's help.

Hi there, you can use the following as a reference: Private Declare PtrSafe Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal _ bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long) Private Const VK_SNAPSHOT = &H2C Private Const KEYEVENTF_KEYUP = 2 Sub PrintScreen() keybd_event VK_SNAPSHOT, 1, 0, 0 'Key Down keybd_event VK_SNAPSHOT, 1, KEYEVENTF_KEYUP, 0 'Key Up Pause (0.1) Dim wordApp As Object Set wordApp = CreateObject("Word.Application") wordApp.Visible = True Dim wordDoc As Object Set wordDoc = wordApp.Documents.Add wordDoc.Range.Paste wordApp.ActiveDocument.Range.Paste End Sub Function Pause(sec As Single) Dim t As Single: t = Timer Do: DoEvents: Loop Until Timer > t + sec End Function After pasting, you can just save the word document your own. Hope this helps.

Hi there. Do you have "Show native Microsoft Windows dialogs" enabled in your option?

Hi there, sorry for the late reply. My understanding is that office script is not able to work directly with SAP.

Hi there, you can capture screenshot using "keybd_event vbKeySnapshot, 1, 0, 0" to save this in your clipboard, then "ActiveSheet.Paste" to paste the screenshot in the desired location. My thought is once you are at the screen that you want to capture in SAP, run the keybd_event code, then paste it somewhere and proceed to the next steps.

Hi Nestor, that's not possible if you are looking for automated interaction within SAP GUI. It needs an operating system installed with SAP GUI to act as the intermediaries, that's why PAD is required. Usually, tasks that can be performed on the cloud Power Automate involve setting up triggers and delivering data to the app you desire. Imitating actions on the user interface needs Power Automate Desktop to work.

@@JoelTing Thanks for your response and your videos!!!!

Hi there. What is not working for you?

Hi there. Have you declared the variable before assigning values to it? like Dim lastrow

Hi there. Have you enabled SAP GUI Scripting API under "Tools" -> "Reference"?

Hi there, is a log of what is being passed into the script sufficient for the audit purpose? If that's the case, you can create a text file containing the time of running, the different parameters passed in for the script and the outcome of the script (could be the final file path of the export).

Are you looking at a PDF HTML viewer or something? You can try and check the type of the shell to identify what is it and identify what is the method to interact with it.

I see. I have not heard of that before. I'll also have a look at this software as well. Thanks!