Does admin(user) rights is required in document with section access

[#1]

Hi All,

I don't have the admin user in my section access part. As per the document it says that admin user have the authority to restrict edit script,reload,save,etc options for the non admin user. But i admin user is not there in my document. Is there is any way to reduce restrict the user from accessing edit script,reload,save,etc options. Is it must that all the document with section access must have the admin user to restrict the non admin user? As currently we don't want the admin rights in our document.

Also let me know is it necessary that user name should only be 'admin' for the admin user. Can't it be with different name. Something like vadmin or administrator???

Hope some one will let me know the best possible way.

[#2]

Hi Rikab,

You can do everything through one script.

Let your original SQL connection and loading script be in the beginning of the script.

You paste the below script after SQL loading script. It should work.

[script]

// Insert your original SQL connection and loading script here

ItemsData:
load account as ACCOUNT, itemcode as Items_itemcode, pack,
mfaccode as MFACCODE, itemname, userid as Item_userid, password as Item_Password,
MRP, recentitem, schemes, mfacname, contentname, contentname1 resident items;

SalesData:
load account as ACCOUNT, itemcode as Sales_itemcode, Month, Year, Date,
PurQty, PurSch, PurValue, SalQty, SalSch, SalValue, RtnQty, RtnSch, RtnValue,
StkQty, StkValue resident sales;

drop table sales;
drop table items;

Store * from ItemsData into C:\Sajeevan\QlikView\2010\items.qvd;
Store * from SalesData into C:\Sajeevan\QlikView\2010\sales.qvd;

items:
load * from C:\Sajeevan\QlikView\2010\items.qvd(qvd);

sales:
load * from C:\Sajeevan\QlikView\2010\sales.qvd(qvd);

MonthName:
load * inline [
Month, MonthName
1,Jan
2,Feb
3,Mar
4,Apr
5,May
6,Jun
7,Jul
8,Aug
9,Sep
10,Oct
11,Nov
12,Dec];

Quarters:
load * inline [
Month, Quarter
1,Q1
2,Q1
3,Q1
4,Q2
5,Q2
6,Q2
7,Q3
8,Q3
9,Q3
10,Q4
11,Q4
12,Q4];

Half:
load * inline [
Month, Half
1,H1
2,H1
3,H1
4,H1
5,H1
6,H1
7,H2
8,H2
9,H2
10,H2
11,H2
12,H2];

WhatIfDimension_5:
LOAD * INLINE [
Pls Choose One, Column5
mfacname, mfacname
itemname,itemname
contentname,contentname
];

DummyData:
load distinct Item_userid, Item_Password, ACCOUNT, MFACCODE resident items;

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, UACCOUNT, UMFACCODE
ADMIN,Rikab, Rikab2010,ALL,ALL
];
concatenate
LOAD
'USER' as ACCESS, Item_userid as USERID, Item_Password as PASSWORD,
ACCOUNT as UACCOUNT, MFACCODE as UMFACCODE
resident DummyData;

Section Application;
star is *;

LOAD * INLINE [
UACCOUNT, ACCOUNT
ALL, *
];
concatenate
LOAD distinct ACCOUNT as UACCOUNT, ACCOUNT resident DummyData;

LOAD * INLINE [
UMFACCODE, MFACCODE
ALL, *
];
concatenate
LOAD distinct MFACCODE as UMFACCODE, MFACCODE resident DummyData;

drop table DummyData;

[/script]

Thanks,

Sajeevan

[#3]

Hi Sanjeevan!

I will surely check that and will let you know. Though you have reduced few things, final copy is always dependent on external document and qvd. Can't it be avoided too? With out loading from external document is there is any other way to do so? Because maintanence will be very difficult. Whatever the solution i got for this problem all of them were dependent on external file only. May i know why the changes are not possible in the same copy itself.

By the way i will check with the script given by you and will let you know the outcome.

Store * from ItemsData into C:\Sajeevan\QlikView\2010\items.qvd;
Store * from SalesData into C:\Sajeevan\QlikView\2010\sales.qvd;
items:
load * from C:\Sajeevan\QlikView\2010\items.qvd(qvd);
sales:
load * from C:\Sajeevan\QlikView\2010\sales.qvd(qvd);

Thanks and Regards,

Rikab

[#4]

Hello Sanjeevan!

Getting the following error when i tried with your script. Checking the cause of the error. If you have found any solution please let me know.

Thanks and Regards,

Rikab

[#5]

Hi Rikab,

Sorry for late reply as I was in a meeting whole day yesterday which ended at 9:00 PM.

You are not doing what I have asked you to do. Look at my ItemsData and SalesData loading. You can see some variable names are in CAPITAL letter. you need to do similar changes in your Sales and Items loading then remove my scripts of reloading the data.

Thanks,

Sajeevan

[#6]

Hi Sanjeevan!

Sorry for my mistake! I will do the required changes and will let you know the out come.

you need to do similar changes in your Sales and Items loading then remove my scripts of reloading the data .--> Do you mean to say that i don't need to load your sales data and items data when reloading.

Anyway i will try with both the way and will let you know the outcome.

Thanks and Regards,

Rikab

[#7]

Hi Sajeevan!

Getting the following error after the doing the changes requested by you. Also have attached the script. Please look into it.

I am also checking it out why this is happening! Will let you know if i get some solution!

Thanks and Regards,

Rikab

[#8]

Hi Rikab,

I am seeing lot of new additions in your script. I have reworked the script based on your original QVW file (Database2.qvw). Please find attached. Please try with this and let me know issues if any.

Thanks,

Sajeevan

[#9]

Hi Sajeevan!

There are some changes but there is no changes in the main table. Anyway will check the script sent by and will let you know the out come ASAP.

Once again thanks for your effort!

Thanks and Regards,

Rikab

[#10]

Hi Sajeevan!

Replaced the script of my document with yours and getting these errors. I am working around it. Have attached the script which i have used in my document. Please look in to that. Only changes is that i have concatenated the one more data base with that but the structure is same yours.

Thanks a lot for your effort.

Thanks and Regards,

Rikab

[#11]

Hi Sajeevan!

Seems you are so busy! Any chances of closing this which i am facing from such a long long time? Because this is very important part of my document.

If you know any other method please let me know!

Thanks and Regards,

Rikab