To include a value '#' in users filter vaue selection

[praveen_kumar1]

Hi Gurus,

Thanks a lot for the continuous help from all of you and Again I am looking for ur valuable suggestions for my follwing problem :

In my query I have a characteristic RunID which is included in the Free Characteriostics.

according to the Functionality user will select one or multiple values of RunID,whenever he'll run the Query.

I want taht whenever a value is selected,the filter should also include'#' in the selection with the value selected by the user .

Please help me to achieve this.

I'll assign the points for any helpfull suggestion.

Thanks in Advance !!

Best Regards,

Praveen

Message was edited by:

Praveen Kumar

[Former Member · Accepted solution]

Hi Praveen.

Why don't you just restrict RunID to # and your variable at the same time?

Hope it helps.

BR

Stefan

[praveen_kumar1 · Accepted solution]

Hello Stefan,

Thanks for the suggestion .

I have already tried it ,but first of all I dont want to have any variable for that characteristic on the selection screen.(I want the user to select it from the filter button provided in the Freecaharacteristics with the characteristics).

second: When I restrict the characterstic with'#' along with the variable ,it makes the variable as Mandatory altough the variable is optional.

My requirement is to include'#' in the filter values given by the users.

Please suggest

Best Regards,

Praveen

[Former Member · Accepted solution]

you mean that when the user selects some filter value then only the "#" shud be inlcuded along with the filter.

[praveen_kumar1 · Accepted solution]

You r getting it right friend,bcoz when thr is no filter then any way all the values are selected.

but when the user will select some filter values ,he will definitely not select the'#' valuse ,which is very much required for my query to run properly .

Best Regards,

Praveen

Message was edited by:

Praveen Kumar

[Former Member · Accepted solution]

Is this characteristic is with master data or not ?

[praveen_kumar1 · Accepted solution]

Hi Preetha,

This Characteristic does not have master data .

Regards,

Praveen

[Former Member · Accepted solution]

Praveen # displays 'Blank record' in BI so what ur looking for is possible in case if there is any blank record.

[praveen_kumar1 · Accepted solution]

Hi Preetha,

I want '#' value to be included bcoz this query is made on an Multiprovider which inturn has one DSO and one infoset created on the same DSO .

Purpose of this query is to compare the records in different Runs of the Report .

Report creates a RunID in each Run .

I am having two Characteristics in my Query RunID1 and RunID2 .

Now to compare the two Runs ,user has to select two values for the two RunIDs .

Once he clicks the filter button for RunID 1 and select some value ...the records are filtered for that value .

that means it does not have any reords from the other infoprovider and RunID will show no values to select when he'll try to filter for RunID 2.

To get values in RunID2 ,he should also select '#' value with other values while filtering for RunID 1 and vice versa .