cancel
Showing results for 
Search instead for 
Did you mean: 

Design Studio Bookmarks and BW exit variables (time)

0 Kudos

I'm working on a Design Studio application where I use the Data Discovery and Visualization template as a basis. We like the way business users can make their own "views" in compose mode and share with other users.

I've got a problem maybe one of you guys have an answer for. Our business users use already existing BW query's to build their own "views". These BW query's already exist and have all kind of BW variables in the query. I already searched SCN but can't find a proper answer or solution.

I noticed that "views" (bookmarks) with variables (exit) aren't refreshing.

For example:

We have a view with underneath a query that has a time variable (exit) range 01.YYYY - thismonth.YYYY. The first time, when the business user creates the view everything is working ok. In this case you get data for 01.2016 - 10.2016

If the business user then opens the view (bookmark) the next month he expects data for the new month as well (01.2016 - 11.2016). I notice the variable isn't refreshing and is still on 01.2016 - 10.2016.

We can find a solution per query, that is not the problem. But we have loads of query's with different exit variables (input/no input, variable in measure etc.) in it and we don't want to change all.

Do you guys face similar problems and maybe have a generic solution for it?

Accepted Solutions (1)

Accepted Solutions (1)

MustafaBensan
Active Contributor
0 Kudos

Hi,

Having remembered discussing this issue before, I managed to dig up the following solution shared by Agnetha-Kristin Kraus

https://scn.sap.com/thread/3928244#16903664

Hope it helps.

Regards,

Mustafa.

0 Kudos

Did some tests and changing the query settings works. Thanks Mustafa.

We've got loads of query's with "SPACE" variables. Something to take into account now..

MustafaBensan
Active Contributor
0 Kudos

Thanks for the confirmation.  Glad that it worked out.  It was a very handy tip from the discussion.

By the way, what do you mean by "SPACE" variables?

0 Kudos

In the same thread there was a link to the SCN Wiki. They refer to " SPACE"  and "STATE".

OT-OLAP-VARIABLE-REFRESH - SAP NetWeaver Business Warehouse - SCN Wiki

MustafaBensan
Active Contributor
0 Kudos

Okay, makes sense now.  Thanks.

Answers (0)