Exposing parameters in referencing worksheets

An apparatus for exposing parameters in referencing worksheets, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:

• receiving a request for a referencing worksheet linked from a data source worksheet, wherein the data source worksheet is a presentation of a data set from a database, and wherein the data source worksheet comprises a function utilizing an exposable parameter, wherein the function is applied within the data source worksheet utilizing the exposable parameter;
• generating the referencing worksheet from the data source worksheet, wherein the referencing worksheet exposes the exposable parameter without exposing the function utilizing the exposable parameter, wherein generating the referencing worksheet from the data source worksheet comprises:
• generating a database query using data source worksheet metadata of the data source worksheet and referencing worksheet metadata received in the request;
• and issuing the database query to the database;
• and presenting the referencing worksheet with the exposable parameter without allowing access to the function utilizing the exposable parameter, wherein the worksheet presents at least a subset of the data set presented by the data source worksheet, wherein presenting the referencing worksheet with the exposable parameter without allowing access to the function utilizing the exposable parameter comprises:
• receiving, in response to the database query, a subset of the data set from the database;
• and presenting, in a graphical user interface, the subset of the data set from the database including organizing the subset of the data set based on the referencing worksheet metadata.

A computer program product for exposing parameters in referencing worksheets, the computer program product disposed upon a non-transitory computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:

• receiving a request for a referencing worksheet linked from a data source worksheet, wherein the data source worksheet is a presentation of a data set from a database, and wherein the data source worksheet comprises a function utilizing an exposable parameter, wherein the function is applied within the data source worksheet utilizing the exposable parameter;
• generating the referencing worksheet from the data source worksheet, wherein the referencing worksheet exposes the exposable parameter without exposing the function utilizing the exposable parameter, wherein generating the referencing worksheet from the data source worksheet comprises:
• generating a database query using data source worksheet metadata of the data source worksheet and referencing worksheet metadata received in the request;
• and issuing the database query to the database;
• and presenting the referencing worksheet with the exposable parameter without allowing access to the function utilizing the exposable parameter, wherein the referencing worksheet presents at least a subset of the data set presented by the data source worksheet, wherein presenting the referencing worksheet with the exposable parameter without allowing access to the function utilizing the exposable parameter comprises:
• receiving, in response to the database query, a subset of the data set from the database;
• and presenting, in a graphical user interface, the subset of the data set from the database including organizing the subset of the data set based on the referencing worksheet metadata.