IP - Issues with Input Query: Works on Bex analyzer but not on Web

I am doing the following:

Created a Aggregation level for a multi provider which has only real time infoproviders associated with it

Created the query using Bex Query Designer availing all the options for planning

When I execute this query it executes using a web template and does not open up the Key Figure cells for input, I had tried using the Web Application designer with Save button but still the same issue

I tried the same on Bex analyzer and it works fine

Please help to resolve the above issue.

Thanks in advance.