<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic NT Section Access - Settings on Publisher in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/NT-Section-Access-Settings-on-Publisher/m-p/535341#M200025</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in Advance for reading post. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regarding : NT Section Access &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We are developing QV dashboard with NT section access functionality (which will use Windows credentails for dashboard).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Follwing script which we are using for NT section access -:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;-------------------------------------------------------------------------------------------------------------------------&lt;/P&gt;&lt;P&gt;Section Access;&lt;/P&gt;&lt;P&gt;LOAD &lt;/P&gt;&lt;P&gt;&amp;nbsp; UPPER(AcessType) AS ACCESS, &lt;/P&gt;&lt;P&gt;&amp;nbsp; UPPER(NTName) AS NTNAME,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; UPPER(REDUCTION_FIELD) AS VENDOR_NAME,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;P&gt;FROM&lt;/P&gt;&lt;P&gt;[..\Data\tbl_QVUserRoles.xlsx]&lt;/P&gt;&lt;P&gt;(ooxml, embedded labels, table is USERTABLE);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;SECTION Application;&lt;/P&gt;&lt;P&gt;-------------------------------------------------------------------------------------------------------------------------&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In above code we are -:&lt;/P&gt;&lt;P&gt;1. Pulling data from Excel file. &lt;/P&gt;&lt;P&gt;2. Reduction field is VENDOR_NAME which is coming from Database. On which we are giving the access to dashboard user.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When i am trying to deployed this dashboard on PUBLISHER it gets failed. I am not able to find out reason. &lt;/P&gt;&lt;P&gt;@ Publisher i am configured TASK as below in Section Access TAB&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;User ID - DomainName\Sanket_Khunte&lt;/P&gt;&lt;P&gt;Password - PASSWORD&lt;/P&gt;&lt;P&gt;(attached )&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Here i am providing mine windows credentials but it fields. MY PUBLISHER IS INSTALLED @ TASCAN LOCATION.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;So Here do we required to provide UserId and Password in Section Acess Tab of QEMC that SERVERS CREDENTIALS.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Please let me know your help will appreciate to me.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Regards&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Sanket &lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 09 Oct 2013 17:26:19 GMT</pubDate>
    <dc:creator>sanketkhunte</dc:creator>
    <dc:date>2013-10-09T17:26:19Z</dc:date>
    <item>
      <title>NT Section Access - Settings on Publisher</title>
      <link>https://community.qlik.com/t5/QlikView/NT-Section-Access-Settings-on-Publisher/m-p/535341#M200025</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in Advance for reading post. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regarding : NT Section Access &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We are developing QV dashboard with NT section access functionality (which will use Windows credentails for dashboard).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Follwing script which we are using for NT section access -:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;-------------------------------------------------------------------------------------------------------------------------&lt;/P&gt;&lt;P&gt;Section Access;&lt;/P&gt;&lt;P&gt;LOAD &lt;/P&gt;&lt;P&gt;&amp;nbsp; UPPER(AcessType) AS ACCESS, &lt;/P&gt;&lt;P&gt;&amp;nbsp; UPPER(NTName) AS NTNAME,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; UPPER(REDUCTION_FIELD) AS VENDOR_NAME,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;P&gt;FROM&lt;/P&gt;&lt;P&gt;[..\Data\tbl_QVUserRoles.xlsx]&lt;/P&gt;&lt;P&gt;(ooxml, embedded labels, table is USERTABLE);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;SECTION Application;&lt;/P&gt;&lt;P&gt;-------------------------------------------------------------------------------------------------------------------------&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In above code we are -:&lt;/P&gt;&lt;P&gt;1. Pulling data from Excel file. &lt;/P&gt;&lt;P&gt;2. Reduction field is VENDOR_NAME which is coming from Database. On which we are giving the access to dashboard user.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When i am trying to deployed this dashboard on PUBLISHER it gets failed. I am not able to find out reason. &lt;/P&gt;&lt;P&gt;@ Publisher i am configured TASK as below in Section Access TAB&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;User ID - DomainName\Sanket_Khunte&lt;/P&gt;&lt;P&gt;Password - PASSWORD&lt;/P&gt;&lt;P&gt;(attached )&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Here i am providing mine windows credentials but it fields. MY PUBLISHER IS INSTALLED @ TASCAN LOCATION.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;So Here do we required to provide UserId and Password in Section Acess Tab of QEMC that SERVERS CREDENTIALS.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Please let me know your help will appreciate to me.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Regards&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Sanket &lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 09 Oct 2013 17:26:19 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/NT-Section-Access-Settings-on-Publisher/m-p/535341#M200025</guid>
      <dc:creator>sanketkhunte</dc:creator>
      <dc:date>2013-10-09T17:26:19Z</dc:date>
    </item>
  </channel>
</rss>

