Forum Discussion

temmermans's avatar
temmermans
New Member
9 years ago

SAP HANA DirectQuery change prompt values after selection was made

Hey everyone,   We face the following issue:   We connected to SAP HANA using DirectQuery Mode, we selected the fields we wanted to use and we fill in a Fiscal Year/Period Prompt. So far no issue...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi temmermans,

 

It's hard to reproduce this without data. Could you please do some troubleshooting? Are the data only showing from 2017001 to 2017005 when you want to add items? If so, the data is filtered by that field, which would hide to avoid being changed.

 

Best Regards!

Dale

temmermans's avatar
temmermans
New Member
9 years ago

hi v-jiascu-msft,

 

Thanks for the reply! Yes indeed, the data is only from between the date range entered in the prompt. This works fine, the problem is, how do we now change that selected prompt values (because it is now hidden, we can't anymore:( ) ?

 

Kind regards!

 

Simon