HIDE

The HIDE command hides the text of a program, so that you cannot display it using the DESCRIBE command, the EDIT command, or the OBJ function. You can perform all other actions on the program, including executing, compiling, renaming, or exporting.

When you hide a program, you supply a seed expression, which Oracle OLAP uses to encrypt the program text. You can use this seed expression later with the UNHIDE command to make the text visible.

Syntax

HIDE prog-name seed-exp

Arguments

prog-name

The name of the program whose text you want to hide. Do not enclose the program name in quotes.

seed-exp

A single-line text expression to be used as a seed value in the encryption of the program text. Do not specify NA for this value.

Keep a record of this seed expression, so that you can use it later with the UNHIDE command. The seed expression you specify in the UNHIDE command must be byte-for-byte the same value as you used in this command. Also, the seed expression is case-sensitive, so record uppercase and lowercase characters carefully.

Notes

When you export and import a hidden program, the text remains hidden in the analytic workspace in which it is imported. It retains the same seed expression for use with the UNHIDE command.

When you want to use the UNHIDE command on a program but you have forgotten the seed expression, you can call Oracle OLAP Products Technical Support for help in solving your problem. Before calling, make a connection to Oracle OLAP from OLAP Worksheet and attach the analytic workspace that contains the hidden program.

Examples

HIDE sales_rpt 'Crystal'