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.
