Trap User connected to limit data visualized

[Anonymous]

Hello,

I need to filter data visualized in a QV report based on user logged. One specific user can see information of only one specific Organization.

How can I trap the user connected in order to link him with his Organization and create the specific filter?

PS: User log in with publisher.

Thanks

Sergio

[Gustav_Guldberg]

Hi Sergio,

The solution for this is Section Access in the script to limit the data based on reduction of data for each and every user.

Here is a very basic example. Copy/paste into an application reload and save.
Log in with the different users and you will see the reduction for each user.

For more information, search the forum for "Section Access", there are a lot of good solutions posted by our members.

Section Access;
LOAD * INLINE [
 ACCESS, USERID, PASSWORD, ORG
 ADMIN, ADMIN, ADMIN
 USER, USER1, 1, USA
 USER, USER2, 2, SWE
 USER, USER3, 3, GER
];
Section Application;
LOAD * INLINE [
 ORG, SALES
 USA, 1000
 USA, 2000
 USA, 3000
 SWE, 4000
 SWE, 5000
 GER, 6000
];

Regards,

Gustav

[Anonymous]

Thank you Gustav !

The only problem is that I'm trying to use it now on a client version of QV, but when i reload data with Session access all graphs are marked with 'Allocated memory exceeded''.

is it a known issue? Is it possible to bypass the problem?

Kind Regards,

Sergio

[#4]

I also need to know mor eabout this error .

Bhushan N

[Gustav_Guldberg]

Hi,

"Allocated Memory Exceeded" can be caused by many things. Calculated dimensions, syn-keys, data structure, resource heavy expressions and so forth.

I need more information about build number for the products involved and preferably the document to be able to determine where the error is.

Regards,

Gustav

[Anonymous]

Maybe I solved.

The problem was due to the fact that i didn't wrote section Application part.

Thanks

Sergio