Report drill filter LOV in 4.1 SP2

[Former Member]

Dear All,

I am looking to find the drill filter values in a document using Rest SDK, as of now I am able to get the id only prefixed with 'L'(merged dimension) of the filters but no values. Product info: 4.1 SP2

In below link, Daniel Paulsen answered on Aug 13, 2014 6:26 PM to get the merged dimension filters lov, but this is not working for me.

https://scn.sap.com/thread/3599805

Please provide some solution if this is possible.

Thanks & Regards,

Deepak Kumar

[former_member197386 · Accepted solution]

Hello,

To get the filter values, you should follow this pattern:

Example (XML format):
[GET] <url>/documents/13343/reports/1/driller/filters/DP0.DO13

Response body:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<filter qualification="Dimension" inQuery="false" ambiguous="false" inScope="true">

    <id>DP0.DO13</id>

    <lov hierarchical="false" partial="false" refreshable="false">

        <values>

            <value>Albertville</value>

            <value>Augsburg</value>

            <value>Belfast</value>

            . . .

            <value>Washington D.C.</value>

            <value>Yokohama</value>

        </values>

        <columns mappingId="0">

            <column id="0" type="String"></column>

        </columns>

    </lov>

</filter>

Regards,

Anthony

[Former Member · Accepted solution]

Dear Anthony, Thanks a lot for replying, I followed this pattern for two document viz. 94734 and 1386360 but there is no lov in 4.1 SP2. Please let me know if there is any solution for the same in 4.1 SP2. DocumentID:94734,ReportId:18074 Step 1: Get:http://server:port/biprws/raylight/v1/documents/94734/reports/18074/driller/filters

L19L17 Step 2: Get:http://server:port/biprws/raylight/v1/documents/94734/reports/18074/driller/filters/L19

L19 Step 3: Get:http://server:port/biprws/raylight/v1/documents/94734/reports/18074/driller/filters/L17

L17====================================================================== DocumentID:1386360,ReportId:2 Step 1: Get:http://server:port/biprws/raylight/v1/documents/1386360/reports/2/driller/filters

DP0.DO92 Step 2: Get:http://server:port/biprws/raylight/v1/documents/1386360/reports/2/driller/filters/DP0.DO92

DP0.DO92 Thanks & Regards, Deepak Kumar

[former_member197386 · Accepted solution]

Hello Deepak,

4.1 SP02 is quite old and doesn't receive patch anymore... So, if you're facing an issue about this feature, could try to a more fresh release and tell me if it is still failing?

Best regards,

Anthony

[Former Member · Accepted solution]

Hi Anthony,

Thanks a lot for replying, I agree that this would not be possible in 4.1 SP02.

Now I am testing this feature with 4.2 SP02 and I am able to get the list of values of non merged dimensions fields.

Could you please guide me how can I request REST service with selected value as a report level filter?

Thanks & Regards,

Deepak Kumar