Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Multiple Reloads & Publishes with Publisher

Hello,

We've recently been required to support multiple versions and environments of our ERP system in our QlikView development environment. For example: Version 1.0 will have a Development and Production environment, while Version 2.0 will have a Development and Test environment.

We have a configuration file for the server that defines which version and environments are required at that moment in time. For example:

Local Configuration.txt contains:

     Version_Environment

     1.0;Development

     2.0;Test

The QVD generators are straight forward:

2014-10-23 11_09_40-QlikView Management Console.png

Each generator can use the Version_Environment variable to determine where to pull the data from and which folder to store the QVDs into.

I'm having trouble with the published reports however. The Published report needs to know at time of the reload which QVD folder it is pulling from. And ideally, I want them to be published as:

Published Report 1 – 1.0 Development.qvw

Pulblished Report 2 – 2.0 Test.qvw


I've tried using combinations of the Reload -> Script Parameters and Loop and Reduce, but so far no luck. The Script Parameters seems to cause multiple reloads without publish, and I believe the Loop and Reduce reduces after both reloads are complete.

Is there a combination of settings that will give me what I want?

Thanks,


Ken

Labels (1)
1 Solution

Accepted Solutions
vgutkovsky
Honored Contributor II

Re: Re: Multiple Reloads & Publishes with Publisher

I see. It's a bit unclear from your screenshot whether Version_Environment is a variable or a field (since it seems to be available as a field value in the "select a field" drop-down), but I'm going to assume it's a variable. I'm assuming you've already tried the below?

Parameters.png

Vlad

6 Replies
vgutkovsky
Honored Contributor II

Re: Multiple Reloads & Publishes with Publisher

Ken, IMO you're trying for too much automation. I would just set up 2 Publisher tasks instead of 1--after all, 2 is still a reasonable number (it's not 100 different versions). Then just use static parameters.

Vlad

Not applicable

Re: Multiple Reloads & Publishes with Publisher

Hi Vlad,

Multiple tasks is the backup plan, but I'm still hoping this can be automated.

We have seven version/environment combinations at the moment, 37 published reports, and an external tool that reloads via EDX triggers. Multiple tasks is doable, but supporting it with the external tool//EDX triggers complicates things a bit. It would be much simpler for me if it was possible to generate a document per data source.


Thanks,

Ken

vgutkovsky
Honored Contributor II

Re: Re: Multiple Reloads & Publishes with Publisher

I see. It's a bit unclear from your screenshot whether Version_Environment is a variable or a field (since it seems to be available as a field value in the "select a field" drop-down), but I'm going to assume it's a variable. I'm assuming you've already tried the below?

Parameters.png

Vlad

Not applicable

Re: Re: Multiple Reloads & Publishes with Publisher

Hi Vlad,

The %ScriptParameter% seems to do the trick. I now have two published reports, each with the passed in variable set correctly. I had been using:

2014-10-23 14_34_57-QlikView Management Console.png

I didn't see ScriptParameter as an option in the Reduced Document Name Template, or the help text that I could find. Is there a list somewhere that shows all the options?

Thanks,

Ken

vgutkovsky
Honored Contributor II

Re: Multiple Reloads & Publishes with Publisher

I just got it by pressing the Script Variable Value button, circled in the screenshot. The buttons represent the full list of possible name components, as far as I know.

Cheers,

Vlad

Not applicable

Re: Multiple Reloads & Publishes with Publisher

I feel stupid now. I thought I had tried it, but I had only been using the Document Field drop down.

Thanks again for the help Vlad,

Ken

Community Browser