Using the Offline Cube Processing feature of tX2012, 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…
> SSASWriteback 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…
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 tX2012 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…
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…
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 tX2012 to…
Slowly Changing Dimensions
Slowly changing dimensions type 1 and 2 is a key to Kimball style dimensional modeling and is of course supported in tX2012 with an easy to use interface, that allows implementation within minutes – without any SQL knowledge required. The tX2012 implementation further includes the use of hashed values for better performance on large dimensions.…
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.
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 tX2012 you are able to deploy multiple cubes and dimensions from separate projects to be…
MDX Code Automation
Comes with MDX and VB function library with syntaxt template. Support for Intellisense. You achieve instant results for efficient prototyping
Advanced XMLA Scripting
Enhances the standard XMLA scripting language, and supports XPATH queries for XML manipulation.