Strategy supports SAP HANA calculation views (CV) with input parameters created in HANA Studio (XSC) via prompt objects, which generate a popup for providing answers to the IP. Hence, prompt behavior and capabilities constitute a basis of Strategy capabilities for supporting IPs. Strategy does not support input parameters in XSA to XSC deployed calculation views. Such CV is seen by MicroStartegy as a regular table in the Warehouse Catalog. The two types of prompts that are most often used are the value prompt, which is the default, and attribute element list type, which can be used as a replacement to the default prompt in a setup where CV is added to the Warehouse Catalog in Developer - a logical table object workflow. If a Strategy user uses CV by creating a cube, they are limited to the capabilities of the default value prompt – this is referred to as cube workflow. OLAP cubes (cubes created in Strategy Developer) do not support prompted objects at all.
Strategy supports input parameters via prompt objects. When a calculation view is added to the Warehouse Catalog, Strategy automatically creates and assigns it to a value prompt. A value prompt allows the user to type in a value which later ends up in PLACEHOLDER SQL syntax. Value prompts allow you to pass multiple answers to input parameters when the value prompt type is set to Text. By default, the type of value prompt corresponds to the IP’s data type. Therefore, one needs to replace the prompt in case of an incorrect data type. Value prompt (text datatype) user interface:
The prompt answer is passed to the PLACEHOLDER clause in SQL:
Attribute element list interface:
Notice that the syntax used by Strategy puts each answer in two single quotes.
