Ad- hoc

[#1]

hello guys

Wat is ad hoc? plz reply.

acer

[Former Member]

Hi acer auz,

Please refer the following threads,

<b>Ad-hoc Query Designer:</b>

http://help.sap.com/saphelp_nw04/helpdata/en/1f/03223c5f00612be10000000a11402f/content.htm

<b>Ad-hoc report and Creation</b>

I hope they'll help u lot to solve ur Question.

Please Assign points.

Thanks

Regards,

Jayaprakash.J

[Former Member]

hi..

Ad hoc - Dictionary meaning is - For the specific purpose, case, or situation at hand,concerned or dealing with a specific subject, purpose and for no other.

In our case Ad hoc means say the reports are already existing, Users are coming up with a small enhancements in the existing report. this is nothing but ad hoc requests from user. this is small scenario. There may be other ad hoc requests pertaining to enhancements in extractors, Start routines, related to performance of the system etc.

Go through these.

http://help.sap.com/saphelp_nw04/helpdata/en/1f/03223c5f00612be10000000a11402f/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/08/965b423be8de54e10000000a155106/content.htm

http://www.ams.utoronto.ca/Asset353.aspx#search=%22Difference%20between%20ABAP%20query%20and%20Ad%20...

Adhoc Query designer means -A Web item that enables you to create and change queries in a Web application on an ad-hoc basis.

use the Ad-hoc Query Designer Web item in the Web Application Designer to structure Web applications in which you create or change queries. The Web item is as a tool for designing ad-hoc queries in a Web environment.

In particular it enables you to:

· Create queries by assigning characteristics from an InfoProvider to rows, columns, filters, and free characteristics, and including key figures from the InfoProvider in the key figure structure of the query.

· Restrict or filter key figures and characteristics

· Use predefined key figure structures and restricted or calculated key figures in the query

· Set or change query properties and key figure/characteristic properties in the query

· Create or change conditions and exceptions

When compared with the BEx Query Designer, the Ad-hoc Query Designer Web item has the following restrictions when creating or changing queries:

· You cannot integrate variables into the query directly.

However, you can use variables in reusable structures, or restricted or calculate key figures, which are used in the Ad-hoc Query Designer

· The query can contain only one structure. This structure has to be the key figure structure and be in the rows or columns of the query.

- You cannot use key figures or key figure structures in the filter.

- You cannot define exception cells, since this requires two structures.

You cannot create the following objects using the Ad-hoc Query Designer Web item:

- Reusable structures

- Reusable restricted key figures

- Reusable calculated key figures

- Local calculated key figures

You can create local, restricted key figures using the Ad-hoc Query Designer Web item.

You can edit existing queries in the Ad-hoc Query Designer Web item, if the queries adhere to the restrictions laid out above The Ad-hoc Query Designer checks these requirements when loading a query. If the query is too complex, the query can be loaded into the Ad-hoc Query Designer but you cannot change it there. You then receive the appropriate message. You can still check and execute the query.

hope this helps...