Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Design Studio Problem with Filter "On Startup"

Hi all,

we have some problem with a filter function in Design Studio.

Installed Version: Design Studio 1.4 SP01

Our Datasource/query has data from a few years.

As this is too much information, we decided to filter on startup only the current year and set a text with the year in brackets.

On Startup we get a variable for current year (CURR_Year):

CURR_Year = "20" + Convert.subString(APPLICATION.getInfo().dateNow, Convert.stringLength(APPLICATION.getInfo().dateNow)-2) ;

On select for the component tabstrip, we set the filter and teh text:

DS_5_FA.setFilterExt("0CALYEAR", CURR_Year);

TITLE_TAB3.setText("Fertigungsausgang Details (" + DS_5_FA.getFilterText("0CALYEAR")+ ")");

So this filter is working but now we wanted to select another than the current year by a standard filter panel.

The current Year is selected, which is ok:

But there a no other member which may be selected. Even after resetting the filter, there is still only the current year (2015) selectable.

We expected that there will be all the other years for which data is stored.

Even tough the crosstab shows the data from all years.

Furthermore it is possible to add the year to the columns:

So there is the data in the background but no possibility to set a filter on aspecific year by the standard panel.

Is the another (better) way to preselect the current year to avoid this problem, or is this a bug in design studio?

BTW: The same effect when filtering any other member.

In our first attempt, we filtered a specific year (2015 not current) with the initiual view of the datasource in design studio.

Here the filterpanel will show the other years.

I do not understand where exactly is the difference. Unfortunately with the initial view it is not possible to use the current year variable which means that we would have to maintain this application every year....

Hopefully someone knows this problem and may help us.

Thanks in advance

Steffen Bruckner

Former Member

Hi Steffen Bruckner,

Check the issue first as Ingo mentioned, if everything is correct from Design Studio then you follow this note, this could be BICS issue

2107060 - RSBOLAP: Correction for SAP Note 2065089 (reader reset)

Thanks & Regards,

1 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question