Design Studio Problem with Filter "On Startup"

[Former Member]

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_member110741 · Accepted solution]

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,
Subhash

[Former Member]

Thanks for the fast responses.

@Ingo

Yes, I am using a Bex query as data source.

Crosstab and filter are based on the same datasource.

The thing is, that I do not always want to filter a specific year. This should be preselected for this view in design studio but there has to be the possibility to show the other years as well.

I can try to change my query as you suggested, thanks.

Maybe my description was a bit misunderstanding.

Actually in Design studio the crossstab does not show all years when the current year (2015) is preselected - which is right. The initial view is correct. Current year preselected and only data from this year in the crosstab.

But:

After selecting "clear all filters", we expected that there should be data from all years in the crosstab and in the filter panel all years are shown as filter option.

The crosstab shows the data from all years but the filterpanel only allows to select the 2015 as filter, even though there should be all the other years as well.

We added the year to the crosstab to demonstrate that there is data for at least three different years - after clearing the 2015 filter.

@Subnash

Thanks for your answer.

We imported the mentioned note and now everythings works like expected.

2015 is preselected by design studio but the user has the option to set the filter to another year as well:

Before note 2107060:

After note 2107060 (same dashboard, same query, same data):

Thanks.

Steffen

[former_member245931]

Hi Steffen,

I am also facing the similar issue for one of the object.

Our Data source is HANA and the the field value is default selected to "Y" (in Y/N).

But in Design Studio I am getting the Value only "Y" other filter values are not displayed.

Need help on how to implement the above mentioned SAP NOTE.

Our applications are maintained by the support team.

[Former Member]

Hi,

I am not sure, if this note is also valid for a Hana system.

You will have to implement the Note in your Backend System (not BO) with the Transaction SNOTE (download and install, if the connection to the sap database is set up correctly).

Your basis / support team should know how to do this.

Regards

Steffen

[IngoH]

Hello Steffen,

first of all why would the crosstab show all years when you did filter on the year 2015 ?

Is the crosstab based on the same data source ?

It seems you are using a BEx query as a data source and in that case the easiest / best option to filter with a "default" value for the current year would be to use an EXIT variable in the Bex query and place it in the "Default values" section of the Bex query.

... but that doesn't explain why you only see the one year in the filter.

- is the crosstab and the filter panel based on the same data source ?

regards

Ingo Hilgefort, Visual BI