Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML
<script>
  AJS.toInit(function(){
    if (AJS.params.remoteUser == ''){
      AJS.$('#header').hide();
      AJS.$('#main-header').hide();
    }
  });
</script>
<iframe id="topheader" src="https://www.targit.com/layouts/targit13/doc_confluence.aspx" scrolling="no" style="width:100%;height:467px;overflow:hidden;scrolling:no;"></iframe>

Image Modified Back

Download and Install TARGIT Decision Suite

This guide will tell you how to download and install the TARGIT Decision Suite Trial version. The Trial version includes all demo data and demo analyses that have been used throughout this E-Learning portal - so, with a similar installation on your own PC, you will be able to recreate the examples and try out the exercises of this portal.

...

HTML
<div style="margin-left: 30.0px">

<iframe src="https://player.vimeo.com/video/317993608" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>

</div>

Extract Package; Run Accelerator

...

Add or Remove components from the TARGIT installation

Simply run the installation file again if you want to modify your existing TARGIT installation.


HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100099910318170703" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Check for Required Software

...

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100099912" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Required TARGIT Decision Suite

...

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100099914" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

License

The Accelerator needs a license to proceed. This could be an existing license, a newly purchased license or a Demo license that is requested through the Accelerator Configuration Wizard.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100204818" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Product Version; Business Areas

...

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288521" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Source DB and Companies

...

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288522" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Data Marts; Data Refresh Schedule

In the Data Mart step you select then instances on your SQL Server where you want to deploy the Relational and the Multidimensional Data Marts.
Furthermore, the Update Schedule option lets you select at what time of the day you want the solution to be automatically refreshed with new data from the source system.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288523" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Model; Table Match

...

Requirements for Data Discovery and Anywhere

The following requirements must be present for successful installation of the TARGIT Data Discovery and TARGIT Anywhere modules: 

    • TARGIT Decision Suite 2015 or newer
    • A newer browser (IE10 and newer)
    • A valid license that includes the Data Discovery module
    • .NET Framework 4.5 or newer
    • Windows Server 2008 SP2 and newer
    • Enabled Windows Features for:
      • WCF Activation over port and http
      • IIS ASP.NET 4.5 or newer


HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288524318154921" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

...

If you run the Accelerator more than once, you will be overwriting all databases, SSIS packages etc. that have previously been deployed by the tool. This is particularly harmful if, in the meantime, you have made customized modifications to the solution. Hence the Warnings page. Read the warnings and understand the consequences before proceeding.

TARGIT Server Options

The

...

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288599" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

TARGIT Analyses and Reports

...

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288600" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Backup and Restore

The default option for the TARGIT Analyses and Reports is to overwrite any existing documents. This option can be changed from the Advanced / TARGIT tab of the Accelerator.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288601" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Calendars

You can choose your own format for your time dimensions: Normal Calendar dimension as well as a Fiscal Calendar dimension, if necessary.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288685" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Renaming Databases

If necessary, you may rename the databases - e.g. in order not to overwrite existing databases.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288603" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

DB and Log Size

For performance reasons, it is advised to consider and set proper initial DB and Log Files sizes.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288604" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Concurrent Table Transfers

For various reasons, e.g. limitations on your SQL Server platform, you may need to alter the maximum number of concurrent table transfers during the SSIS process. Also, you have the option to run SSIS packages int 32 bit mode, if necessary.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288684" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Master Cube

The 'Master Cube' option will deploy the solution with just one cube, combining data from all Business Areas into one master cube. As opposed to the default setting of deploying one cube per Business Area. Each option has its' pros and cons.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/100288683" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

User Defined Attributes

You can add new attributes to existing dimensions from any of the source tables.

New Dimension

This video will show you how to add a new dimension to your Data Warehouse before executing the Accelerator.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/107246513" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Add table to Table Collection

When working with dimensions, you may need to add further attributes to one of the existing dimensions. If that attribute originates from a column in a table that is currently not part of the dimension, you must add the new table to become part of the dimension's Table Collection.

Dimension Attribute from Calculated Column

Suppose your source dimension table does not contain information in the exact way you would like to present these data to the end-users. In that case, you can add a Calculated Column to your dimension tables. A Calculated Column lets you define custom content, e.g. a concatenation of two existing columns, potentially mixed with static text. The Calculated Column is then immediately available to be used as a new attribute within your dimension.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/128364549" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Dimension Hierarchies

Define your own custom hierarchies on basis of available attributes within the dimension.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/128364547" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

User Defined Measure

The BI Accelerator comes with a number of useful default measures, directly out of the box. On the Advanced step of the BIA Wizard, you have the option to add further User Defined Measures, simply by selecting them from the available transactions (fact) tables.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/128461610" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Measure from Calculated Column

...

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/128461611" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Measure as a new Calculcation

...

Saving and Restoring BIA Projects

Working with BI Accelerator Project files enables you to save all customizations you may have made during the Advanced step of the BIA Wizard.
When you at a later point need to re-run the BI Accelerator, this Project file may be re-opened to restore all customized settings.

HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/128364546" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>

Visual Studio Solution

...

TARGIT Anywhere Configuration tool

The TARGIT Anywhere Configuration Tool is an app for installing and upgrading the TARGIT Anywhere Server.

The app automatically searches for an installed Anywhere Server. If it is found and a newer version is available for the installed version of the TARGIT Decision Suite, the Anywhere Server is updated when clicking Update. If no server is found, the Anywhere Server may be installed at a specified location by clicking Install.

When run again, the app auto updates the Anywhere Server version if a newer version matching the TARGIT Decision Suite version exists.


HTML
<div style="margin-left: 30.0px">
<iframe src="https://player.vimeo.com/video/106379797318175351" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>
</div>



HTML

<style type="text/css">
      #title-text { display: none;} 
      #breadcrumbs, #footer, #likes-and-labels-container, #comments-section { display:none; }	 

div.theme-default .ia-splitter #main {
    margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
    display: none;
}
div#main {
    margin-left: 0px !important;
}
div#footer {
  margin-left: 0px !important;
}

.columnLayout.two-equal
{
padding-left: 20px;
padding-right: 20px
}

#main #content
{
padding-right:0px;
}

div#main
{
padding:0px;
}
#page
{
overflow-x: hidden;
}
iframe#topheader
{
border:0px;
}
.contentLayout2 .columnLayout
{
margin-bottom:0px;
}

#workflow-page-message
{
margin-bottom: 0px;
}

   </style>
<script src="//cep.targit.com/bundle/beacon"></script>

<div class="Footer" style="background-color: #1d252d;width:100%;">
    <div class="loop" style="padding-top:69px;padding-bottom:72px;text-align:center;">
        <img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/footerloop.png" style="margin-bottom:32px;">
        <div style="font-size:24px;line-height:32px;letter-spacing:0.6px;color:#fff;">
            Courage to Act
        </div>
    </div>
    <div style="width:100%;background-color:#121a23;">
        <div style="width:1080px;margin:auto;padding-bottom:20px;padding-top:20px;">
            <div style="float:left;font-size:13px;color:#8a9298;">
                <div style="margin-top:5px;display:inline-block;padding-right:30px;color:#8a9298;">
                    © 2019 TARGIT. All Rights Reserved.
                </div>
                <a style="margin-top:5px;display:inline-block;text-decoration:none!important;color:inherit;font-size:13px;" href="https://www.targit.com/en/personal-data-policy">Personal Data Policy</a>
            </div>
            <div style="float:right;">
                <a style="vertical-align:super;font-size:13px;letter-spacing:0.6px;margin-right:36px;color:#fff;text-decoration:none!important;text-transform:uppercase" href.columnLayout.two-equal
{
width: 85%;
margin: auto;
}
</style>

<script src="//cep.targit.com/bundle/beacon"></script>
<iframe id="bottomfooter" src="https://www.targit.com/en/meet-targit/meet-the-targit-team/contact-targit">CONTACT</a>
                <a style="vertical-align:super;font-size:13px;letter-spacing:0.6px;margin-right:36px;color:#fff;text-decoration:none!important;text-transform:uppercase"  href="https://www.targit.com/en/meet-targit/targit-news/news-list">PRESS</a>
                <a style="vertical-align:super;font-size:13px;letter-spacing:0.6px;margin-right:36px;color:#fff;text-decoration:none!important;text-transform:uppercase"  href="https://www.targit.com/en/meet-targit/targit-career/jobs">CAREERS</a>
                <a style="margin-right: 36px !important;text-decoration: none !important;color: inherit;" href="https://twitter.com/targit" target="_blank"><img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/twitterfooter.png"></a>
                <a style="margin-right: 36px !important;text-decoration: none !important;color: inherit;" href="https://www.linkedin.com/company/targit" target="_blank"><img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/linkedinfooter.png"></a>
                <a style="margin-right: 36px !important;text-decoration: none !important;color: inherit;" href="https://www.facebook.com/TARGIT.BI.Suite" target="_blank"><img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/fbookfooter.png"></a>
            </div>
            <div style="float:none;clear:both;"></div>
        </div>
    </div>
</div>emptyfooter" scrolling="no" frameborder="0" style="width:100%;height:190px;overflow:hidden;scrolling:no;border:0px"></iframe>