Help with Document Security ??

Fri, 11 Dec 2009 16:31:32 GMT

Hi All,

One of our customer has taken one document Qlikview license. That means all the reports have to be in one document.
This will work as long as security is not in place. When we implement security we are getting issues./ Let me explain our scenario.
We have some reports depends on Date , Location and Product. The some others are dependent on Date, Location, Supplier and Product.
We want security to be implemented depending on the Location, Product and Supplier.
Now For first set of reports we can implement security using username, access , Location_nam and Product_num.
We should be able to security for second set of reports using username, access , Location_nam , Product_num and Supplier_num.
That means we should be able to restrict data using two keys for first set of reports and using three keys for secod set of reports.
Is this possible. What I experienced is we cannot have two separate set of security . Is that fine. Also note that in the above example I cannot combine both as for first set of reports supplier will not make any sense.
Can you please help me on this. First question is whether something like this possible? If yes, Please let me now the solution.
If No is it a limitation of QV?
Let me attach my queries for you.
First report:
Absorption:
Load
"LOCATION_NAME",
"LOCATION_NUM",
"PRODUCT_NAME",
PNO,
"BUDGET_ABSORPTION",
"BUDGET_PRODUCTION";
SQL SELECT *
FROM ABSORPTION;

Second Report:
Purchasing:
Load
"LOCATION_NAME",
"LOCATION_NUM",
PNO,
"SUPPLIER_NUM",
PRODUCT,
"PURCHASE_COST",
"PURCHASING_COST";
SQL SELECT *
FROM PURCHASING;

Best Regards

Mahasweta

Help with Document Security ??

Fri, 11 Dec 2009 19:30:20 GMT

Any idea for the same please?

Thanks,

Mahasweta

Help with Document Security ??

Fri, 11 Dec 2009 19:57:13 GMT

Could you not amalgamate the two sets of security fields and simply use '*' where the field is not appropriate?

Regards,

Gordon

Help with Document Security ??

Mon, 14 Dec 2009 16:04:04 GMT

WIll you please say how to do that?

It will be great if you write with the code?

Thanks a ton for your help.

Regards,

Mahasweta

topic Help with Document Security ?? in QlikView

Help with Document Security ??

Help with Document Security ??

Help with Document Security ??

Help with Document Security ??