Gabriel Yeong Posted April 17, 2020 Share Posted April 17, 2020 Hi all, I have been exploring TIBCO Spotfire for a while now. One of the main uses of TIBCO Spotfire I use it for is to extract reports on pre-determined dates. For eg. Opening the Information link allows me to select Upper and Lower Limits of the date I want to extract for 2 days prior (e.g Upper and Lower limit = 15 APR 2020). To better supplement the analysis of data, I will include a new column as a "Vlookup" by attaching an Excel file. In my context, all data in Spotfire are in Countries eg. JAPAN, while my Excel file has a list of entries to VLOOKUP against. (JAPAN -> North Asia). However, this involves a series of steps: Select dates I want in Spotfire (Upper and Lower Limit) Add said Excel file in Data Canvas(This is for the reference) by using the + function Add Columns, and select the common header Once data is populated use Cross Table Change the Headers, add subtotal, change formatting of numbers to include 1000 separator, etc On a daily basis, I have to repeat the steps to extract data 2 days prior. Alternatively, I was recommended to add the Excel file, change data properties of the Excel fileand change to "embedded in analysis". I tried this option and saved the file in .dxp format. However, whenever I reopen the file, I no longer have the option to key in the Upper and Lower limits. There is no prompt from the .dxp file. Meaning to say that I only have data based on when this .dxp was last generated. Is there any way I can retain the date prompts of the information link, while having the Excel file embedded in the data for the added vlookup columns Your inputs are greatly appreciated! Link to comment Share on other sites More sharing options...
Erik Jalsborn Posted April 21, 2020 Share Posted April 21, 2020 Hi, You can choose to only embed/store the data of the excel-file while still going live to the information link each time you open the analysis. It is done in the data canvas, see attached screenshot. (Can also be done when saving the analysis the first time) Link to comment Share on other sites More sharing options...
Gabriel Yeong Posted April 22, 2020 Author Share Posted April 22, 2020 Hi ejalsbor Thanks for your input. After embedding the data as "Stored Data in Analysis", do I save it as a .dxp file Reason I'm asking is because after doing so, I no longer have the option to select the dates I want from the main data source. As above, when going the usual route of opening the information links, I will be prompted with the lower and upper limits of the dates I want to use. For eg. I will select Apr 20th for both lower and upper limits, and the data will be populated based solely on Apr 20th. After embedding the excel file, this pop up no longer appears. Openig that .dxp file only loads the information relating to the date where I last saved opened and embedded the .dxp file. Can you please advise Thank you Link to comment Share on other sites More sharing options...
Erik Jalsborn Posted April 22, 2020 Share Posted April 22, 2020 Hi again, Yes you save it as a DXP-file, but you also need to tick a checkbox in Data Table Properties: "Prompt for new settings before loading", see attached screenshot. Link to comment Share on other sites More sharing options...
Gabriel Yeong Posted April 22, 2020 Author Share Posted April 22, 2020 Thank youejalsbor! It works now! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now