| 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> |
Back
DateTime- Data Discovery Plugin
The SQL Server plugin can connect to a Microsoft SQL Server database and read data from the available tablesDateTime plugin does not rely on any data source in itself. It creates a dataset with a single column of dates (and time stamps). This dataset can be useful when you need a DateTime dimension in your cube.
Adding the Data Source
The SQL Server DateTime plugin is a an 'DatabasesOther' data source.
Name
Enter a unique name for this data source. This is the name of the data source as it will appear in the Data Sources list in TARGIT Data Discovery.
Server
Enter the name of the server hosting the SQL Server you would like to connect to.
Use Windows Authentication
If checked, you must make sure that the service account running the TARGIT Data Service is an account that has access to the SQL Server.
If unchecked, you must provide username and password of an account that has access to the SQL Server.
Database
Once server name and account information have been validated, you will be able to look up and select a database from the drop down list.
Table
Once a database has been selected, you will be able to select a table from the drop down list.
SQL Command
The default SQL Command will be to select all (select *) from the selected table. However, you can enter any valid select statement in this box to produce an output.
Example: SELECT [Code], [Name], [E-Mail], [Job Title] FROM [Stage].[dbo].[Salesperson] WHERE [Job Title] = 'Manager'Start from
If 'Use Dynamic Start Date' is checked, you will get options to enter a dynamic start date such as 1 year ago, 3 months back or last 30 days. All these options are relative to today's date.
Examples: If today is April 15 2020, then 'last 1 years' will give a start date April 15 2019; 'last 3 months' will give a start date January 15 2020; 'last 30 days' will give a start date March 16 2020.
If 'Use Dynamic Start Date' is unchecked, you will get an option to select a specific start date.
End
If 'Use today's date for every update' is checked, the end date of your data range will always be today's date - provided that the DateTime plugin i scheduled to run every day! Otherwise it will be the date of the last time the plugin was run.
If 'Use today's date for every update' is unchecked, you will get an option to select a specific end date.
Use Custom Interval
If unchecked, each entry in the DateTime dataset will be a full date (with a 00:00:00 time stamp).
If checked, you will get an option provide an interval by hours, minutes or seconds. E.g., if you select an interval of 4 hours, each date in the dataset will be represented with a time stamp of 00:00:00, 04:00:00, 08:00:00 etc. as in the example below.
Note: To use the time stamp information for anything useful when you design dashboards, you will need to look into the .raw Dimension folder in the TARGIT client. Look for the 'Date time.raw' dimension.
Use Accurate Time
With this option you can enter a time stamp into the 'Update time' field. The time stamp must be in the format hh:MM:ss.
E.g., if you enter '10:45:00', each of the dates in the dataset will be time stamped with '10:45:00'.
Schedule
Click the ‘Set’ button to configure how often to check update the data for this data source for updated data.
The scheduling options can be set to: Minutes, Hourly, Daily, Weekly, Monthly or Yearly.
| 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/TARGIT_OODA-jigsaw-start-screen.svg" style="margin-bottom:32px;width:100px;">
<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="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>
|