Skip to Content

Entry xxx in CON but not in FAC error in Bex query

Hi all,

I have created a Top 100% condition on a keyfigure and the query works perfectly in BW dev server but when I transport it to the production server and execute it in RSRT , only one row is returned and the message "one of the conditions ( Top 100%) applied does not return a unique result " is shown.

And if I remove the condition to see if all rows can be returned , this time "Entry xxx in CON but not in FAC"

Any ideas why the two issues are happening?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 02, 2015 at 11:25 AM

    Hi Parvaneh,

    what is CON and FAC? Is it any currency or unit?

    Maybe you have a summation of different currencies in your prod system and the condition can´t work with it.

    How does your query result look like when you deactivate the condition?

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded