Date as keyfigure in Input ready query

[Former Member]

Hi Folks,

I have created a input ready query on transactional infocube.

Its working fine and able to input for keyfigures except one keyfigure it is Date Keyfigure.

I just created one more keyfigure with Datatype as Date so that user will able to enter date aswell in input ready query.

but problem here is I have done same changes/enable for the date keyfigure like remaining keyfigures.

in query anylazer i cannot see input enable for the particual date keyfigure.

please let me know what are the steps need to do extra for the particular date keyfigure to make enable for input..

Thanks.

[Former Member]

Hi,

I dont think Date KF can be input reay; planning system creates delta recods for changes done to KFs - this cannot be done for dates.

[Former Member]

Hi,

Thanks for your response.

if it not happened by IP is there any other option available to update changes in to DSO/Infocube.

one more thing.I have a created one Multiprovider on the transactional DSO then i created query on the multiprovider,but in query designer i cannot change the option to change mode for the keyfigures.its in display mode only.

why it is not enabled.is there anythying missing to do..

Thanks..

[Former Member]

Hi,

Using an input query, data can only be written back to a real-time cube, no DSO.