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

[former_member241445]

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

[MustafaBensan · Accepted solution]

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.

[former_member241445 · Accepted solution]

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

[Former Member]

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

[former_member241445]

Hi Etienne.

Have you tried what Mustafa said?

I've tried for Dimension B theMembers for Filtering option is set to "Only Values with Posted Data", and I was succeed.

Regards .

Jing

[Former Member]

Hi Jing,

The problem is that I'm using universe data source and a Bex data. Hence there is no Members for filtering option when I edit the initial view.

untitled.png

Regards

Etienne