Looking for the current version of TimeXtender's platform? Download Discovery Hub 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.
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.
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.
|
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 |
12 Comments