Create A Query View!

[Former Member]

Hi ALL

how to create a Query View for TeMplates?????

Thanks

BI Learner

[Former Member · Accepted solution]

Hi,

You can create a Query in Query Designer. Then you can use the BEx Analyzer to open this Query and Save As a Query View..

Then you can use this Query View in your Web Templates.

Check the below thread and search for Query and Query View. Hope it helps.

http://help.sap.com/saphelp_nw70/helpdata/EN/f1/0a55dfe09411d2acb90000e829fbfe/frameset.htm

[Former Member · Accepted solution]

Hi

What is the advantage of creating a view??

How to migrate BW 3.x Query to 7.0??

Thanx

BI Learner

[Former Member · Accepted solution]

Hi,

A Query View basically contains different set of conditions than the base Query on which the Query View was created. Its like having one Query existing in more than one form.

For migrating 3.x Query to 7.0 query, open the required 3.x query in Query Designer 7.0 and save it. This will automatically convert the 3.x query to 7.0 query.

Note: Once you open a 3.x Query in Query Designer 7.0, you will not be able to open this query again with Query Designer 3.x.

Hope this helps.

[Former Member]

hello,

Query views are saved version of query output with particulr navigational state

The advantages of query views are:

Query views can be used as the data providers when you are creating web templates.

They are also used as jump targets. They are created after you execute the query, from the Save button, you can Save View global, or save as jump target.

They can also be used to format the query e.g hide some characterictic, display/hide result rows, sorting keyfigures etc.

Reg migration:

All existing SAP BW 3.x queries can be edited with the SAP NetWeaver 2004s BEx Query Designer without further manual adaptation.

After editing with the SAP NetWeaver 2004s Query Designer, queries cannot be edited with the SAP BW 3.x BEx Query Designer anymore.

Queries created or adapted with the SAP NetWeaver 2004s BEx Query Designer will still appear in the Open Dialog of the SAP BW 3.x Query Designer, but they cannot be opened anymore

Views:

Query Views that were created before upgrade/migration will still run after a query has been changed with the SAP NetWeaver 2004s BEx Query Designer

In general query views do not need to be migrated

Regards,

Dhanya

[Former Member]

if you are on 3.5 system you can create query views using the 0analyser template.

[Former Member]

Hi,

you can create view through Query Analyser, open your query and save it as a view.

Regards

SSMS

[Former Member]

hi SSMS

Thanks a lot.

Can we create a view in Query Designer???

Cheers

BI Learner

[Former Member]

Hi,

Goto required query and change the layout according to the your requirement and save it as a VIEW.

You can select Query/view from WAD .

Regards

Pcrao.

[Former Member]

Hi PCrao

Can we create view in Query Designer???

Thanks

BI Learner

[Former Member]

Hi,

No you can not create it from Query Designer. 1st create a query then save it as View .

Regards

Pcrao.