If you want to use variable pop up with SAP HANA you have to join design studio straight to a HANA view with the help of ODBC middle ware. If you want to launch design studio and to find the database in the design studio tools or tools or backend connections page you would have to make subsequently setting of the HANA ODBC . It will be essential to reload connections button as sometimes there can be possibility if your connection does not appear. Now you have to add a data source that connects with your database to select the appropriate view. You should have to go back to the main page to add the data source. Later on you have to click on the new data source you would be able to edit the initial view and at the same time you have to create a simple crosstab that will contain a information.
At the starting of the view page you will get few options so that you can choose dimensions in the rows and some measures in the columns of the crosstab. As soon as you finished , you must click “OK and then create crosstab” . Now cross tab will be displayed in the dashboard blank page and please remember that cross tab will be empty at that time and meanwhile you will see an error which will show that it is not able to find any data.
Now if you want to select the currency and if you want to send the information to the dashboard you will have to add a component and now you can easily drag a combo box component on the canvas and then you have to click the item button to add them to it a few simple currencies . Please be sure that the combo box column contains the correct currency codes.
Hope this article might help you in understanding variable pop up with SAP HANA.