Create a filter value from a URL command

[Former Member]

Hello all!

I would like to create a URL link to a specific query, with a filter value that will be transferred as a URL parameter.

I know that in older version I could have use this syntax –

FILTER_IOBJNM=0MATERIAL&FILTER_VALUE=1000040

But now on BI 7 it doesn't work.

What can I do?

Helpful answers will be rewarded.

Thank you!

Ron.

[Former Member · Accepted solution]

Hi Rampel,

There is a more complex way to do it in BI 7.0. You need to build a command based on structure of xml.

You can find that information in some pdfs (Enterprise Reporting, Query and Analysis). Ill put the link in the next post. Still is kind of complicated.

What I did is javascript function that simplifies the url command u need to send. In this case the filter applies to all data providers (see "*"), if you just need to affect one data provider or alist then you can specify them in TARGET_DATA_PROVIDER_REF_LIST-TARGET_DATA_PROVIDER_REF_1, but you need to create a list.

Here an example code to generate que qstring to be sent:

syear = 2008;

smonth = "02";

qstring = location.href + "?TEMPLATE=ZGDRTP03C7";

qstring = qstring + GenerateEqualFilter(1,"0CALYEAR",syear);

qstring = qstring + GenerateEqualFilter(2,"0CALMONTH2",smonth);

function GenerateEqualFilter(command,char,value)
{

	 var qstring;
	qstring = "";
	if (value != -1)
	{
	  qstring = "&BI_COMMAND_"+ command + "-BI_COMMAND_TYPE=SET_SELECTION_STATE_SIMPLE&BI_COMMAND_" +command+"-TARGET_DATA_PROVIDER_REF_LIST-TARGET_DATA_PROVIDER_REF_1=*&BI_COMMAND_" +command+"-CHARACTERISTIC=@char&BI_COMMAND_" +command+"-RANGE_SELECTION_OPERATOR-EQUAL_SELECTION-MEMBER_NAME=@value";    

	  qstring =qstring.replace("@char",char);
	  qstring =qstring.replace("@value",value);

	}
	return qstring;
}

[Former Member]

Thank you, it's working!

[Former Member]

Hi,

Can you pls explain how you have done this . I am not clear what David has explained .Can u pls let me know how u have done

Thanks

Sany

[Former Member]

anyone??

[Former Member]

This is how you transform the xml tu url parameter, this is another example, but the same rules apply.

Example 1:

In the command wizard, you have set the command for setting attributes for a characteristic of

the data provider. The XHTML view of the Web Application Designer displays the following

result (only the INSTRUCTION node is show in this example):

<bi:INSTRUCTION >

<bi:SET_ATTRIBUTES >

<bi:TARGET_DATA_PROVIDER_REF_LIST type="ORDEREDLIST" >

<bi:TARGET_DATA_PROVIDER_REF index="1" value="DP_1" />

</bi:TARGET_DATA_PROVIDER_REF_LIST>

<bi:CHARACTERISTIC value="0D_CUSTOMER" text="" />

<bi:PRESENTATION_AREA value="RESULT_SET" />

<bi:ATTRIBUTE_LIST type="ORDEREDLIST" >

<bi:INFO_OBJECT_ATTRIBUTE index="1" value="0D_COUNTRY" />

</bi:ATTRIBUTE_LIST>

</bi:SET_ATTRIBUTES>

</bi:INSTRUCTION>

This results in the following URL parameterization:

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_ATTRIBUTES

&BI_COMMAND_1-TARGET_DATA_PROVIDER_REF_LISTTARGET_

DATA_PROVIDER_REF_1=DP_1

&BI_COMMAND_1-CHARACTERISTIC=0D_CUSTOMER

&BI_COMMAND_1-PRESENTATION_AREA=RESULT_SET

&BI_COMMAND_1-ATTRIBUTE_LIST-INFO_OBJECT_ATTRIBUTE_1=0D_COUNTRY