How to find out if a certain variable is personalized?

[Former Member]

Is there any way for a web template to know if a user has personalized a variable? We are trying to encourage users to personalize reports for their cost center. If a user does not have cost center personalized, I'd like to display a notice telling the user how to personalize the variable. If cost center is already personalized, then this notice is not necessary.

Thanks,

Jason

[Former Member]

Hi,

the Personalization is stored in the ODS Object 0PERS_VAR.

So you could create a query on top of this ODS object to get the desired information.

Heike

[Former Member]

Hi Heike,

I have created a query to report off the ODS 0PERS_VAR and altough I can see data through Active data, the query when run shows "no applicable data found". Can you enlighten me on how to make this work.

Cheers,

Mike