This function reads a point from an OLEDB compliant cube. You must specify the provider, the data-source, database and cube to read from. You must specify a member for each dimension in the cube. The OLEDBRead function allows the user to pull in values from any OLEDB compliant data source, connects to a cube in the database specified, and selectively pulls in the data that you require from a particular dimension's member and brings this data into PowerOLAP. The cube in PowerOLAP is where the "read" values are stored. This implies that once the OLEDBRead function reads values from the source, then in order to access these values they need to be stored in a location and the location is a cube in PowerOLAP. The dimensions and their members in the cube in PowerOLAP must be an imitation of the dimensions and the members of the source cube in the source database (that are parameters to this function), from where we are pulling in data. Although the cube in PowerOLAP must contain all the dimensions that exist in the source cube, however those dimensions need not contain all the members in the analysis services cube. You may create only those members within which you want to populate values, and display the same. These member names in which you pull in values, must match exactly with the member names in the source database and even a small typing error can be responsible for not pulling in values from the source cube because an exact match is completely necessary.
Syntax: OLEDBREAD (provider, data-source, database, cube, member1, member2,…)
- Provider : Specify the name of the "provider" that is the OLEDB link to connect from PowerOLAP to the source database.
- Data-source : Specify the name of the server that has any OLEDB compliant "Analysis Services" database on it.
- Database : Specify the name of the database in "Analysis Services" which you want to connect to.
- Cube : Specify the name of a cube in the database mentioned above.
- Member1 : Specify the name of the member in the 1st dimension of this cube.
- Member2 : Specify the name of the member in the 2nd dimension of this cube.
- Member-n : Specify the name of the member in the nth dimension of this cube.
Remarks
- The name of the database, the cube and the member names supplied to the function must be a valid and should exist in the database and must be spelled accurately.
- The cube that is referenced above should be allowed access to from the "data source" supplied also as a parameter. The data-source must be valid and operational.
- The provider name should be a valid provider that allows connection to the OLEDB compliant data source.
- All arguments are compulsory and neither argument is optional.
Example
Let us create a new database to illustrate this example. This database is named "AnalysisServicesinPO" and contains a cube called "OLEDBReadCube". The dimensions and their members in the "OLEDBReadCube" are an imitation of the dimensions and the members of the source cube in the source database within the OLEDB Compliant data-source, which in this case for the example is Microsoft Analysis Service and this is from here we are pulling in data. In this example we are pulling in data into our cube in PowerOLAP from the "FoodMart 2000" database in MS-Analysis Services. In this instance we are using the "Budget" cube that exists within this database. Therefore the cube "OLEDBReadCube" in PowerOLAP is a replica of the "HR" cube in "FoodMart 2000".
.png)
This formula above reads values from the "FoodMart2000" database that resides on the data-source, which is the name of a server here, namely, "Escher". The cube that is read from this database is the "HR" cube and for the member names, since we require all the values of all members to be pulled into PowerOLAP therefore we make use of the current function, which ensures that the member name being read by the OLEDBRead function, is the currently selected member name, and when the selection changes the value is also updated. In this way the OLEDBRead function accesses the values from analysis services.