Applyolap, like applysimple, is used to define metrics but differs in that it only accepts metrics as input. It is not advisable to use apply functions when functions within the microstrategy product can accomplish your goal, because using apply functions bypasses the validations that microstrategy provides. This metric divides the sum of vol fact at report level by net weight after applying it a character replace at bbdd level with oracles replace function it seems that the bbdd is oracle, and breaks it down by product. For more information on the different types of metrics that can be used in microstrategy reports, see the metrics section of the microstrategy developer help formerly the microstrategy desktop help.
It is used to define compound metrics via databasespecific functions such as rank. In microstrategy, these functions provide access to functionality and syntactic constructs that are not standard in microstrategy, but are found in various rdbms platforms. Applysimple you can use the applesimple function to insert databasespecific functions and simple operators directly into sql. Microstrategy forum view topic sequence number generation. Metric expressions in command manager use a specific syntax. The information requested by this form is required by us in order to provide you with the services you are requesting and will be used by us for the purpose of providing such services. Case functions return specified data in a sql query based on the evaluation of userdefined conditions.
You can use the applysimple function in a metric definition as follows. How to write passthrough filters using applysimple, applyagg and applycomparison functions. Metric with case statement using an attribute microstrategy. In general, a user specifies a list of conditions and corresponding return values. Assuming that cash is a metric and we have a prompt giving us the country name, the applysimple syntax for oracle can be. Applyolap is the microstrategy apply function tool used for olap functionality when you wish to use the native capabilities of your rdbms. You can use the applysimple function in a metric definition to round off the resulting values to a certain number of decimal places.