Issue with APD

[Former Member]

Hi,

I have created an APD with a Query as a source and Direct Write DSO as a target. When i am trying to do the mapping, for all the key figures in the query i am NOT getting either the TECHNICAL NAME NOR THE DESCRIPTION. It is giving a weird string something like

4D43SKP....................... What can I do to see either the technical name or the description.

Thanks

Rashmi.

[Former Member · Accepted solution]

Hi Rashmi,

If the string you have mentioned is coming for the query, then it might be the UID of the query. You can check it by opening the query in Bex query designer. Go to Properties of the query -> go to advanced tab -> you can find the UID of the query. you can check whether the same string exists in the designer and your APD.

So, the string you mentioned 4D43SKP....................... is nothing weird.

If you are getting the string for the KFs, then you can go to KFs individually and check their properties. You can check it by selecting each KF and check their properties by going into advanced tab of the KF and there you can find the UID. you can check whether your string and this UID are the same.

Let me know incase of any more questions

Regards

Sunil

[Former Member · Accepted solution]

Thanks a lot, I am able to map all the key figures now but when I am executing the query its giving me the following error,

Query metadata is not complete

Any idea what it means and how it can be resolved

Thanks

Rashmi.

[Former Member · Accepted solution]

Hi Rashmi,

You can check whether the query is consistent or not by running the query in rsrt.

REgards

Sunil

[Former Member]

Hi Rashmi,

Check the following notes: 973676, 1044392 and 605208.

also these threads could help you.

hope this helps

Regards,

Rk.

[rathy_moorthy2]

Hi,

Maybe it is a ckf or rkf with multiple components. In the APD, right click on DSO and check 'display data'. And then compare with ur query analyzer output to determine the field name.

Hope it helps.

Regards,

Rathy