Archive | Features RSS feed for this section

Enchanced SQL Server Analysis Services Feature Support

As in previous releases, TX2014 utilizes and enhances the features of Microsoft SQL Server Analysis Services (SSAS). This release comes with even more support for SSAS features. You’ll now find it much easier to work with cube dimensions, actions and measures.  

Continue Reading →

Data Warehouse Types Synchronization

Easy Synchronization of Data Types When the data types in your system don’t match the data types of s a frustrating situation. It’s time-consuming and tedious work to get it right. TX2014 changes that. Simply use the Synchronize Data Types feature to verify that a data type in a data warehouse table matches the data

Continue Reading →

Custom Data Import

Effortless Import of Custom Data from Microsoft® Excel® Excel is often the tool of choice for custom data entry. That’s why you can now import custom data directly from Excel into TX2014 – fast and easy. This means, you can take advantage of all the data entry features in Excel such as AutoComplete, copy and

Continue Reading →

Cube Perspectives

What You See Is What You Need While some cubes are limited in scope, others are very complex and contain multiple measures and dimensions. For a business user, it can be a frustrating experience to navigate the measures and dimensions of a complex cube when trying to locate the data that is relevant for their

Continue Reading →

Offline Cube Processing

Using the Offline Cube Processing feature of TX2014, we have reduced the OLAP processing time considerably, and we can process the data cubes several times a day. We have practically no downtime anymore and the end-user experience has improved greatly.” Martin Krogh Nielsen, Business Analyst, Wrist Ship Supply   As Business Intelligence (BI) has become

Continue Reading →

Writeback for SSAS Multidimensional

Cube writeback is used for budgeting, forecasting or any other scenario in which you need to enter data into your reporting structure. As an example you can imagine a budgeting scenario where actuals is provided by the source systems, while the budget amounts are entered in a front-end application such as Excel or Calumo. The

Continue Reading →

Language Control for SSAS Multidimensional

When you operate in a multilingual environment, there is a need to deliver the presentation layer to the consumers of cubes in multiple languages. The translation capabilities of TX2014 allows you to easily maintain the translations for multiple languages in a single screen. Translations include both captions/labels for dimensions, measures, display folders etc. as well

Continue Reading →

Data Compressions

Data compression is to your database what zip files are to the file system. It significantly reduces data storage and disk operations, both leading to improved performance. Storage is commonly reduced by 40-90%, depending of the compression type used: Row or page on staging areas and data warehouse respectively. Performance can often be improved by

Continue Reading →

Multithreaded Execution

By default, execution of SSIS packages, data cleansing, dimension and cube processing etc. is performed single threaded. This means that TX2014 will only initialize calls towards SQL Server from a single thread (single process). With multithreaded execution it is possible to configure execution packages with a user-defined number of concurrent threads, which will execute against

Continue Reading →

Team Development

TX2014 supports multiple concurrent developers, effectively allowing true team development. In timeXtender products previous to tX2012, objects were locked at project level and although there are ways to use multiple projects to support multiple concurrent developers, a project is normally considered as the smallest amount of work for a single developer. In TX2014, it is

Continue Reading →

Template Data Sources

When you need to extract data from multiple data sources of nearly identical structure, template data sources is there to help. In logical terms it is based on a single data source (the template) that is used to extract the source Meta data such as tables, views, fields, data types. An unlimited number of additional

Continue Reading →

Multiple timeXtender Projects

In TX2014 you design and build your data warehouse solution within the context of a project. A project can be considered as a container that holds all the objects such as data sources, staging databases, tables, views, stored procedures, dimensions, cubes etc. TX2014 comes with one project out of the box, but you can add

Continue Reading →

Cubes

An online Analytical Processing (OLAP) cube is a very powerful technology for multidimensional analysis of very large amounts of data. Following the dimensional data warehouse model, data is divided into facts and dimensions where facts represent the (mostly numerical) values we want to measure and dimensions describes the context of the measures. If you imagine

Continue Reading →

Export / Import Projects

The Meta data of a TX2014 project is persisted in the repository, using a SQL Server database for storage. This optionally also include version control and multiple environments transfer for automated promoting Meta data from development to test, QA, production environments. In addition it is also possible to export and import the Meta data in

Continue Reading →

Data Warehouse

The overall purpose of a data warehouse is to integrate corporate data from various internal- and external data sources. Data is collected over time and stores historical events that are often not persisted in the source systems and is also commonly referred to as the single version of the truth, making the data warehouse an

Continue Reading →

Data Staging

The data staging area is a temporary location for data between the source systems and the data warehouse. This is where source data is copied to in the extract phase of ETL and is the first integration point for data coming from multiple source systems. This is also where the majority of data cleansing and

Continue Reading →

Data Lineage Diagrams

Most data warehouse developers have experienced the challenge of answering a common question like “what data source fields are we using for this measure?” and sometimes you can even add “and what are we doing to it in the ETL process?” If you are one of the many, that either do not have complete end

Continue Reading →

CubeStore

- Is a secure Cloud-based distribution platform that supports reuse of projects. The CubeStore enables you to reuse your projects as project templates that can be downloaded directly into timeXtender. Once a solution has been downloaded, it can be up and running within hours, and can be customized and extended.   Visit CubeStore  

Continue Reading →

Documentation – Full Printable

- Fully automated generation of Documentation, including full version control to ensure that the generated documentation corresponds to the deployed version of the project. Comments can be added to all elements in the project. The template can be modified and the documentation comes as a hyperlinked PDF document. The documentation is valid for IT Audit

Continue Reading →

Multiple Environment Deployment

Before I started using Multiple Environment Deployment, I had to build cubes outside of office hours, so that I didn’t disturb users in their work if I made mistakes or had to deploy new cubes.” Flemming Andersen, IT Manager, JP Group   As the BI backend has become a mission critical asset, it is often

Continue Reading →

Trace

Complete trace of a single entity within the Meta model. Trace between the cube and data source(s). See [Data Lineage Diagrams]

Continue Reading →

Version Control

Version control, also known as revision control, manages the changes done to a project in TX2014. A project is defined as the collection of objects such as tables, dimensions and cubes but also includes settings for source and destination connections. Version control has two major benefits, serving the purposes of documentation as well as the

Continue Reading →

Data Quality

- Enforcement of implicit and explicit primary- and foreign key constraints. – Enforcement of threshold values. – Row or value based checkpoints and notifications.

Continue Reading →

Reverse Engineer Data Warehouse

If you have an existing SQL Server data warehouse, the reverse engineering feature allows you to import tables, views, primary key and foreign key constraints, stored procedures and user-defined functions into the TX2014 meta model. This is especially useful when converting your hand coded data warehouses into timeXtender, and means that you do not have

Continue Reading →

Automated Performance Optimization

- Hash-bytes – Compressions: supports row-and table based compression on both staging and data warehouse. Implemented automatically based on table classification. Can be manually configured in advance mode.

Continue Reading →

Data Warehouse Hierarchy Builder

- Visual builder for GL acccounts dimension (balance sheet, income statement). – Include custom rollup formulas (dimension calculations). – Generic usage for mapping any structure into reporting format.

Continue Reading →

Indexes

TX2014 supports both automatic created indexes as well as rich capabilities to add your own non clustered indexes to fine tune the load performance of your data warehouse platform. Automatic indexes are added based on table classification such as dimension/fact/large/normal and transformations done on a table, to ensure well performing code out of the box.

Continue Reading →

Lookups

One of the most commonly features of TX2014 is the ability to look up a value across tables using a simple drag and drop interface. Lookups can be used to perform both simple tasks as fetching a single value from a related table based on one or more joined fields, but also in more complex

Continue Reading →

Move Projects As XML Between Installations

- Move or copy an entire solution between installations, customers, or environments. – Works across different SQL Server versions and editions.

Continue Reading →

Multithreading

As part of getting the best load performance, it is possible to design execution packages for multi-threaded execution – or parallel execution, using a user-defined number of threads per package. The flexible design capabilities allow configurations such as a single threaded master package that controls multi-threaded sub packages. Another common configuration is a “string of

Continue Reading →

Table Partitions

Table partitioning offers the ability to separate the contents of a logical table into separate physical storage units. This can greatly improve performance as only the partition(s) affected by a query, an insert or update operation will be touched. TX2014 manages partitions with a template based approach, which allows easy reuse of partition patterns across

Continue Reading →

Time Dimensions

The most common of all dimensions is time, since there is virtually no reporting or analysis done without the context of when. A time or calendar dimension can always be derived of source data, as any other dimension. Additionally you can also take advantage of the time table and time dimension features in TX2014 to

Continue Reading →

Work Items

Work Items is a check in/check out feature that is used to keep track of who is working on which objects in a multiple concurrent developers scenario. It helps prevent conflicting changes. Note that Work Items is not a lock/unlock mechanism and it doesn’t prevent conflicts. You can also use Work Items in a single

Continue Reading →

Uploading QuickCubes Projects to The CubeStore

You can now protect and upload projects to the CubeStore directly from the timeXtender client. Note that this feature requires a license that contains the Protect Project feature. You access Upload to CubeStore from the Partner Menu. To upload a project to the CubeStore Protect the project by specifying a project ID. If it is

Continue Reading →

SQL Snippets

This new feature is the SQL counterpart to Business Functions. It is parameterized and reusable SQL. When you use SQL Snippets your SQL transformations will be strongly typed. This means that when a table or fieldname is changed, the transformations that use them are also changed. To add a snippet From the Tools menu, in

Continue Reading →

QlikView modeler & script generator

QlikView® is a very popular presentation tool, which allows business users to rapidly build views and dashboards. The back end implementation however very easily gets quite complex and time consuming, due to the need for scripting. Using the TX2014 drag and drop interface, you create QlikView® models ready for import into your QVW documents, thus

Continue Reading →

MDX Calculation Scripts

MDX Calculation Scripts allows you to add MDX outside of the measure context. This makes it easier to add elements such as members, sets and scopes to the cubes. Technically, the calculation scripts are placed in the CALCULATE; area right after the calculated measures. Calculation Scripts Example In earlier timeXtender versions, the calculated measure script

Continue Reading →

Markup Scripts

Markup scripts are parameterized scripts that can be used for custom selection rules, transformations, custom views, user defined functions, stored procedures, calculated measures, SQL scripts, and OLAP scripts. The main purpose of markup scripts is to avoid scripts that break when objects are renamed. If the script is reusable, we recommend that you use SQL

Continue Reading →

Managed IBM iSeries DB2 Provider Support

Support for iSeries Access OleDB and .NET wrapped/managed OleDB has been added to support iSeries version 5.3 and later. This means that DataDirect is no longer supported for iSeries. However, it will still be used for zOS based DB2 databases. The managed iSeries DB2 connector has been added to handle extraction from legacy versions of

Continue Reading →

Incremental Load

To improve load performance for very large tables, a feature called Target-based Incremental Load was introduced with timeXtender version 4.5. This feature controls how data is inserted, updated, and deleted between the raw and valid table instances. The Target-based Incremental Load feature is especially useful in scenarios where the source system cannot reliably identify new

Continue Reading →

Geography and Geometry Datatype Support

timeXtender now supports the spatial data types Geography and Geometry. You can use these data types in some cube frontend tools and some data warehouse reporting tools such as Microsoft SQL Server Reporting Services. CTP2  Note: When you copy a table from the staging database to a data warehouse, the datatype for Geography fields is

Continue Reading →

Force Unicode Conversion of SQL Server Sources

When you add a SQL Server data source, it is now possible to select a Force Unicode Conversion option. This results in a conversion of all fields on the staging area to Unicode. This feature is useful when a SQL Server data source consists of additional data sources. The Force Unicode Conversion box must be

Continue Reading →

Support for Multiple Concurrent Developers

In timeXtender 2012, we have added enhanced support for multiple concurrent developers. In previous versions, when you opened a project that was already opened by another user, a warning was displayed and you were asked whether you wanted to take over the lock-privilege of the project. This prevented the other user from saving the project.

Continue Reading →

Slowly Changing Dimensions

Slowly changing dimensions type 1 and 2 is a key to Kimball style dimensional modeling and is of course supported in TX2014 with an easy to use interface, that allows implementation within minutes – without any SQL knowledge required. The TX2014 implementation further includes the use of hashed values for better performance on large dimensions.

Continue Reading →

Business Functions for SSAS Multidimensional

Wrap commonly used calculations for easy reuse. Use them across installations and projects through import/export. Parametrize calculations for easy maintenance. Hide complexity from business users.

Continue Reading →

Merge Deployment on OLAP

A limitation in the native Microsoft tools is preventing multiple cubes from different projects to be deployed into the same SQL Server Analysis Services (SSAS) database. The native functionality causes the last deployment to overwrite any previously deployed databases. With TX2014 you are able to deploy multiple cubes and dimensions from separate projects to be

Continue Reading →

MDX Code Automation

Comes with MDX and VB function library with syntaxt template. Support for Intellisense. You achieve instant results for efficient prototyping.

Continue Reading →

Reverse Engineer for SSAS Multidimensional

If you have an existing set of cubes, the reverse engineering feature allows you to import the dimensions, cubes, measures, calculations of an Analysis Services database into the TX2014 meta model. This is especially useful when converting your hand coded cubes into timeXtender, and means that you do not have to create your cubes from

Continue Reading →

Advanced XMLA Scripting

Enhances the standard XMLA scripting language, and supports XPATH queries for XML manipulation.

Continue Reading →
Links:ray ban femmeoakley pas cherray ban pas cherabercrombie pas cherray ban femmeray ban hommeray ban hommeray ban pas cherray ban parisray ban homme pas chercheap ghd straighteners