Foreach in Refdata
I am not able to read data,through FOREACH IN REFDATA.As per my information Reference data is the one, which is not present in your current filter selection but it can be used for reading.
In my infoprovider i have the data with two versions(version1 and version5). I have two layouts,each is restricted with individual versions. In my cube I've data as follows:-
Project1, WBS1, VERSION1.
Project1, WBS1, VERSION5.
Project2, WBS2, VERSION5.
Now I want to copy all the data from version5 to version1,irrespective of all the characteristics combination,if the characteristics combination exist in version1 ,it should overwrite the keyfigures,
it should append the rest of the records.
1)My First Observation is:-
I have restricted the filter with version1,but not able to read version5 with foreach in refdata.
2)My Second Observation is:-
If i'll restrict the filter with both the versions or remove the version from filter ,I'll be able to read data for both versions with foreach in refdata but if i'll open my both layouts at the same time,there is no lock but as soon as i'll use the planning function to copy i'll get the lock.
I want to restrict my filter with one version and read the data for another version using refdata,so i'll not get lock.