Skip to content

rileymd88/odag_wizard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

55 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ODAG Wizard

Image of Logo

The ODAG Wizard is a solution which enables the creation of an ODAG Template App. The ODAG script is complex and hard for users new to Qlik to understand and the ODAG Wizard aims to take away this complexity by offering a graphical wizard which guides the users through this process.

It will do the work that takes hours in just a couple of minutes.

ODAG Wizard

Version 1.1

  • Updated icons for June 2019 release

Version: 1.0

  • Beta release

Setup Instructions

  1. Download the ODAG Wizard from here: https://github.com/QlikPreSalesDACH/odag_wizard/archive/master.zip
  2. Once downloaded. Unzip the folder and place it here on your Qlik Sense Server: C:\Program Files\Qlik\Sense\Client The folder structure should look like the following: C:\Program Files\Qlik\Sense\Client\odag_wizard\... (ensure the folder is also named odag_wizard)
  3. You will now need to restart the Qlik Sense Server. Alternativly you can also simply restart all Qlik Sense Services.
  4. You should now be able to navigate to https://<YOUR_QLIK_SENSE_SERVER_HOST_NAME>/resources/odag_wizard/odag_wizard.html If prompted to login, login with your Qlik Sense credentials

Using the ODAG Wizard

  1. Create the selection app. This app will normally have one large fact table with aggregated data and a few dimension tables linked to it Step_1

  2. Choose the Script editor Step_2

  3. Select the data from your main fact table. In this case I am using an SQL database with the ODBC Connector. Since this is a selection app I will not choose fields which contain too much detail Step_3a Step_3b Step_3c

  4. Now modify the script in order to group the data correctly and then load the data . I will do this in the SQL part of the script as this will be faster Step_4

  5. Now create a new section and add your dimensions. For the dimensions we do not have to do anything besides inserting the script. Once the script has been added click on load data Step_5a Step_5b

  6. Now navigate to the app overview and create a new sheet with your visualisations Step_6

  7. Now navigate to the ODAG Wizard found here: https://<YOUR_QLIK_SENSE_SERVER_HOST_NAME>/resources/odag_wizard/odag_wizard.html You may be prompted to login during this step. If so, please login with your Qlik Sense credentials Step_7a Step_7b

  8. From the "Pick Selection Application" dropdown select the app we just created in steps 1-6 Step_8

  9. Then select the data source you used to create the fact table in the app we just created in steps 1-6. In my case it was an SQL database Step_9

  10. Then select the fields which you would like to pass as selections when a user generates a new app from the selection app. You will have the option of passing either only the Selected (green) values, Optional (white) values or Selected or optional values. If the field you have selected is in the format of a date then you should change the Type dropdown from String to Date. You can hit the + and - buttons at the end of the table to add or remove fields. It is also very important that you choose a field which exists in the fact table created in the selection app Step_10

  11. This click the Create Template App button and then click on the Open App button. Now we will work on adjusting the template app Step_11a Step_11b

  12. The ODAG wizard has now automatically generated the ODAG Section for us. We can ignore this part of the script for now and focus on the fact section Step_12

  13. Within the fact section, we will load the same table as we did in Step_3, however this time we will include all details of the table. Step_13a Step_13b Step_13c

  14. Now we will simply add the variable $(WHERE) to my the bottom of the SQL script. In this case I am only using the $(WHERE) variable and not the $(WHERE_DTPART) as well because I did not choose any fields with Type Date in Step_10 Step_14

  15. Now navigate to the Dimensional Data tab and add the same table(s) that you added in Step_5 Step_15a Step_15b

  16. Now add a Where Exists function to your table and ensure you save the script. You should use here the key which is linking your dimenson table with your fact table. Step_16

  17. Now navigate back to the original app worksheet that we created in Step_6 and click on Edit and from the left panel click on App navigation links and create new. If you do not see the App navigation links on the left panel, you will need to ensure you enable it in the QMC first. It can be enabled in the QMC by navigating to https://<YOUR_QLIK_SENSE_SERVER_HOST_NAME>/qmc and then On-demand apps service and check the box which says Enable on-demand app service and then click apply Step_17

  18. Now we will create our on-demand app navigation link. I will first need to give my link a name, then I need to select the template app we just created. The template will automatically have the same name as our selection app with '_Template' added at the end. For the Expression, I have various options on what parameters need to be fulfilled before allowing an end user to generate a new app. In this example I chose to make it that the user needs to first select 5 customers before being able to generate a new app. More information about this topic can be found here: https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/LoadData/creating-OnDemand-app.htm. Once you are finsihed click on create and then drag the newly created link to the bottom of the sheet and hit done Step_18a Step_18b

  19. Now we are ready to test my newly created link. Since we specified that we need to first select 5 or less customers, we need to make this selection before the ODAG link turns green and tells us we can now create the new app. Once the button turns green, click on it and hit generate new app Step_19 Step_19a Step_19a

Once the app is finished loading, you can click on the open in new tap icon on the right to open the new app Step_19c

  1. Now we have created an ODAG app! It should contain only the data for the 3 customers we selected

At this point we could be finished, however if we want the end user to have a predefined dashboard and not have to build thier own visualisations, then we need to first design a new dashboard within our newly created ODAG app by creating a new sheet. Once done designing the visualisations, revert back to the original template app we created and copy and paste your visualisations you just created into the template app. Step_20a Step_20b Step_20c

  1. Now we have created a complete ODAG Scenario using the ODAG Wizard. Step_21a Step_21b

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published