Additional Information

About OLEDB Formula used to create
the cube in PowerOLAP^®

When a new linked Cube is created via PowerOLAP^® Services, a new formula is added to the Cube. This formula, which governs all the cells in the Cube, tells each cell to calculate itself by making a query to an associated OLEDB provider.

Below is an example of such a formula:

All and {}=
OLEDBREAD("MSOLAP.3", "Servername", "FoodMart 2005", "Budget", "[Account].[" & CURRENT("Account") & "]","[Category].[" & CURRENT("Category") & "]","[Measures].[" & CURRENT("Budget_Measures") & "]",
"[Store].[" & CURRENT("Store") & "]","[Time]." & CURRENT("Time") & "");

The formula uses either the OLEDBREAD or OLEDBREADWRITE depending on the user’s selection from the wizard. The first parameter is the provider, the second is the server name, the third is the database and the fourth is the Cube. The formula must then have a member name for each corresponding Dimension in the Cube.

The formula for each Dimension consists of the Dimension name concatenated with the current member for that Dimension. The aggregation of values is performed by the OLEDB compliant source since the formula is an ALL AND formula.

Other Dimension Types supported by PowerOLAP^® Services

Shared Dimensions

The New Linked Cube feature supports shared Dimensions. When creating a New Linked Cube, PowerOLAP checks to see if the Dimension already exists. If so, it assumes this Dimension was already created by another Linked Cube. This Dimension will be added to the Cube as a Dimension.

Date/Time Dimension

Members of a Date dimension type are brought in as fully qualified members. This is done because of the duplication of Member names along this Dimension. A fully qualified member name includes each Member name along the hierarchy to reach the specified Member. For example, Month 1 would be created as [1997].[Q1].[1].