cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member220628
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

cornelia_lezoch
Active Contributor
0 Kudos

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

former_member220628
Participant
0 Kudos

Thanks Cornelia for the answer.

Strangely, I just solved the issue by reloading the data into the cube and activating it again.

Answers (0)