Formula capabilities in User Objects?

[Huwt]

Hi

I'm attempting to replace a character in User Objects with no character. (sounds strange huh?) I would have thought that using the following would work : ".", "" and it certainly works fine when i enter it in as a variable in the Results. Why won't it work in User Objects?

Many Thanks

Huw

 

[skrandel]

User Objects don't use BO's formula engine. User Objects ONLY use functions that are in your database. User Objects are used to alter the SQL.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[Huwt]

Thanks Steve

Presumably this means that I can only perform a limited number of basic functions in user objects and will have to perform the rest in the data variables when I've processed the results? The only reason this would be a problem is that I'm setting up templates for other business users and user objects (once set up) limits the user involvement

Huw

 

[blom0344]

Huwt,

User objects are meant as a last resort to bend the tool further to your needs.

Stay away from them if you are generating generic reports that others will use.....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[Huwt]

So to finalise (to make sure that I've understood!) Its impossible to use the replace function in User Objects where you wish to simply remove a character from the string? Is there any other way of doing this without actioning it in the variables screen

Really appreciate your help on this!

Thanks

Huw

 

[blom0344]

Huwt,

Why not use the database equivalent of the BO reporter function as Steve pointed out.

Most databases have similar functions to work with....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[skrandel]

You've got to put the intelligence as far upstream as possible. Your universe should do the substitution for you.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[Sridharan]

Huw,

Which DB are you on???

Sri