Skip to Content
author's profile photo Former Member
Former Member

Precalculation Web template - use variant

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2004 at 06:47 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2004 at 02:02 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.