topic Re: Reduce and Loop by NT Username in QlikView

Reduce and Loop by NT Username

Mon, 17 Nov 2014 10:23:24 GMT

Hello everyone,

I have many QVW application having all my regional countries data but when i distribute the document into the Publisher i have to distribute by countries wise for local team people.

Lets assume:

My fact table:

Item,

category,

country,

date,

uintcost,

paidprice

Now what i did I have created one more table for reduce by NTNMAE .

NTNAME:

country,

NTNAME (format - Domain\user)

I have created the task like below screenshot but it doesn't work and I am getting only warning error. i really don't know why and i have referred many blog and tutorials.

I have attached the log file also for your reference. could you please advise how to fix this ?

Best,

Robert

Re: Reduce and Loop by NT Username

ali_hijazi — Mon, 17 Nov 2014 10:27:29 GMT

I've faced such a problem

try to make the values under NTNAME column to be upper case

Re: Reduce and Loop by NT Username

Mon, 17 Nov 2014 10:45:07 GMT

Hi Ali,

Thanks for your prompt reply. yours suggestion doesn't work.

Re: Reduce and Loop by NT Username

ali_hijazi — Mon, 17 Nov 2014 10:52:55 GMT

from the log file QV is not finding any user as the ones found under NTNAME column

the NTNAME is not matching the SAM Account Name

the warnings are set for 6 users

pierre, qvusers, robert, tim,sohil, and stein

are these all the users or part of them?

Re: Reduce and Loop by NT Username

Mon, 17 Nov 2014 11:01:09 GMT

Hi,

yes, My QVW application having six countries data So, i have created 6 NT user in my QV server and I want assign each person to one country.

My aim want to split the QVW as 6 and each user has to access their country data.

Best,

Robert

Re: Reduce and Loop by NT Username

ali_hijazi — Mon, 17 Nov 2014 11:05:14 GMT

there should be a property that matches NTNAME it's either SAM Account Name or User Principal Name

Weird why your NTNAME is not matching Sam Account Name

Re: Reduce and Loop by NT Username

Mon, 17 Nov 2014 11:13:22 GMT

Hi,

I really don't know that why my NT name is not matching ? do I need to change in my Windows system?

Whats User Principal Name - user@domain ?

What should i do ?

I have checked with manual data reduction by country wise, its works fine ... when i go with Loop filed, it doesn't work ?

Best,

Robert

Re: Reduce and Loop by NT Username

ali_hijazi — Mon, 17 Nov 2014 11:17:15 GMT

NTNAME is the field you got in Section Access

it should be Domain\UserName

NTNAME in distribution should match SAM Account Name or User Principal Name

what values have you got under NTNAME field?

it should also be included in a table of your schema

Re: Reduce and Loop by NT Username

Mon, 17 Nov 2014 11:41:09 GMT

Hi,

Indeed, i followed this blog http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access

NTNAME is the field you got in Section Access - Yes, I can Sign In AccessPoint by using NTNAME

I have created one INLINE table in my QVW and its automatically connected with my main fact table, the key is country.

NTNAME:

country,

NTNAME (format - Domain\user)

Then i did the Reduce and Loop task in order to generate the 6 application in my user document.

Best,

Robert

Re: Reduce and Loop by NT Username

Mon, 17 Nov 2014 12:10:22 GMT

Do i need to any changes in QVW application?

Re: Reduce and Loop by NT Username

ali_hijazi — Mon, 17 Nov 2014 12:34:27 GMT

when you create an inline table then the values of NTNAME should match the casing of the values in the section access

for testing purposes remove the section access and see how NTNAME is coming in the table of section access it should match the case you use in the inline table

Re: Reduce and Loop by NT Username

Tue, 18 Nov 2014 03:50:09 GMT

hi Ali

Is this configuration requires active directory, or just normal NT Authentication

Thanks

-wandi

Re: Reduce and Loop by NT Username

Tue, 18 Nov 2014 05:06:57 GMT

Hello all,

I find the solution for my question with help of my colleague(Wandi ).

We haven't add the local directory path in our QMC server after added its works perfect.

Thanks wandi.

Best,

Robert