Questions on Qlikview - get data using user's Id

[#1]

Hello,

After using Qlikview for a while, I have a couple questions on Qlikview, would like to know how you solve it.

Loading data use user's id:

    When I build a document, I will connect to database and get data back. If I understood correctly, when I save it and upload to server, the data will be there unless its being refreshed. That is OK for most of the case, but for our case, we really need users run the dashboard using their id to retrieve data.

    The reason is simple, for sales reports, we want sales people only see their own transactions, not other people. If I retrieve all data, sales people will see everything.

Thoughts? Would glad to know how you solve it.

Thanks!

George

[#2]

Hi George,

Please look up Section Access which will solve your problem.

[#3]

Thanks for the information. I wen through the Section Access, but I think it is not the one I need.

The company I worked is a global company with users in multiple countries. Clearly as a developer, I am not able to get their names, ids.

We currently use SAP BW and all security are setup in BW, all we need is to call the BW query (or reload data)  using users's id, then all security is settled.

With Qlikview, is it possible?

Thanks again!

George

[#4]

cant you load in the user info directly from SAP BW?

Section Access;

load

     USERID,

     NTNAME,

     ACCESS

From

....................

Section Application

[#5]

Not sure I can do that, even I can get user information from BW or somewhere else, it is still not the same thing.

The key to get BW data in our environment (I have been working multiple companies against SAP BW, all the same) is to load data using user's id.

Thoughts?

Thanks!

George