cancel
Showing results for 
Search instead for 
Did you mean: 

Precalculation Web template - use variant

Former Member
0 Kudos

Hi,

I work with precalculated web templates. Cause the based queries contain a lot of variables the url to call the web teplate is very long. The precalculation works but I receive an error in the javascript in line:

var sapurl = SAP_BW_URL_Get(). I accept cause of the long url.

My question; is it possile to call the webtemplate with an according variant instead of all variables. E.g.

use

<A class=fame_report_link href="<SAP_BW_URL CMD='LDOC' TEMPLATE_ID='ZAS_F19_001' DATA_PROVIDER='DATAPROVIDER_1' VARIANT='VARIANT001' DATA_MODE='STORED'>"> instead of

<A class=fame_report_link href="<SAP_BW_URL CMD='LDOC' TEMPLATE_ID='ZAS_F19_001' VAR_NAME_1='AS_COAR2' VAR_NAME_2='ASHIER02' VAR_NAME_3='ASN_CE01' VAR_NAME_4='AS_HCT' VAR_NAME_5='AS_CCTR5' VAR_NAME_6='AS_CCTR5' VAR_NAME_7='AS_CCTR5' VAR_NAME_8='AS_CCTR5' VAR_NAME_9='AS_CCTR5' VAR_NAME_10='AS_DBCR2' VAR_NAME_11='AS_STATZ' VAR_NAME_12='AS_CURR2' VAR_NAME_13='AS_FYCE1'...DATA_MODE='STORED'>">

regards - Happy New Year

Jens

Message was edited by: Jens Schauenberg

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Jens,

I tried before to work with the command sequence. But as well as the command <A class=fame_report_link href="<SAP_BW_URL CMD='LDOC' TEMPLATE_ID='ZAS_F19_001' DATA_PROVIDER='DATAPROVIDER_1' VARIANT='VARIANT001' DATA_MODE='STORED'>"> the command sequence causes the error message "No precalculated data found for data provider DATAPROVIDER_1" if you use the parameter "STORED".

If you use the parameter "HYBRID" the command above calls - as I want - the report with the defined values of variables in the variant and without display of the variable screen (but unfortunately not with precalculated data).

But using the command sequence the variable screen appears without the defined values of variables - I guess the command sequence does not work (in my case) or I did a mistake.

Former Member
0 Kudos

Hi Jens,

I think you have precalculated the query with variant.

I can not test your special szcenario, but I have got some ideas for you.

1) Try out the DATA_MODE='STATIC'

DATA_MODE Dokumentation:

http://help.sap.com/saphelp_nw04/helpdata/en/a0/a48b3ba19dfe47e10000000a11402f/frameset.htm

2) name the infocube and query explizit in your CMD URL, like the syntax I write down...

3) Check the precalculated data in your BW System

Let me know your results and whether it works...

rgds Jens

Former Member
0 Kudos

Hi Jens,

sorry for the very late answer but I had no access to

the SDN till now.

Your answer was very helpful - I can't test it in the

way I want because the concept was redesigned.

Cause of new requirements the project can no longer the principle of variants.

regards

Jens

Former Member
0 Kudos

Hi Jens,

you can open a new webtemplate with an according variant with a command sequence.

general syntax for the RESET_DATAPROVIDER CMD:

<SAP_BW_URL DATA_PROVIDER='View1' CMD='RESET_DATA_PROVIDER'

INFOCUBE='myCube' QUERY='myQuery' VARIANT='myVariant'>

you can try out this coding: (edit myCube and myQuery)

<A class=fame_report_link href="<SAP_BW_URL CMD='LDOC' TEMPLATE_ID='ZAS_F19_001'DATA_MODE='STORED' CMD_1='CMD=RESET_DATA_PROVIDER&DATA_PROVIDER=DATAPROVIDER_1&INFOCUBE=myCube&QUERY=myQuery&VARIANT=VARIANT001'>">

open template with variant</A>

rgds and happy new year

Jens