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

Björn Reuber

Hi,

 

long question, short answer:

1) no

2) code (cause it is unique)

3) yes

 

Regards

Björn

Jörn Constabel

Dear all,

 

I have a similar question to this.

Is it possible to have two @User selections on two different entities (no relation between this two entities) in one custom selection script?

 

 

Regards,

Jörn

Dietmar Jeschkeit

Hi Jörn,

 

as Björn said above. Yes it is possible.