DB Security & Custom selection script

Daniele Di Lorenzo

Hi

has anyone experience with intensive use of the functionality on the title?

 

I'm currently using the dynamic script @user in a couple of cases, but I would extend its use on other cases and on static selections on multiple members / entities.

 

This would allow a better visibility of the selection applied and I expect more stability if the entity is cleared and reloaded.

 

I have some questions:

1) blanks in entity or selected items name may create problems?

2) do the script work on the item code or description?

3) is it possible set a selection on more than one entity?

 

Any information or example is appeciated

thanks!

Samuele Marchetto

Hi Daniele Di Lorenzo,

 

I add an example to Björn Reuber answer.

 

I created a database profile that makes a selection on two entities: "Category" (aggregation of the product) and "Login (District)" (aggregation of the customer, that contains the login assigned to each District Manager).

The script is:

Select Login (District)=@User

Select Categoria=10,20

 

As you can see, you have to repeat the command "Select" for each entity and you must separate the elements to select with a comma.

 

 

Notice that the Data Selection by current script is not signaled with the funnel icon.

 

Bye