Bex analzyer layout changes form input ready to Non-input ready.

[Former Member]

Hi gurus.

I have an interesting situation after I created an input ready Bex layout.

First of all, when it was created in the Bex Query analyzer, under the 'Planning' TAB, I have flagged the radio button for 'Data can be changed using user entries or planning functions', for each other columns.

Secondly, my transactional cube is marked under the option Change 'Real time load behavior', as 'Real time data target can be planned; Data loading NOT allowed'.

And finally, when I go into the layout, it still doesn't show me that it's input ready, so I go into Query properties, under 'Display options', I select and flag 'Allow entry of Plan values'.

This makes it input ready!

However the problem arises, when I leave and log out of the Bex Analyzer or even just close that layout, then sign back into the layout, the layout returns to being "Non-input ready". This forces me to keep going into the Query properties to make it input ready all the time I go out and come back into the Bex layout. I don't want the user to have to keep doing this every time they go in and access the layout.

What am I missing, or what do I have to do, so that I don't have to keep going into the Query properties to make it 'Input-ready'??? Anyone had this issue before?

Appreciate your help with this very much.

Thanks.

[Former Member · Accepted solution]

In the query properties have you set Open query in Change mode?

[Former Member · Accepted solution]

Hi Deepti,

I knew I was missing something. Thanks for that, it's fine now.

[Former Member]

Ehab Mansour

I am face the same problem that I create a input reay query base on a real time infocube's aggregation level and set properties that can input ,but final I excute this query that I can not change data,that is why.

appreicate you help very very