cancel
Showing results for 
Search instead for 
Did you mean: 

Issue while creating Input Ready Query < Not all key fields of can be filled>

Former Member
0 Kudos

Hi Experts,

I would like to create an input-ready query with a comment column.

I have a Composite Provider having real -time aDSO and one real time Comment aDSO.

Comment aDSO is having a char which is marked as Char as KF and real time aDSO is having other KF's.

I have created a query, starting from the Aggregation Level, with KF from real time aDSO and Char as KF from Comment aDSO in column (input-ready).

Then, I have specified in the query designer, for the two key figures, the related infoprovider from which KFs belong.

I have connected this query into an Analysis for Office report but I am able to input data only into the KF from real time aDSO. The Char as KF from Comment aDSO is not input ready.

Please find below the errors I am getting

'Not all key fields of <DSO> can be filled

There are many key fields in the comment aDSO. I dont want to include all of those in my aggregation level.

Could you please advice on the above matter

Thanks

cornelia_lezoch
Active Contributor
0 Kudos

Hi Ankit,

the error message tells you exactly what needs - to be done - you need to fill all key fields from your comment DSO - or you need to take the info objects out of the DSO.

(Gregor has explained why ...)

regards

Cornelia

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Ankit,

Modeling a 'comment aDSO' means that the comment 'lives' on the level defined by the key of the aDSO.

A 'comment aDSO' is a direct-update aDSO, i.e. it has a key and this means that records to be saved have to contain values for the key fields. If the aggregation level does not contain all the fields of the key how should the system know what to save? Observe, that the answer - motivated by cube-like aDSO - to store the initial value in this case is the wrong answer.

So the real question is why your 'comment aDSO' has so many key fields.

The 'comment aDSO' is not a general 'multi-level' comment solution where a comment can be assigned to any cell in the result set of a query; for such a solution you have to use the comment solution contained in BW/4, SP08 and higher, cf.

https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.10/en-US/eef879a25ca940ea996b79c96a...

Regards,

Gregor