Hello - what is your data source? If it's the BEx query, I would do the filtering back there.

In this, my BEx query selects last 12 months automatically using a BEx variable:

Then I use the standard Basic Analysis template to show the line graph:

This template has built-in filters. Perhaps try this with your data to see if it meets your needs?

Hi Ajeet,

As Tammy has pointed out, your requirement cannot be implemented via front-end manipulation. It is best to model the BEx Query to output the needed restricted data set. Your requirement is very similar to that discussed in the following post, where the solution applies a combination of BEx Variables and Formula Variables:

https://answers.sap.com/questions/190549/display-of-cumulated-figures-in-design-studio.html

I suggest you review the solution in the above post with your BW Team colleagues.

Let me know if you have any questions.

Regards,

Mustafa.

Thanks Tammy for providing your inputs. I always find your answers and tips very useful and informative. You are doing a great help to people like us!

I don't have any good skill set in BEx queries as usually my major focus always remained on front end reporting tools. You have provided the suggestion to make changes in the query but what I understand from my team who handles BW / BEx that we can't apply any other filters because the query is using a custom week structure (for 53 weeks) which don't use the standard calendar. So we want to have filtering done at design studio level.

Isn't there any way to put a filter having the following condition:

Exclude all rows WHERE year='current-year' AND week>'current-week'

I understand that there is an 'data selection' method to achieve this kind of results but I haven't any success on data selection on InfoChart. Would it be possible for you to give me some inputs on same?

Also, it would be of great help if you can provide me some documentation on building data selection expressions (JSON based) which can be passed to CHART.setDataSelection() function. I want to know what are the keywords which can be used (like, MEASURES_DIMENSION, etc) and the syntax to use it. Looking forward for your help!

Dear Ajeet,

if I understood your problem correctly, you can achieve set, by setting a filter in the "on Startup Routine".

Here is my Scripting:

1. Get the actual Date out of the Design Studio Application
2. Convert that date to "int" format (so that you can work with it)
3. Do your desired filtering for the Dimension (if you need the actual date as a filter, you can leave it as it is, with the function "substring" you can split the value, so that you have month, year and day in different variables within Design Studio)
4. Set the Filter to the DataSource (in my Case DS_TABLE).

Initial View of the DataSource:

Filtered View of the DataSource:

Regards,
Chris