Single Application for different groups of users

[bmenicucci]

Hi all,

I'm struggling to find a way to manage different groups of users with a single application. Those groups differ as their data are not stored in the same place. Also, the company doesn't want the data merged. Does anyone out there had a similar challenge?

Any help appreciated. Thanks!

[albertovarela]

It's clear they don't want the data merged but have you explored / demoed dynamic data reduction through Section Access? It works like a charm.  

[bmenicucci]

Hi Alberto, thanks for your prompt reply. Section access in already in place, though here we are talking about two companies of the same group that could share the application but not data. And as I'm quite lazy (😁) I hate to have to duplicate the app and the scripts every time there is an update!

[albertovarela · Accepted solution]

Most great developers I know are lazy too, so kudos for that 😉.

Other option is to use variables to control the "lib" where you are pulling the data from. For example 

SET vQVDPath = 'lib://Container_Company1/1.QVD/3.Load';

then use the variable on the Load statement

QVD1:

LOAD * FROM [$(vQVDPath)/QVD1.qvd] (qvd);

By doing this you could use the same App published 2 times (with different folder connection or lib)

I hope this helps.

[bmenicucci]

Hi AlbertoV,

thanks for having pointed me toward the solution!

[albertovarela]

My pleasure.