Does admin(user) rights is required in document wi... - Page 8 - Qlik Community

Permalink · ‎2010-02-04

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.

Permalink · ‎2010-03-04

Hi Sajeevan!

I am able to load the data but there are some issues with charts and document response is very slow.

I will try to send the document from qlikview website once again let's see what happens.

Thanks and Regards,

Rikab

Permalink · ‎2010-03-04

<body>Hi Sajeevan/ Rikab, Do not know whether u have been able to resolve ur problem... Noted your exchanges on the section access. I also faced lot of problem implementing the same in my company.. I am unable to upload the file ...here is the excel file for section access. It works perfectly ...even provided field level security. <col width="1116"></col> <tr> <td width="1116" height="17">SECTION ACCESS;</td> </tr> <tr> <td height="17"></td> </tr> <tr> <td height="17">LOAD </td> </tr> <tr> <td height="17"> Upper([USERID]) as [USERID],</td> </tr> <tr> <td height="17"> Upper([ACCESS]) as [ACCESS],</td> </tr> <tr> <td height="17"> Upper([PASSWORD]) as [PASSWORD],</td> </tr> <tr> <td height="17"> Upper([NTNAME]) as [NTNAME],</td> </tr> <tr> <td height="17"> if(Isnull(OMIT),'',SUBFIELD(OMIT,';')) AS OMIT,</td> </tr> <tr> <td height="17"> if(Isnull(CNT),'',CNT) AS CNT,</td> </tr> <tr> <td height="17"> if(Isnull(REG),'',REG) AS REG,</td> </tr> <tr> <td height="17"> if(Isnull(SEG),'',SEG) AS SEG,</td> </tr> <tr> <td height="17"> if(Isnull(SEGSAL),'',SEGSAL) AS SEGSAL,</td> </tr> <tr> <td height="17"> if(Isnull(CC),'',CC) AS CC,</td> </tr> <tr> <td height="17"> if(Isnull(USER),'', USER) AS USER ,</td> </tr> <tr> <td height="17"> if(Isnull(USERGRADE),'', USER) AS USERGRADE </td> </tr> <tr> <td height="17">FROM (biff, embedded labels, table is SUPERSTATUSERS$);</td> </tr> <col width="98"></col> <col width="56"></col> <col span="2" width="103"></col> <col width="66"></col> <col width="30"></col> <col width="50"></col> <col width="30"></col> <col width="55"></col> <col width="23"></col> <col width="268"></col> <tr> <td width="98" class="xl68" height="17">USERID</td> <td width="56" class="xl68">ACCESS</td> <td width="103" class="xl68">PASSWORD</td> <td width="103" class="xl68">NTNAME</td> <td width="66" class="xl68">OMIT</td> <td width="30" class="xl69">CNT</td> <td width="50" class="xl68">REG</td> <td width="30" class="xl68">SEG</td> <td width="55" class="xl70">SEGSAL</td> <td width="23" class="xl68">CC</td> <td width="268" class="xl68">USER</td> </tr> <tr> <td class="xl68" height="17">*</td> <td class="xl67">ADMIN</td> <td class="xl76"><a href="mailto:Hempasil@2007">*</a></td> <td class="xl75">Administrator</td> <td class="xl67"> </td> <td class="xl69"> </td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl70"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> <tr> <td class="xl67" height="17">AR00209</td> <td class="xl67">USER</td> <td class="xl67">SHAHEEN</td> <td class="xl67">*</td> <td class="xl67"> </td> <td class="xl71">83</td> <td class="xl67">SACR</td> <td class="xl67">2P0</td> <td class="xl72"> </td> <td class="xl67"> </td> <td class="xl67"> ASLAMKHAN </td> </tr> </body>

Permalink · ‎2010-03-07

Hi Rikab,

I manged to download the file from home.

The first problem with your file is that you have a synthetic table. This could be one reason for slow reponse. This is occuring from your table new. Please rename the variable - mfacname, itemname and contentname. Please have the script like below

new:
LOAD DISTINCT mfacname as n_mfacname,
mfacname &'|'& itemname &'|'& contentname as Hierarchy,
itemname as n_itemname,
contentname as n_contentname
RESIDENT items;

You need to add same Hierarchy variable creation in your items table too for linking with table new. I think you need the table new for selections.

If you are having calculations based on many IF conditions, that can also impact the response time.

Thanks,

Sajeevan

Permalink · ‎2010-03-08

Hi Rikab,

Further to my previous email, you are having too many dimensions in reporting e,g, contentname within itemname within mfacname is a huge dimension which will obviously takes more time to process.

You check the Calc Time for every object within every sheet. Click "Settings" then click "Sheet Properties" then select "Objects" page to check the Calc Time and memory usage for each object. Hope you will find ways to reduce the calc time.

Best Regards,

Sajeevan

Permalink · ‎2010-03-08

Hi Sajeevan!

Thanks for your reply! But sorry that I am not replying to you. I will work on your changes the will get back to you at the earliest.

Thanks and Regards,

Rikab

Permalink · ‎2010-03-08

Hi Rikab,

Don't worry. Hope you have no issues in terms of access controls.

Please give some attention to the results you are getting. It seems the sales figures you are getting from sales data is wrong because you don't have a proper link betweek databases. If you are looking for the sales figure from sales data using the mfacode in items, you need to have a proper link between the records. Just thought informing you hence please check all figures before you deliver this to someone.

Best Regards,

Sajeevan

Permalink · ‎2010-03-19

Hello Sajveevan!

I have been given other assignment these many days so did not get time to check the solution given by you. Hopefully i will check it by today if I don't get any other assignment 🙂

Thanks and Regards,

Rikab

Permalink · ‎2010-03-19

Hi Sajeevan!

Further to my previous email, you are having too many dimensions in reporting e,g, contentname within itemname within mfacname is a huge dimension which will obviously takes more time to process. --> It is same as previous one. Anyway will check that and let you know.

You check the Calc Time for every object within every sheet. Click "Settings" then click "Sheet Properties" then select "Objects" page to check the Calc Time and memory usage for each object. Hope you will find ways to reduce the calc time. --> I am not able to find the objects page. Let me know where it is so that I can check the memory usage

Thanks and Regards,

Rikab

Permalink · ‎2010-03-19

Hi Sajeevan!

Don't worry. Hope you have no issues in terms of access controls. --> I need to check that and let you know!

Please give some attention to the results you are getting. It seems the sales figures you are getting from sales data is wrong because you don't have a proper link betweek databases. If you are looking for the sales figure from sales data using the mfacode in items, you need to have a proper link between the records. Just thought informing you hence please check all figures before you deliver this to someone. --> Sure! I will check the result and let you know. Previously also I have used the same thing. I didn't had any problem with that. The figure was correct last time.

Anyway will check both the things and will get back to you

Thanks and Regards,

Rikab

Permalink · ‎2010-03-19

Hello Sajeevan!

The first problem with your file is that you have a synthetic table. This could be one reason for slow reponse. This is occuring from your table new. Please rename the variable - mfacname, itemname and contentname. Please have the script like below --> Added the script same as given below but still facing the same problem

new:
LOAD DISTINCT mfacname as n_mfacname,
mfacname &'|'& itemname &'|'& contentname as Hierarchy,
itemname as n_itemname,
contentname as n_contentname
RESIDENT items;

You need to add same Hierarchy variable creation in your items table too for linking with table new. I think you need the table new for selections.

If you are having calculations based on many IF conditions, that can also impact the response time. --> It is indeed very very slow.

Also after adding the your script the result which I am getting is incorrect. But whereas with my script the result is correct.

Please check and let me know what can done.

Have sent the document using sendspace to your mail id.

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