Free form reports may be generated within a data array system such as a
spreadsheet computer application. A user may select dimension members of
a data source, such as an online analytical processing (OLAP) data cube.
The user may position the dimension members as headers on the data array
where multiple dimensions may be represented in one or both axes. Member
formulas are generated that are representative of the headers and include
identifiers that point to the dimension member location of the data
source. Value formulas are generated within the report grid defined by
the location of the headers where the value formulas are representative
of the actual data values of the report and include identifiers that
point to the data value locations of the dimension member locations
within the data source.