Abstract: Some embodiments are associated with an analytics cloud environment. A user interface may facilitate generation of an advanced formulas planning script by a user. The advanced formulas planning script may be stored, for example, in a planning script data store. An analytic data cube may contain a multidimensional dataset usable for analysis via queries. A conversion platform may receive the advanced formulas planning script and automatically create a structured query language stored procedure based on the advanced formulas planning script. The conversion platform may then execute the structured query language stored procedure on the analytic data cube to calculate a result comprising a base cell and at least one cell has a different point of view associated with the analytic data cube as compared to a calculation source. The calculated result man then be provided to the user.

Abstract: Some embodiments are associated with an analytics cloud environment. A user interface may facilitate generation of an advanced formulas planning script by a user. The advanced formulas planning script may be stored, for example, in a planning script data store. An analytic data cube may contain a multidimensional dataset usable for analysis via queries. A conversion platform may receive the advanced formulas planning script and automatically create a structured query language stored procedure based on the advanced formulas planning script. The conversion platform may then execute the structured query language stored procedure on the analytic data cube to calculate a result comprising a base cell and at least one cell has a different point of view associated with the analytic data cube as compared to a calculation source. The calculated result man then be provided to the user.