Lineage / Dependency Analyzer for QlikView

    A free QV App that allows you to visualize your solution as a system of related elements.

    2016-07-04_205123.png


    The application scans your QV environment and automatically discovers dependencies between QVW Apps, QVD Tables, Flat files etc.

    Then it shows you what the properties of the system are: it's goals (i.e. final user analytical apps), inputs and outputs of the elements, the complexity of direct and indirect relations. All in form of a single image - graph. And in lists of course.

     

    Search and navigate the dependencies in an associative manner

     

    Just filter any Entity of interest and instantly find out which other Entities depend on this one, even if they lay far behind in a data flow. So you know where a collision would rise if you made any harmful changes (say removing a field) to this particular Element.

    Analyze the lineage of your data

    When facing a question like "what exact data sources are you using for this specific QVW App?", you'll be ready to answer it in seconds. Just make a search in Entities listbox and filter out the one, then filter Ancestor relations.
    Now you have all the necessary information - a list of all sources and transformations involved in data flows as well as their abstract scheme on the graph.

    Get a visibility into data structures

    Simply said, data in a QlikView solution is organised into Data Models (QVW) plus Data Files (QVD/Flat files) and Tables plus Fields inside them.
    The application helps you find out similarities and differences and relations between those mentioned. For example: which fields are most commonly used and which - least? Which App has the widest Fact table? If you are to make changes to a field - what Apps need to be considered? And so on.


    P. s.

    If you facing the absence of lineage metadata in particular QVWs and workaround suggested on FAQ sheet doesn't suit you please have a look at Rob's alternative approach: https://community.qlik.com/docs/DOC-16993#comment-47699


    Updates:

    2016-07-28 minor fixes based on user feedback (thank you thabang_petje !)

    2016-07-29 minor fixes in interface (influenced by pcammaert )

    2016-09-02 a simple workaround is found for situations when there is a need to add more than 5 folders for scanning - see the following comment https://community.qlik.com/docs/DOC-16993#comment-49157 (thank you tony.hollywood-qi )

    2016-11-18 the script is now open and available at GitHub on the following repository: GitHub - vasiliy-petrenko/QlikView-Lineage-Dependency-Analyzer. Please feel free to learn and contribute!