topic Re: How hide a dimension or measure from the edition? in App Development

How hide a dimension or measure from the edition?

Anonymous — Tue, 30 Jan 2018 09:53:43 GMT

Hi!

I would like hide the dimension or measure of the menu of a chart edition.

I want that only several columns of the tables was available to choose there.

For example, of a table I want see to choose the "name" but I don't want have the option of take "idName".

I add a image to show where I want hide the columns of the table.

In this case I want hide the colums if the ids.

Someone knows how I can do it?

Thanks and regards.

Vasiliy_Beshentsev — Wed, 31 Jan 2018 07:39:43 GMT

Hello,

the only way to hide is to comment this field(dimension) by "//" in scrypt.

Try it.

Anonymous — Wed, 31 Jan 2018 08:45:20 GMT

Hello.

If you comment the field in the script, the field will be unselected, but the relation with others tables will be broken.

So it is like field don't exist.

I want that field exist, and that have relations with others tables, but I would like hide it/them of the possibilities of choice of the charts.

Thanks by the answer.

Regards.

ehilsinger — Thu, 01 Feb 2018 18:19:07 GMT

How about using the HidePrefix? Your dimension name would have to change though.

Anonymous — Tue, 06 Feb 2018 11:15:23 GMT

Thank you so much. I tried this and work. Only I wanted ask you which way is the best.

---------------------------------------------------------------

set HidePrefix='_' ;

[TABLE]:

LOAD

[id],

[idTiempo] AS [_TABLE.idTiempo], <-- This

[idProducto],

[idConcepto],

[idUnidad] AS _[TABLE.idUnidad], <-- Or this

[valor] AS [TABLE.valor];

---------------------------------------------------------------

Thanks again.

vangurideepu — Thu, 08 Feb 2018 13:21:19 GMT

this is the better option

[idUnidad] AS _[TABLE.idUnidad], <-- Or this