Skip to Content
avatar image
Former Member

Assign Data Source when loading BM

Hi Experts,

and one more question on Bookmarks (as search was not very effective).

On loading a Standard Bookmark i understood that onstartup scripts are not executed, as the global variables etc are all saved within the Bookmark. Are there any scripts that are executed on loading a Bookmark, which can be customized?

The Problem for my case ist that power users and standard users have separate queries, which only differ in the number of Key Figures (power users see more). Usually the query is selected on opening the application, depending on whether the user is power user or not. So far so good. Problem is when a Power user tries to share a Bookmark with a Standard user. Here the data source Needs to be changed or the user cannot see anything, as he is not authorized to Access the power user query.

Thanks in advance.

Kind regards


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 22, 2017 at 03:13 PM

    Hi Christian,

    Since data sources are embedded with standard bookmarks, the sharing functionality needs to be architected accordingly. In order to allow changing of the data source via scripting after loading of the bookmark I would suggest once again that you use fragment bookmarks instead.

    That being said, it is important to consider what it is that you want to share across such bookmarks. For example, if you change the data source after loading the fragment bookmark, you will lose the state of the data source from the original bookmark, including any applied filters etc, which I would think are an important part of what you would want to preserve. If preserving the state of the data source is not important, then what other states of the application would you want to preserve when sharing?



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 22, 2017 at 03:30 PM

    Thanks again Mustafa.

    I think we need to review the process of sharing the Bookmarks between Power users and Standard users, as the state of the data source is a vital part of the Bookmark. Removing the filters and Drilldowns would be detrimental.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mustafa,

      we are building a data source to get Access to the AGR_USERS database table and from there determine the Roles which are assigned to the user (i.e. filter user and then check for Power user role). After that I assign the desired query (power or Standard) to the main data source.

      The main Problem currently is that power user queries and Standard queries are build on separate Multi Providers, where the Standard user MP only contains a subset of the key figures.

      This concept was designed before the use of Design Studio was approved, so we currently are challenging this concept.