Some calculated columns on BEx report are showing no value

[erdem_sephanelioglu]

Hi gurus,

What is weird to me and happened for the first time when I run the Bex query,

I must see the figures while it shows no values. I also run the rsrt with Execute with Safe Mode

I have the identical result.

I can not find any solution or moving point and kindly request your help on that.

Regards.

E.

[BenedictV · Accepted solution]

Hi Eddy,

Try using the 'Key Figure definition' option in RSRT.

http://scn.sap.com/people/vasanth.vf/blog/2011/12/13/query-validation-using-rsrt

Goodluck,

Benedict

[former_member182470]

Hi,

Generate your report once in RSRT. It would refresh your query from the database level.

Try to execute in Bex Analyzer to check the values.

Last option: Debug your query and check the SQL query which gets created.

[Former Member]

Hi,

First, check whether there are data on your InfoProvider for this KF.

Second, check in properties on the "calculate" make sure the "Hide" option is selected.

  Properties --> Calculate --> Calculate result as / calculate individual as :

Third, if in you KF have one or more unit of measure you report can not show de results or he show "*" on value.

like bellow:

To solve this you need to use the function NODIM

Hope this helps.

thanks

[former_member182343]

Hi Eddy,

Your are saying it is Calculated Key figure - can you check first whether KFs used in CKF are getting values.

Try to use NODIM / NOERROR at CKF level.

Check data is available at Info provider level. Check for global and local filters.

Regards,

Vijay