Variable names when filtering

[danielrogra]

Hello All

First of all, thank you for your time

I was wondering if there is a way to avoid this "issue" I have when filtering. Imagine I have a table like this

cm_a     name     cf_name

a               x               b

So I create a variable called Real name = cf_name. Then I create a dimension Real Name as following: $(Real name)

After all, when I filter using the dimension Real Name I can see the variable cf_name on the filter bar. Is there a way to see Real name instead of cf_name in the filter bar?

Thank you for your time

Daniel

[OmarBenSalem]

Why do you need to create the Real Name as a variable?

Create it as a master dimension instead and then u can see its new name in the filter pane

[danielrogra]

Hello Omar. Thank you for your quick reply.

I also did that but I see the same...I see the field name instead of the variable name...

[arvind1494]

dont use as a variable make it as a master itm

or while loading rename cf_name as a real_name

[agigliotti]

could you please explain better what are you trying to achieve ?

[danielrogra]

Thank you arvind.

When I make a master item it works in the same way, I see the name field instead of the master item...

[OmarBenSalem]

It's really a stupid thing to do (but it will work )

when u create uur master dimension, create it as follow:

if(cf_name=cf_name,cf_name)

name it Real name and it will appear as follow in the filter pane;

if u create it as cf_name, it will appear as cf_name..

example:

[danielrogra]

Hello Andrea

I mean something like this:

I want to see 'Name' instead of Cam_NM.....

Thank you!

[danielrogra]

Thank you Omar!! It's a bit tricky but it seems that it works...Is that the only way?

Thank you very much indeed.

[OmarBenSalem]

I think so yes; well if that did the trick; please close the thread by makring the correct answer as correct and the one that've helped u as helpful; so that other community members would know this case is closed and have their answer if they do face such a situation !

Thanks