techg Posted June 25 Share Posted June 25 Hi , Is there an option to read the Prompt values from Hana view as Data source in Spotfire Analysis. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted June 25 Share Posted June 25 Hi, You should be able to do so. Here is the information you can use to set up prompts in your connection to HANA: https://docs.tibco.com/pub/sfire-analyst/14.4.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connectors/saphana/saphana_connecting_to_information_views_from_sap_hana.htm Kind regards, David Link to comment Share on other sites More sharing options...
techg Posted June 25 Author Share Posted June 25 Thank you. I have set up prompts in the connection to HANA using the 'Define Prompting' option as shown in the link. After consuming the connection in Spotfire Analysis, it prompts for the input values, for example, if we select the period as 2024004. My question is: how can I read the selected input prompt values in Spotfire Analysis?" In Analysis i should display the value as 2024004. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted June 25 Share Posted June 25 Hi techg, You say that you can define the prompts on the connection and you see the prompts when loading the data. You then can select the period 2024004 and the data gets filtered. Is that correct? As I'm not sure if I understand your question "how can I read the selected input prompt values in Spotfire Analysis?" In Analysis i should display the value as 2024004. ", can you elaborate a bit more on that? kind regards, David Link to comment Share on other sites More sharing options...
techg Posted June 25 Author Share Posted June 25 For this scenario the data from the Hana view shows the period selected 2024004 and the previous period 2024003. So in Analysis we need to display the data based on the period selected in the prompt as 2024004. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted June 25 Share Posted June 25 Right. But is there something blocking you from either selecting or entering that 2024004 period in the prompt? Or can you enter it, but it doesn't work? In any case, could you also share some screenshots to make the case more clear of what you are trying to do and what is working? Kind regards, David Link to comment Share on other sites More sharing options...
techg Posted July 1 Author Share Posted July 1 Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted July 1 Share Posted July 1 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 Link to comment Share on other sites More sharing options...
techg Posted July 1 Author Share Posted July 1 In Analysis am getting both the value of 2024004 & 2024005 as 1100. But i have to include a condition to show only the selected prompt value as 2024005 as 600 only.In BOBJ we have userResponse function to display the selected Prompt values. Do we have any such option in spotfire. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted July 1 Share Posted July 1 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 Link to comment Share on other sites More sharing options...
techg Posted July 1 Author Share Posted July 1 Yes, the current prompt loads the value for bot the periods.The Prompt is created in Hana view itself. While creating the Hana connection in Spotfire we used Defined Prompting Option. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted July 1 Share Posted July 1 Would it be possible to share some screenshot on how the prompts are setup in the Spotfire connection to SAP HANA? Kind regards, David 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