BEGIN_SQL

building semantic layer
1

Hi All,

What do the following mean?

Support for BEGIN_SQL, Prompt support for codes AND descriptions.

ajq

anushajq (BOB member since 2005-02-22)

2

Hi
it would help if you included where this information came from to help with a response
Information on the BEGIN_SQL information is in the What’s New in BusinessObjects XI3.1 guide

BEGIN_SQL allows you to inject SQL before the Select Query SQL is generated.
Not sure what the “Prompt support for codes AND descriptions” refers to

buzz :australia: (BOB member since 2005-08-12)

3

Not sure what this does. Can someone give an example?

ajq

anushajq (BOB member since 2005-02-22)

4

The BEGIN_SQL? For my purposes, at least, it would primarily be used to add hints. For the database to use a hint, it has to come at the beginning of the SQL statement. But, training users to select hints first so that WebI puts them at the beginning is, naturally, unreliable at best. The BEGIN_SQL allows you to automate that.

I would assume that the “prompt support” bit would refer to an ability to do multi-column LOV’s. So, you can use the “code” value in the prompt, but display the “description” value to the user.

Lugh (BOB member since 2009-07-16)