David Boot-Olazabal

Hi, Could you share an example dxp file? Kind regards, David

Hi Marlina, To be able to use the shared drives, you must use UNC mentioning. For example, instead of: T:\finance\Dashboards\Spotfire\PDF\ You need to use: \\cloudserver1\shared$\finance\Dashboards Spotfire\PDF Make sure you use a shared network drive for which Spotfire's service account has read/write access. In your 2nd example, you tried to use a C-drive. But as the automation job service is carried out via the server, the system tries to use the C-drive of the Node Manager that 'holds' the automation services instances (instead of your own C-drive). See also this article for more information of the above: https://support.tibco.com/s/article/Unable-to-save-PDF-to-different-location-using-Export-to-PDF-in-TIBCO-Spotfire-Automation-Services. What you can do, is to create a PDF folder on the Node Manager server (e.g. 'C:\Spotfire\PDFExports\') in which you store the pdf's to be added on to your sent email task. If not possible, then the shared network drive using UNC mentioning and proper access for the service account running the Node Manager on which Automation Services is installed should do the trick. Also, make sure that the Node Manager config is setup to support sending emails, otherwise your next task will result in an error. See also this explanation: https://docs.tibco.com/pub/spotfire_server/14.0.4/doc/html/TIB_sfire_autsvcs_UserGuide/autoservices/topics/adding_smtp_settings_to_the_spotfire.dxp.worker.automation.config_file.html Kind regards, David

Hi Sophia, Some of the settings, like font and font size for the axis can be altered via the menu Visualizations -> Canvas Styling -> Edit custom themes: The other settings are hard-coded into the mod. Any changes to that, would require changes in the source code. As it is available on our github site: https://github.com/spotfiresoftware/spotfire-mod-area, you can access it, make a fork and perform the changes you need. Kind regards, David

Hi Marlina, I see. As you select the visualizations, they are stacked in one row, below each other in stead of how you have formatted the layout in the analysis. You could export your page in pdf format, that would basically include everything you see in the same order. This means an extra step in your automation job, as you need to include the 'Export report to pdf' task: You would add this pdf file in the send email task, via the 'Attached files' box: There are two things to bear in mind: - you need to create a report first in pdf format: https://docs.tibco.com/pub/sfire-cloud/latest/doc/html/en-US/TIB_sfire_client/client/topics/en-US/preparing_a_report.html; - the pdf is gong to be exported to a file location, make sure this is a network folder the Spotfire Server account has access to, otherwise it cannot be located to add to the Attached files box. As an alternative, you can also use our Alerting Framework for Spotfire to achieve the same. The Alerting Framework is built on top of the automation services, but gives you a couple of advantages. You can find more information here: Kind regards, David

Would it be possible to share some screenshot on how the prompts are setup in the Spotfire connection to SAP HANA? Kind regards, David

Hi, I would suggest to use a color scheme to accomplish this. You have to save your preferred color scheme to the library first. You can do this by clicking here, when applying a fixed color scheme: Once you saved it, you can then apply it to a visualization by using this iron python script: It is also possible to leverage a color scheme from another visualization: Kind regards, David

Ah ok, I see. So, your current prompt loads both 2024004 & 2024005 periods (and the sum of their values). How have you defined your current prompt in the connection to SAP HANA? And would you have the same issue if you used a data on demand for this connection? Kind regards, David

Hi, Do you also receive the value of 600 in your analysis? Or is that value tied to the FiscalPeriod in SAP HANA? If it's the first case, you could use a calculated value to replace the FiscalPeriod with the Value. If it is the second one, isn't there a way in the connection parameters, like you have in SAP BW, to load both FiscalPeriod and Value? Kind regards, David

Hi Marlina, Nice visualizations! May I ask you how you have setup the email content? I assume you use the automation services job builder. And what do you want to share in the emails? As it looks to me, you have defined various visualizations as content, but from your Spotfire screenshot, there are more of them (slide 2), as well as filters and legend (slide 1). Do you want everything to be added in the mail content? Kind regards, David

Hi Mahesh, Not sure if this got resolved. I do hope so, since it goes a long way back. May I assume you have the same problem? If so, can you share the issue, error message, etc.? Kind regards, David

Hi Prashant, In that case, I would advise you to create an enhancement request via https://ideas.spotfire.com/. Kind regards, David

Hi Bony, Can you also tell us what kind of version of Spotfire you are using? Kind regards, David

Hi Marlina, When do you get the error message? Is that when running the iron python script? Or is it when you try to reset the date? Can you share your scripts, as well as your property control expressions? Kind regards, David

Hi Jiangyi, I appreciate the feedback. And yes, the session_id is used to capture more than only the load of one dashboard. Which makes it hard to pinpoint a single dxp. I do hope our support team can help you with a more detailed query, to find the information you're looking for. Kind regards, David

Hi Kinimod, Below is an example of pushing a value (in this number of rows from a single data table) into a document property: # Import Class from Spotfire.Dxp.Data import * # Set variable for table name tableName='Data Table' # Set variable for column name in the table columnToSearch='Year' # Assign "Mapping" table as active table activeTable=Document.Data.Tables[tableName] # capture marking and set value of "Year" column to CellVal document property rowIndexSet=Document.ActiveMarkingSelectionReference.GetSelection(Document.Data.Tables[tableName]).AsIndexSet() if rowIndexSet.IsEmpty !='false': CellVal = Document.Data.Tables[tableName].Columns[columnToSearch].RowValues.GetFormattedValue(rowIndexSet.First) # Pass CellVal and Catval Variable value to document properties Document.Properties["Year"] = CellVal In the example above, 'Data Table' is the name of my Data Table. 'Year' is the column I want to push to a document property, called "Year". When I run this code, the Document Property Year is filled with 2023 (as that was my marked year): And here is another example you can look at: Once you have a document property, you can display it in a text area, using a label property control. Kind regards, David