Script Logic doesn't filter using the latest property values

[Former Member]

Hi experts,

I am having an issue with a script logic that uses a property value of the time dimension to scope the source data set.

The property name is "Not_Actual" and it is flagged as "InApp". The script logic gets validated without any issues.

The logic was working propperly until we modfied the value of the property. Now the script logic is still working but using the old values of the property and not the latest ones.

I have tried to process the time dimension, process all the models, refresh the environment information and also to optimize all the models.

I have also checked that the dimension in the SQL server contains the latest property values.

Any idea what could be happening?

Thanks in advance!

Jorge

[jrg_finster3]

Take a look at your ".lgx" file if it still contains the old values.

SELECT Statements are evaluated when saving/processing the logic.

If you have *SELECT Statements in your Logic, just validate&Save your logic again.

If you dont, it will be great if you can show your logic...

Regards

Jörg

[Former Member]

Try unchecking the "InApp" property flag and reprocessing.  This flag is not typically used and may be creating the issue you are experiencing.

Regards,

Di~An

[former_member208963]

Can you share the piece of code referring to the property?

Something like this:

*SELECT (%VAR_CAT%,"CATEGORY","CATEGORY","Not_Actual = 'Y'")

*XDIM_MEMBER CATEGORY = %VAR_CAT%

If you debug a code like this, you are not getting the correct scope?

regards