hide key columns of dimension table

[#1]

hello everybody,

i have two tables which are connected via the id column.

when setting up the application i have both "id" fields in the frontend available,

which may confuse a user.

is there any chance to hide the id from table A.

When commenting out the connection

between the tables is lost, which is logical.

in the end i just want the two tables connected (via id ) and

use the "description"-field of table B.

LOAD id, a_column

[table A]:...

LOAD id,description

[table B]:....

any suggestions ?

[marcus_sommer]

You could use HidePrefix to make this field treated like a system-field with something like this:

set HidePrefix='%';

and then renaming your id to %id.

- Marcus