Skip to Content
avatar image
Former Member

How to get B demission value that after filter demission A in Sap Businessobjects Design Studio

Hi everyone.

I recently face a problem.I want to get a demission value that after I filter other demissions,and I've tried setFilter/setVariable,but both of them are false.When I use setFilter,I just get the demission all value ,not I wanted value that after filter.When I use setVariable A demission,I found it just effect A demission,B demission is false who still get B demission all value,eg:if A demisiion is year and B demission is month(stucture is "201601"),and DS_1.setVariable("year","2016"),and when I getDemission("year") I will just get value 2016,but if I getDemission("month") I will get value like "201701".

I was used in SAPUI5,the vession is 16.4.0,the Datasource is HANA.

Eeverybody have face this problem,and do you have solution?

Thanks.

Jing

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 10, 2017 at 03:29 AM

    Hi Jing,

    The setFilter() method should work in this scenario. Please make sure that in your data source initial view, for Dimension B the Members for Filtering option is set to "Only Values with Posted Data". This issue has also been discussed in the following post: GetMemberList - How can I filter returned values?

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,Mustafa.

      Very nice,which solved my question,I never notice the selection of initial view,maby I should spent more time in it.

      Thanks.

      Jing

  • avatar image
    Former Member
    Apr 12, 2017 at 12:22 PM

    Hi Mustafa,

    I'm trying to do the same but with Universe Data source. Have you any idea on how I can get filtered data from universe datasource?

    Regards,

    Etienne

    Add comment
    10|10000 characters needed characters exceeded