Locking Keyfigures in input ready queries based on characteristic conditions

[Former Member]

Hi All

I have a input ready report in WAD where I have to lock the fields according to a particular status. Basically we have different users accessing the report and only certain rows based on status should be input ready and others should be locked for input.

Please let me know how this can be implements and steps to do this if possible

Thanks

Preethi

[Former Member · Accepted solution]

Hi,

you can use data slices to achieve your requirement

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/43/1c3d3f31b70701e10000000a422035/content.htm

hope it helps.

[Former Member · Accepted solution]

Thanks for the response.. is there any sample code i can refer to for the class?

[Former Member · Accepted solution]

Hi,

There is no code needed, just run the modeler and create a date slice and activate it for the concerned infocube.

hope it helps.

[Former Member]

Hi

I have another question... I have a requirement to assign unique ID to each record being inserted into cube. I create a number range for this purpose and what i want to do is read buffer , assign the number from number range and then write back to buffer .... so that the sequence continues and data is written to cube with the assigned ID.

Can someone help me out as to how i can achieve this!!