global profile select statement error

[Former Member]

Hello,

I try to set up profiles to personalize reports for users.

When I use global profile with profile value of first kind (on a profile value screen i choose "value", type, my formula "="my variable", and click add) and attatch it to the publication, it doesn't work properly. No matter what i use inside formula field, BO environment doesn't personalize report in accordance to it.

I've noticed that there is something wrong with select statement created by BO. After sending a publication, report instance received by user has "description" field like "(and (equal null "my variable")). No matter what i put inside formula box in profile "equal null" statement is always added.

When i use second type profile value (filter expression) everythig seems to be fine.

Is this some kind of bug inside global profile mechanism

I have BO XI R 3.1 without any fixpacks.

Thanks in advance for any help

best regards

Wojtek

[Former Member · Accepted solution]

Hi,

In the Values option one can only use fixed values no formulas. Hence the formulas will not work.

In my case the expression option does not work. Have you tried using a formual =CurrentUser in the expression field.