Wednesday, June 30, 2010

Unavailable Restricted

Olap Pivot Tables and


For those who enjoy working with pivot tables in Excel is very good news. Palo ODBO the provider you can connect to Palo cubes from Excel 2003, 2007 or 2010. This fact is important especially for users already accustomed to working with this useful tool in Excel.

Before you can access a cube with ODBO provider, we should point Modeller in what the dimensions of time and containing the metric as a standard cube Palo these do not require a special distinction.


The rules we observe are:

1 .- In each cube you wish to access must be a dimension called "Measures"
2 .- Each dimension should have only 1 top-level element. The equivalent of "All."
3 .- Palo parallel hierarchies are not allowed. For each element a single parent is allowed.

An important detail MDX is working with the changing structure of the dimension of time. In a traditional hub Palo
commonly use a dimension that contains the elements of the years eg.: 2009,2010,2011 and one that contains the months of January to December, and the crossing of the two provides the context while we are viewing.

MDX to meet and work correctly, the provider of Palo ODBO requires the time dimension contains all the elements of time. The size would be as follows: where
2009_H1_Q1_M12_W4_D1
H: half of the year will
Q: will
quarter
M: W
will
months: will
weeks
D: is the day

or Year to Month Year to Date

While it is true that Palo not requires this type of dimensions, it is necessary that we occupy if we are to access our cube with MDX. The prefixes may be different but the important thing is to give us information on what level you are positioned.

levels are still valid options such as having 2009_D1 (year-day) or the entire structure.

Saturday, April 3, 2010

What Causes Sagging Joists

Finally Palo Palo BI Suite 3.1 GA is available


The Jedox March 31 announced the general availability of version 3.1 of Palo BI Suite. The image before the text is not Excel 2007 is the web interface of product development.

community The new version is considerably faster than the pre-release or Ramp-Up version. It is noted that the Jedox development team worked hard to solve performance issues that had the ramp-up version and some bugs. It also includes dashboards, reports and data entry as a demo.

The new facility will not need to uninstall previously. The installer is detecting the previous version, keep the development and install the new software.

I can comment that the speed improvements are noticeable web version.

As previemente Jedox had announced this new version removes the Report Manager and OLAP Web interface manager. These two components will only be available in retail version.

The link to download the new version here

Tuesday, March 23, 2010

How Much Does An 80 Watt Fan Cost To Run?

Google Fusion Table, "a new suite of BI? Palo

few days ago I tried Google Fusion Tables a product of Google Labs The truth is that this giant of the technology is rapidly covering many areas and as one of the main utilities for users of Google's information retrieval a next step is to analyze it.

Although in its infancy and can display a new business intelligence application which makes use of BigTable, MapReduce and feeds into the information repositories.

-data analysis of earthquakes in Chile between 11 and 16 March 2010. Few data, but the idea is to show some of the functionality.

Here are some views:

automatic geolocation



Scatter graphics





line graphs




Movement



is one of the most striking but unfortunately I could not include here. The link is view http://tables.googlelabs.com/DataSource?snapid=33110 . You can change your Colors exclusive "and" Size "and select the different" tabs. "

For those interested the link is http://tables.googlelabs.com/DataSource?dsrcid=146304 . Test the various options in the menu option "Visualize"

The Fusion Tables provide facilities for to merge with other tables, filtering and aggregation functions.

be followed closely.