Skip to Content
author's profile photo Former Member
Former Member

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Aug 11, 2015 at 04:01 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 11, 2015 at 12:22 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2015 at 07:28 AM

    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


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Usha Rani Desu

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.