EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

Creating a YTD transformation table in Microsoft SQL Server

Matthew Pierce

Director, Cloud Support • MicroStrategy

This example shows a scenario to create a YTD transformation table in Microsoft SQL Server. This can be used for YTD, MTD, and QTD transformations which require table based transformations

This below link is an example showing a scenario which can be used to create a YTD transformation table in Microsoft SQL Server.  This can be used for YTD, MTD, and QTD transformations which require table based transformations.  The logic here is assuming there is already a lookup table with unique day data in it.  This can be tweaked as needed and should only be used as a base if help is needed building out transformation tables within a SQL Server warehouse.

ka02R000000kbFzQAI_0EM440000002dGq.png

 


http://www.dietz-solutions.com/2014/05/creating-ytd-transformation-tables.html

 
Third party code/SQL:
Strategy Technical Support does not provide customized SQL queries. The syntax and the error messages shown in this document can vary depending on the database. Please contact your database administrator to obtain the correct syntax for any desired customized SQL using an ODBC driver.
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.

Comment

0 comments

Details

Example

Published:

August 10, 2017

Last Updated:

August 10, 2017