Tag Archives: SSAS

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 →

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 →

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 →

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 →

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