formulas

Can be entered directly into cells, selected in the Insert Function dialog or you can use the Edit OLAP Formula dialog. The Edit OLAP Formula dialog offers three key types of formula. These are Cell Value formulas, Attribute formulas and KPI (Key Performance Indicator) formulas. The Edit OLAP Formula dialog creates the default formulas for the three types. These are ROC, ROA and ROK formulas respectively. An ROC formula returns a numeric or text value from an OLAP data cube. An ROA formula returns an attribute from the attribute table of a dimension.An ROK formula returns a result according to which KPI and KPI type is selected. The result can be displayed graphically or as a value. ROC and ROA formulas are read only. But, by changing ROC formulas to RWC ,or ROA formulas to RWA the values they return can be written back to the database. Other formulas are used to act in various ways on cell values or attributes.