cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

multiple dataprovider - single variable - View

Former Member

on ‎04-21-2006 3:38 PM

0 Kudos

Hi!

I have a web report connected to two dataprovider : one which refers to a query for the table, the navigation

bloc ; an other one which refers to a view, allowing me to have a specific chart.

my pb is that the user have to select twice the same variable... how can I do that??

for information : the html code


<HTML>
<!-- BW data source object tags -->
<object>
         <param name="OWNER" value="SAP_BW"/>
         <param name="CMD" value="SET_DATA_PROVIDER"/>
         <param name="NAME" value="DATAPROVIDER_2"/>
         <param name="DATA_PROVIDER_ID" value="ZSDC01_FAC_VIEW"/>
         DATA_PROVIDER:             DATAPROVIDER_2
</object>

<object>
         <param name="OWNER" value="SAP_BW"/>
         <param name="CMD" value="SET_DATA_PROVIDER"/>
         <param name="NAME" value="DATAPROVIDER_1"/>
         <param name="QUERY" value="ZSDC01_FAC02"/>
         <param name="INFOCUBE" value="ZSDC01"/>
         DATA_PROVIDER:             DATAPROVIDER_1
</object>

<object>
         <param name="OWNER" value="SAP_BW"/>
         <param name="CMD" value="SET_PROPERTIES"/>
         <param name="TEMPLATE_ID" value="ZSDC01_FAC01"/>
         TEMPLATE PROPERTIES 
</object>

<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE>BW Web Application</TITLE>
      <link href="https://answers.sap.com/sap/bw/Mime/BEx/StyleSheets/BWReports.css" type="text/css" rel="stylesheet"/>
</HEAD>
<BODY>
<TABLE style="WIDTH: 700px; HEIGHT: 60px" cellSpacing=1 cellPadding=1 width=500 
border=0>
<TR>
<TD Align= top>
<object>
         <param name="OWNER" value="SAP_BW"/>
         <param name="CMD" value="GET_ITEM"/>
         <param name="NAME" value="NAVIGATIONBLOCK_1"/>
         <param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_NAV_BLOCK"/>
         <param name="DATA_PROVIDER" value="DATAPROVIDER_1"/>
         ITEM:            NAVIGATIONBLOCK_1
</object>
</TD>
<TD Align = top>                
      
        
        
          <object>
         <param name="OWNER" value="SAP_BW"/>
         <param name="CMD" value="GET_ITEM"/>
         <param name="NAME" value="CHART_2"/>
         <param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_CHART"/>
         <param name="DATA_PROVIDER" value="DATAPROVIDER_2"/>
         <param name="TITLE" value="Quantités facturées par prestation"/>
         <param name="TMP_CHART_DATA_HANDLE" value="IIP_41IOFE6UUSA89FH96SMFY0WGQ"/>
         ITEM:            CHART_2
</object></TD>
         </TR></TABLE></TABLE>
<TABLE style="WIDTH: 700px; HEIGHT: 60px" cellSpacing=1 cellPadding=1 width=500 
border=0>
<TR>
<!-- debut logo groupama -->
<TD vAlign="top">   <IMG 
      style="WIDTH: 167px; HEIGHT: 48px" height=63 
      src="/sap/bw/Mime/Customer/Images/logo.jpg" 
      width=208>               
<!-- debut excel -->
<A href="<sap_bw_url cmd='PROCESS_HELP_WINDOW'
help_service='PRINT_WITH_EXCEL'
item='TABLE_1'
sap_bw_url cmd='export' format='xls' data_provider_1='dataprovider_t1'
subcmd='PRINT_EXCEL'>">
<IMG style="WIDTH: 30px; HEIGHT: 32px" 
      height=50 
      src="/sap/bw/Mime/Customer/Images/Excel.jpg" 
      width=50 border=0></A>   
<x:bw>
<hierarchy_ICONS hide="x"></X:BW> 
      <BR>                                                                           Export 
<!-- fin excel -->          
      
  </TD>
<!-- fin logo groupama --></TR>
</TABLE>
<TABLE style="WIDTH: 700px; HEIGHT: 60px" cellSpacing=1 cellPadding=1 width=500 
border=0>
<TR>
<object>
         <param name="OWNER" value="SAP_BW"/>
         <param name="CMD" value="GET_ITEM"/>
         <param name="NAME" value="TABLE_1"/>
         <param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_GRID"/>
         <param name="DATA_PROVIDER" value="DATAPROVIDER_1"/>
         <param name="WIDTH" value="693"/>
         ITEM:            TABLE_1
</object>
</TR>
<TR>
   
<object>
         <param name="OWNER" value="SAP_BW"/>
         <param name="CMD" value="GET_ITEM"/>
         <param name="NAME" value="TEXTELEMENTS_1"/>
         <param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_TEXT_ELEMENTS"/>
         <param name="DATA_PROVIDER" value="DATAPROVIDER_1"/>
         ITEM:            TEXTELEMENTS_1
</object>
   
</TR>
</TABLE>
</BODY>
</HTML>

thanks !

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
‎04-28-2006 4:33 PM
0 Kudos

Make sure in the properties you tell it to reset variable values to default values. This will clear the value you entered for the view.

Thanks,

Jeff

Show replies
Show replies
Former Member
‎05-02-2006 9:50 AM
0 Kudos

thanks a lot Bhanu Gupta and jeff, you solve my problem!

Phie

Former Member
‎04-28-2006 11:43 AM
0 Kudos

Hi

I think that I found the problem, but I don't know how to solve it...

When I save my view, I had a value for the period ; when I run the web page, the value for the view, is the one when I save it for the period, but there is no value for the query itself. the two variable are the same but they don't have the same value... so they ask twice for the same variable... How can I have my view without value for the period??

Thanks

Show replies
Show replies
former_member188975
Active Contributor
‎04-28-2006 2:39 PM
0 Kudos

Hi Phie,

You can try to assign a default value for this variable, like the default value can be that by which you want to save the view. So now in the web screen the variable will pop up once with a default value which users can change if required.

Or if this is not a mandatory variable, then you can run the query without a value, restrict to the value reqd and then save the view.

Hope this helps...

Former Member
‎04-21-2006 3:53 PM
0 Kudos

yes...

but it still asking me twice for the same variables...

Show replies
Show replies
former_member188975
Active Contributor
‎04-21-2006 3:55 PM
0 Kudos

Is the technical name o those variables the same, I mean you could have 2 variables with the same description...for this to work, the same variable needs to be used (same technical name).

Former Member
‎04-21-2006 3:56 PM
0 Kudos

there are the same : the view is just a restriction of the query.

former_member188975
Active Contributor
‎04-21-2006 3:43 PM
0 Kudos

Hi Phie,

Have you tried setting the "Display same variables only once" of the web template?

Show replies
Show replies
Ask a Question