Multi value drill filters with type of merged dimension(filter prefixed with 'L')

[Former Member]

Dear All,

I am able to pass multi values to drill filters which are not type of merged dimension and getting filtered html response after applying multi valued filter while in case of filters which are of type merged dimension passing multi valued filters, html response is not filtered this is default as it was without applying filters.

I am using 4.2 SP02, may be this feature is available in 4.2 SP02 onwards, please confirm.

e.g.

This is working for filter DP0.DOba

Step1:

PUT, URL: http://<server>:6405/biprws/raylight/v1/documents/1972284/reports/22/driller/filters/DP0.DOba

Raw Payload:

<filter>

    <lov>

        <values>

            <value>Q1</value>

            <value>Q2</value>    

            <value>Q3</value>

        </values>       

    </lov>

</filter>

Response:

Step2:

Get, URL:http://<server>:6405/biprws/raylight/v1/documents/1972284/reports/22/

Accept: text/html

Response: Here html response is filtered for above filter values

But this is not working in Case A Step 2 below, for merged dimension filter L17:

Case A:

Step1:

PUT, URL:http://<server>:6405/biprws/raylight/v1/documents/94734/reports/18074/driller/filters/L17

Raw Payload:

<filter>

    <lov>

        <values>

            <value>270</value>

            <value>385</value>    

            <value>054</value>

        </values>       

    </lov>

</filter>

Response:

<success>

    <message>The resource of type "DrillerFilter" with identifier "L17" has been successfully updated.</message>

    <id>L17</id>

</success>

Step2:

GET,URL:http://<server>:6405/biprws/raylight/v1/documents/94734/reports/18074/

Accept: text/html

Response: Here html response is same as it was before applying any filters

Case B: Single value filter working for merged dimension type filter L17

Step1:

PUT, URL:http://<server>:6405/biprws/raylight/v1/documents/94734/reports/18074/driller/filters/L17

Raw Payload:

<filter>

   <value>270</value>

</filter>

Response:

<success>

    <message>The resource of type "DrillerFilter" with identifier "L17" has been successfully updated.</message>

    <id>L17</id>

</success>

Step2:

GET,URL:http://<server>:6405/biprws/raylight/v1/documents/94734/reports/18074/

Accept: text/html

Response: Here html response is filtered for filter value 270 applied in Step1

Thanks & Best Regards,

Deepak Kumar

[former_member197386 · Accepted solution]

Hi Deepak,

Since multi-values are not supported in regular Webi UI, it is not supported by raylight as well.

We should maybe send back an explicit error message explaining this to users who attempt to filter on several values using driller filter.

Best regards,

Anthony

[former_member197386]

Hi Deepak,

I will look at this point as soon as I can.

Best regards,

Anthony