OLAPIsFormula

Description:

This function returns true if the current data point is governed by a formula.

This function is designed to allow a user to identify if a certain data point is governed by a formula or not. The result of the function is displayed as a Boolean value. If the data point is a result of a formula then the function returns "True", conversely, if no formula governs a data point it will return a value "False".

The function takes as a parameter the name of the database, the name of the cube within the database and the members to be accessed in order to determine the exact intersection where the value resides.

The function has the following syntax:

Syntax: OLAPIsFormula (database, cube, member1,member2,…)

• Explained below are the parameters that have to be provided when building this function.
• Database : Enter the name of the database which has the dimension that you want to access / enter the cell reference which has the name of this Database.
• Cube : Enter the name of the cube which exists in this database mentioned above that you wish to access /enter the cell reference which has the name of such a dimension.
• Members k1, k2, …k'n : Enter the name of the member from which a relationship will be established to determine the point where the values have to be read from/ enter the cell reference which has such a member as its value.

Remarks

• If a connection is not established with a database the result will be a #value.
• The database name, the cube name and the member names must be referenced by their exact name and should exist as such within the database.
• The member names should be chosen as such, that they allow the function the to determine the exact intersection points.
• All the arguments are compulsory and neither argument is optional.

Example

This function may be easier to understand with an example.

• Open a specific database and bring a slice from that database into Excel. Make sure that there is connection between PowerOLAP and Excel.
• Click on a certain cell in Excel. Insert OLAPIsFormula function in that cell by selecting Insert -> Function. In the Insert Function dialog box that appears select PowerOLAP as category then choose function OLAPIsFormula. Click OK.
• In the Function Arguments dialog box, specify the reference for database name, cube name and the pertinent dimension names. When finished select OK. If the cell you have specified contains a formula, then you should be getting a value of "True", if the cell is not governed by a formula then it should return "False".