cancel
Showing results for 
Search instead for 
Did you mean: 

incorrect default value in AFO

javier_barneogonzlez
Participant
0 Kudos

Hi.

I have created a AFO 2.5 sp3 with 4 Bex query, i have unchecked the option for save the excecution filters and when i execute the AFO the system shows one value for fiscyear.


I haven’t saved this year anywere and when i fill the others fields, i have an error:


d2.png

I select 2018 and 2019 again and the error is not shows again.

I have deleted the last query and the AFO runs correctly without this default value, but If I insert the bex query again the default value is showed again. If i insert this bex query in other new AFO the default value is not showed, so i think that the bex query is correctly.

I have try to delete the cache for AFO but this not solve the problema.

If i insert one by one the bex query to another new AFO the default value is not showed but I have spent more time to formating the original AFO.

Any Idiea.

Kind regards.

TammyPowlas
Active Contributor
0 Kudos

Hello Javier - is this the default from the BEx query that is coming over?

javier_barneogonzlez
Participant
0 Kudos

Hello.

No, the Bex query hasn't any default value.

Kind regards

Accepted Solutions (0)

Answers (2)

Answers (2)

Anand71
Active Contributor
0 Kudos

Hi,

why do you create new variable for year in last bex query.

Regards,

Anand

former_member110741
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Javier Barneo Gonzalez,

that could be because, these values are stored for variable for that particular user in backed end (BW)

you can check with BW administrator to check the variable values for that user, they can remove the values in BW

Thanks & Regards,
Subhash