QMC: Least known features 1

Access Management for an application can be done with the field in data model itself. This method could be really useful when we want to grant access to large group of people for multiple applications.

We can maintain excel or DB table with the user list, load that as part of data model for all required applications. This user list table can be orphan table as well, need not be linked unless it really makes sense.

Below steps start with this assumption: There is an application containing orphan user list field (UserID) which needs to be distributed.

1. Create a task for the application as usual, change required is only on “Distribute” tab of Task.
2. QMC -> Documents -> Source Documents -> Distribute -> Loop Field in Document
3. Open Document
4. Select Field “UserID” and Check user identity on “SAM Account Name”.
5. In Destination section, select appropriate QlikView Server location.

6. Trigger the job and make sure it is distributed to intended users in User document -> Authorization tab.

QlikView Supporting Tasks for executing DOS commands

Using QlikView Supporting task to execute dos commands.

QMC->Supporting Tasks -> External Program – > Create new task

Use below syntax with actuals in ‘Command line statement’

“C:\Windows\system32\cmd.exe” /C move /Y “\\source_path\*.txt” “\\destination_path\Archive\”