Knowledge Base/News and updates/Downloads

tX2012 download

Tobias Eld
posted this on May 08, 2012 12:08

The current version of TX is TX2014 - download TX2014 here.

Version 12.9.9

x86 Editions

x64 Editions

Client or server?

The TX2012 Server software includes the core software and scheduler and server services. This is meant to be installed on the main server. In a single tier setup, only the server installation files are needed.

The TX2012 Client software includes the core software only. This is intended to be used for additional installations in multiple environments, or in separate development or test setups where scheduler and server components are not required.

Prerequisites for all editions

On deploying machine:

  • .NET Frame Work 4.0 Extended
  • Core XML Services (MSXML) 6.0
  • Microsoft SQL Server Native Client
  • Microsoft SQL Server System CLR Types
  • Microsoft SQL Server Management Objects
  • Microsoft SQL Server Integration Services (SSIS) 

Components on destination server:

  • SQL Server 2005/2008/2008 R2/2012
  • Minimum edition is Standard with the following components installed:
    • DB Engine
    • Integration Services (SSIS)
    • Analysis Services (SSAS) (When using cubes)

TX 2012 12.9.9

Bugfixes:

0449: Error message contains too little information: Error Loading Adapter.
0375: Split data movement bug.
0450: Wrong name when deleting an additional nav adapter.
0444: IsDirty not set on custom views when using drag and drop.
0446: Hierarchy Table - Performance problems.
0426: Olap connetion can be wrong when using multiple environments.
0427: Text source unicode checkbox not working.
0439: Wrong field name on NAV Native and sql 2012.
0442: Wrong Error message when deleting used Parent Child dimension.
0441: Bug in MonthSortOrder calculation.
0445: Enable Deletes on History tables performance.
0376: spelling virtual table reference.
0380: Find unused fields does not look at PK or Incremental load fields.
0428: Tooltip for lookup field using fixed value joins.
0433: Excel synchronization problem.
0436: Nav Adapter: Bug in Preview of timestamp field.
0443: Error in QuarterName and HalfYear values in time tables.
0440: Cannot import project with ax adapter and additional connections.
0451: MySql unsupported data types hides the table.

 

TX 2012 12.9.4

Bugfixes:

History tables: Fixed a bug where IsTombstone was not updated and another one that could cause an error when renaming a field on a history enabled table. (Jira Bug-22 and Jira Bug-43)

Markup Scripts: Fixed a bug where an “Error loading markup scripts” was thrown when the dialogue was exited through the Cancel button. (Jira Bug-14). Fixed a bug regarding multiple Value parameters that was not saved when leaving the dialogue. (Jira Bug-54). Fixed a bug regarding problems with saving or loading Script Value parameters (Jira Bug-55)

Script Actions: General restriction on script lengths removed. (Jira Bug-53)

Standard View: Fixed a bug where removal of a field from a view could cause an error. (Jira Bug-42)

Hierarchy Table: Fixed a bug where Hierarchy tables where not marked for deployment after being changed. (Jira Bug-44)

Add Related Records: Fixed a bug where fixed joins could not be used. (Jira Bug-45)

Multiple Environment: Fixed a deserialization error that was thrown if a table failed deployment. (Jira Bug-57)

Warnings/Errors: Fixed a “Cast” error on the Warnings and Error tabs (Jira Bug-58)

CRM Adpater: Fixed a bug where the CRM adapter would only read the first 5000 records of a table. (Jira Bug-60)

Nav Adapter: Fixed a problem with Incremental load on account dependant tables using additional connector. (Jira Bug-61)

Features and Improvements:

Added functionality to support Roles when defining OLAP security and added Environment dependant security setup when using the Multiple Environment Deployment feature. Read more about this new feature and how to set up OLAP security in general here: http://support.timextender.com/entries/20833647-Setting-up-OLAP-Database-Security-in-timeXtender

 

TX 2012 12.8.8

Bugfix:

Single Text File: Selection rules has been disabled on single text file provider. (Jira Bug-3)

Data Movement: Fixed a bug where a Data Warehouse table was not marked as dirty when adding a datacopy from stage or deleting a field from the data warehouse table. (Jira Bug-7)

OLAP Security: Fixed a bug regarding deployment of OLAP security where attribute security on the measure dimension was not deployed. (Jira Bug-25)

Standard View: Fixed an issue with the view keeping details of related tables even after fields from that table was deleted. (Jira Bug-27)

Standard View: Fixed an issue where When adding or editing a lookup field in the view dialog the aggregation was not set correctly. (Jira Bug-36)

Sun Adapter: Fixed an issue with company ID being greater than 3 characters. (Jira Bug-37)

Cube Measures: Fixed a possible error cause where blank spaces could be entered before or after the measure name. The problem was that markup scripts was expecting the blank space in the name, but the Measures was deployed without the blankspace. (Jira Bug-38)

AX Adapter: Fixed an issue with synchronizing against an AX2012R2 database. (Jira Bug-39)

Features and Improvements:

Added an option to change the physical datatype for Integers to any of the 4 integer datatypes: BigInt, Int, SmallInt and TinyInt. The physical datatype can be changed on Custom Fields, on lookup fields and on Data Warehouse fields.

TX 2012 12.8.5

Bugfix:

Cube Writeback: 2 issues was fixed: Writeback cubes with multiple fact tables was non-browsable from the frontend and the writeback table was dropped/recreated during deployment, leaving the table empty after a deployment. While at it, we improved the deployment method so it is much more stable when renaming fields- and/or table names.

DW_Account case sensitive problem: There was a problem with case sensitive databases and the DW_Account field.

Table insert/custom data on custom table: Fixed a problem where the table was truncated between each step, meaning that custom data was lost if there was a table insert on the custom table also. This also fixed a problem with too many truncates if there is multiple table inserts on a custom table.

Stored Procedure deployment error: If a stored procedure failed to deploy, TX would not detect that it failed and would continue deploying without reporting the error.

Elapsed time when running more than 1 hour: The Elapsed time was displayed as a decimal figure instead of time.

Spelling: 2 Spelling mistakes was corrected.

Application Crash after Deployment: Fixed the TX three update to reduce 'Flickering' which was causing an unhandled exception in some cases.

Time Table: Fixed a bug that appeared with Staggered Fiscal Year on SQL Servers using specific regional settings (Germany and United Kingdom).

Fixed a problem on SQL 2012 - SSIS deployment fails when force unicode is set to true.

Features and improvements:

CRM Adapter: Added support for Office365 authentication as an addtion to the LiveID authentication which was already present.

Progress ODBC: Added support for DateTime2 datatype. Since Progress accepts dates that are outside of the boundaries for a standard DateTime datatype, an option to handle datetime field as datatype DateTime2 has been added.

TX 2012 12.8.0

Bugfix:

392: Upgrade error with history table

The cause of this was mainly that an extended property check was not done correctly, thus the table was not recognized as a history enabled table and then it would be dropped and recreated. Subsequently the computed columns were not detected as expected, leading to a side-effect error when trying to recalculate the computed columns.

Features and improvements:

SAP Adapter

To avoid having to build a new TX version whenever the SAP plugin was updated from Theobald Software, we removed the installation of the SAP plugin from the Installer. This means that the SAP pluging (Xtract IS) needs to be downloaded manually and installed by using the vendors installer. 

TX 2012 12.6.0

378

Issue with Multiple Environment Transfer in 12.5.0?

379

Bug in Business Functions Used in Script Commands

TX 2012 12.5.0

 

Features and Improvements:

Support for System.TimeSpan when using ADO.NET for transfer

 

Copy data from fields in the error/warnings tab grid

It is now possible to copy singe fields from the errors grid to use in queries when debugging ETL. Previously copied the entire row.

http://support.timextender.com/entries/21619523-copy-data-from-fields-in-the-error-tab-grid

 

Cube and Dimension Information

When right-clicking a cube or dimension you can select the new advanced option Cube/Dimension Information. The will tell you when the element was last processed/executed.

 

Execution Package - Start from step

When executing an execution package from the right click menu, you can either choose Execute, or the new option Execute From Step which allows you to select from which step to start the execution.

 

SSIS Logging

On the project settings you can now Enable SSIS Logging, this will enable logging on the SSIS packages to the project repository.

Table names:

MSSQL 2005 : sysdtslog90

MSSQL 2008, 2008R2, 2012 : sysssislog (system table)

The generates a lot of logging data, so should be used only when needed.

 

Text file datasource with Fixed Width and Ragged right format

In text file sources users can now choose between three different options

  • Delimited: The normal option,      where fields are delimited by a character, for example comma or semi colon
  • FixedWidth: If each      line is a string, where you need to delimit by number of characters, so      first field is 3 characters, second is 4 and third is 10 characters, you      can specify this as 3;4;10
  • RaggedRight: The last      field is defined by the row delimiter, the leading fields have a number of      characters

 

User specified SSIS Root folder

The reason for this is that when a client is deploying the project it will put all packages in a folde called 'tX2012 Client'.

If a server installation is executing the project it will look for packages in a folder with the name 'tX2012 Server'.

The user can now specify a custom SSIS Root folder name. This is accessed through the project settings dialog.

 

369

Markup   script translation for Hierarchy Level is wrong

366

Dimension browser fails when Provider cannot be found....

340

Data   Aggregation: TX will crash when setting a aggregation to none

337

Spelling...

350

Problem   when deleting object that is used in sql snippet

364

Error   when sync. of external business unit.

365

ADO.net   transfere and money/smallmoney data type problem.

367

Business   Function Script Commands is not deployed.

361

Olap   user cannot be updated on 2012

362

Documentation   error in tX2012 Community

363

Reverse   engineering of a cube with unsupported data types fails

332

Offline   Cube Processing in a Multiple Environment setup problem

368

Adapter   for NAV version 2.60 has problems with non-western characters

329

View   log: Missing information

330

Source   Based Incremental load on Nav Adapter when company name has unicode   characters

333

SysAdmin   privileges needed after change of deployment method to SMO

334

Features   in trial license does not always get loaded on first activation

331

License   Check - Wrong error text

335

Tables   unnecessarily marked as dirty

299

UI   Improvements

319

Transformation   Replace cannot use ' (ping) as Replace Text

328

Find   Unuses Fields does not consider fields used for partitioning

336

Field   of data type sql_variant cannot be part of a hash key

338

Markup   script parameter name cannot be renamed

339

Two   delete hierarchy menu items in the menu for hirerarchy

341

Incorrect   sorting of Execution log data

342

Multible   environment setup close unexpectedly without saving

344

Custom transformations are limited to 1000 characters

345

timestamp   datatype on sql data source and selection rule

346

Lookups   using the Sql mode partition by joins incorrectly

347

Markup   script on Calculated measures and script Commands

348

Command   timeout on sql object creation is always 30 seconds

349

Reverse   data warehouse is not possible for SQL Server 2012

351

Backup   of files is not possible on Multible Text File data source

352

Enabeling   witeback on a cube will fail on deploy.

353

DW_Id   is not set to primary key on tables

354

Documentation   problem when using business function measures.

355

Error   loading a project when using dimesion level as parameter in Calculated   Measure

356

Single   table usage is ignored when using source based incremental load on NAV   adapter

357

Error   creating TXNumbers on case sensetive db 2005

358

Project   cannot be opened - Error loading Markup Scripts

359

Cube   browse should use front database and not database

360

Edit   Custom Field is missing when table is Time Table

 

 

 

TX 2012 12.4.8

New Features:

 

Custom Hash Fields

In scenarios with multiple fields making up the primary key, hashing the values of those fields into a single field can improve lookup performance. Another use of hashed fields can be to easily investigate whether changes has been made to a record or not. The hash field is setup by selecting the fields and the sequence of the fields.

Members with data property on Parent-Child dimensions

The MembersWithData property on Parent-Child dimensions can now be selected directly from timeXtender.

Table Insert with Surrogate Key

Insert data from a stage or data warehouse table into a table on another warehouse while preserving the surrogate key values from the input table. See this post for instructions: http://support.timextender.com/entries/21617801-how-to-persist-a-surrogate-key-from

 

BUG #

DESCRIPTION

0028

Pick Date function returns Invalid date in some countries

0238

Enabling partitioning on an incremental table fails during deployment

0258

Environment Properties is not enabled on activation

0265

Concatination and split is not possible when using a Custom view

0272

Multiple Environments: Parameters on remote environment shown incorrect

0273

Multiple Environments: Missing SSIS Folder for Remote Environment

0280

Conditional Lookup errors:

0282

Change time table on partitioned table

0283

Cannot select an empty file in Textfile datasources

0295

SYSOBJECTS and case sensitivity user defined functions and stored procedues

0297

Slowly changing dimensions with type 1 and type 2 and with update all type 1 - error

0300

Leading blankspaces in dimension attribute names causes an error on deployment

0301

An error occured during save project to repository

0302

If you look at the Execution Log for a specific execution package, you will notice that you have a start time and a end time, but the column Total time is empty.

0303

Incrementally loaded Data Warehousetables on SQL Server 2005 are fully loaded every time

0304

Manual indexes on tables are dropped during execution

0305

Unable to add conditions to a SQL Snippet Transformation

0306

A time-only change in a DateTime field declared as History Type2 field does not trigger a new instance

0307

Unable to read SAP schema with compression enabled on SQL Server 2008/2008 R2 

0308

Case sensitivity with table aliases

0309

Conditional lookup aggregation sql differences

0310

Incremental update of cubes does not update partitions

0311

Error When Deploying/Executing Work Items 

0312

Sun System Adapter should check for version on test connection

0313

Missing mapping of DB2 datatype GRAPHICS/VARGRAPHICS

0314

Spelling and UI

0315

Unused Fields Doesn't Look at Cubes

0321

Oracle read objects problem

0322

Sum on a lookup field with fixed value joins 

0323

Critical: Unable to deploy SSIS packages on DWH

0325

Import - Save as latest version - fails

0326

Deployment of partitioned table fails on second deployment

12.4.8 introduces a major improvement in the deployment speed of projects. The cost of this improvement is - in some cases - that the user deploying the staging- and data warehouse databases needs sysadmin privilege on SQL Server. We are currently investigating if this can be avoided and we will provide an update when we have more information available.

12.4.8 uses SMO (Shared Management Objects) for deployment. This means that the SMO assemblies must be available on the machine where the application is installed. If SQL Server is installed on the same machine, then SMO will also be present. If not, then SMO can be installed separately - see this link: http://msdn.microsoft.com/en-us/library/ms162189.aspx 

TX 2012 12.4.1

New Features

Offline Cube Processing (new licensed feature - contact your partner)

As Business Intelligence (BI) has become a mission critical asset in both strategic, tactical and operational levels of businesses, the demand for minimal downtime of cubes and data warehouses increase. The business simply cannot afford not to have access to these decision support systems to make better and faster decisions.

If you are not on Microsoft SQL Server Enterprise Edition or simply prefer a more managed alternative to the proactive caching feature, the offline cube processing feature of TX 2012 is for you.

The offline processing is achieved by processing an offline version of the SSAS Multidimensional database, while front end access is provided through an online database. At the end of a successful update of the offline version, this will seamlessly replace the online version.

When combined with other performance improving features of TX 2012, such as incremental load this will not only allow minimal disturbance of end users, but also improve the overall load performance.

The offline cube processing feature of TX 2012 is available on Standard editions and above from SQL Server 2005 including the new Business Intelligence edition on SQL Server 2012.

#0267: Enable selection of collation when creating new databases

It is now possible to decide which collation new staging or data warehouse databases are created as. The application default will create it as SQL_Latin1_General_CP1_CI_AS as it has always done. The selected collation is saved with the project, so if you select a collation, move the project to a new server and hit create, the new database will have the same collation as before.

#0268: Search for unused fields

It is now possible to search for unused fields in the business units and data warehouses. The feature will look for any fields that are not used in data movements, lookups, joins, parameters in snippets or transformations etc.

The feature can help you clean up your staging databases and delete fields that are no longer in use. Please use with care on data warehouse as you might want to keep fields there for direct reporting or other uses, even though they are not used on the cubes or dimensions.

Please not that if you use custom transformations/scripts/stored procedures/user defined functions etc. where you have not used the fields as parameters, they will show up as unused.

#0270: NAV Adapter: Enable the user to see Caption, Name or Number in data source view

When browsing a NAV Adapter data source, it is now possible to change between looking at table and field captions, database names and IDs from NAV.

Bug # Description
0254 Physical Valid table setting has no effect - and upgraded project fails
0293 DW_Batch on incremental and history tables
0275 Nav Adapter: Incremental Load - Wrong update of last max value on int
0134 CRM: Occasional error on Read Objects from datasource
0285 Corrected various spelling mistakes
0286 License dialog values are translated into labels
0287 Browsing a dimension and changing tab causes UI to update incorrectly
0288 OEM Menu changes
0290 Unicode does not work for key + name dimension levels
0291 CRM Bugs
0266 Case sensitivity with table aliases - problem with case sensitive stage/DW
0257 Possible deployment error in lookups
0274 OLAP Server sometimes cannot execute
0267 Enable selection of collation when creating new databases
0255 Size of "Add SQL Snippet Transformation" is wrong
0264 Reverse of Olap 2005/2008 has some errors
0269 Version Notes should be visible in project versioning list
0276 Error when using Custom function with data compression on read of sap tables sql2008
0277 Environment setup can fail
0278 Too many cube translation languages are available
0279 Reverse of Olap server 2012 Test connection is wrong
0207 SQL field with data type Numeric(23,0) is handled as bigint in timeXtender
0263 Unable to load projects across client and server licenses (License mapping)

 

TX 2012 12.3.0

 

Bug # Description
0255 Size of "Add SQL Snippet Transformation" is wrong
0242 Nav, AX, Sun and GP adapter does not   truncate incremental table
0256 Custom tables on stage do not load   relations
0259 SAP not working on sql2012
0260 Incremental on NAV SQL2012 fails
0261 Incremental on Sun Adater does not   work on sql2012
0262 Lookup field sorting get deleted   unintentionally
0248 Missing Microsoft.AnalysisServices.dll   in community build
0241 Critical!: One/many to many SUM lookup
0252 Unable to set value for parameter in   SQL snippet
0253 SQL snippets are not categorized in   context menu
0234 Cannot drop field error
0239 In List not working against SAP tables
0243 Some valid datatype for incremental   gives error on incremental table deploy
0244 Custom month name in time table
0245 Incremental rule with timestamp,   decemal etc. will not work
0246 adapter generated fields as DW_Account   can be used as incremental field
0247 SAP Language is not avalible in the   global database setup
0249 Sun adapter loads data sequential
0250 Error in security on olap when having   role playing dimensions
0251 Spelling mistakes
 

Comments

User photo
Steffen Eriksen

Hi Tobias

What are the difference between Client and Server download? As I can read the Community is a free version of tX.

BR

Steffen

 

 

 

May 15, 2012 09:23
User photo
Tobias Eld
timeXtender

Hi Steffen,

I have included short descriptions of the differences between the different downloads in the post above.

Best regards,
Tobias

May 15, 2012 10:19
User photo
Steffen Eriksen

Perfect - thanks.

May 15, 2012 10:20
User photo
Tobias Eld
timeXtender

tX2012 12.4.1 has been released

See release notes in the original post

June 19, 2012 16:11
User photo
Tobias Eld
timeXtender

tX2012 12.5.0 has been released

See release notes above.

September 07, 2012 15:51
User photo
Wim Cos
CALM Co

Hi Tobias. Download links for 12.6.0 aren't working at time of writing. Can you fix them? Thanks!

Hi Wim, The issue has been fixed! 

September 27, 2012 14:00
User photo
Thomas Duun
timeXtender

tX2012 12.6.0 has been released

See release notes above.

September 27, 2012 14:46
User photo
Thomas Duun
timeXtender

tX2012 12.8.8 has been released.

See release notes above.

June 03, 2013 21:51
User photo
Kurt Denolf
AD Ultima

Can we find somewhere older versions of tx on the download links ?  for ex I would need V12.6

June 24, 2013 09:18
User photo
Thomas Duun
timeXtender

You can request old version from our support-system. It is possible for some version to change the URL to download the old version - in example: https://ftp-2.hostedftp.com/~timextender/tX2012/tX2012+Server+12.6....

June 25, 2013 14:06
User photo
Thomas Duun
timeXtender

tx2012 12.9.9 has been released. See release notes above.

August 19, 2013 16:30
User photo
Thomas Duun
timeXtender

tx2012 12.10.0 BETA has been released. Read more here: http://support.timextender.com/entries/30291303-TX2012-Beta-Release

November 29, 2013 10:24