Is there any way to get a dimension (that you just selected) name in the query panel?
I have three measures (A, B and C) and two dimensions (W and Y). If I choose dimension W, I want in my query the measure B. If I choose dimension Y, I want in my query the measure A. If I get both, I want in my query the measure A, otherwise measure C.
I want to create an object in the universe to get the name of the dimension selected and choose the measure. It was my idea.
Actualy, I want to get the dimension name to do a conditional in the universe. If I can get the name of the dimension that I selected, I can create an object (in the universe) that get this name (in WebI) and decide which measure to use.
So I have two situations:
1- Create an objects to get the name of dimension used in the query panel;
2- Use it in the query panel to decide witch measure must be used.
I don´t know if it is the right way to do it, so if you have another idea, please tell me.
I have tryed to do it and have tryed to select a measure inside the objects properties. But it didn´t work very well (I knew it).
I can´t restrict the measure or dimension to each other, because I can choose, for example, others dimensions without the restricted one.
I will try to create a derived table and add it in the context… I think that it is the way. I will keep trying and let you know if I reach my goal.
Thank you and if you have another suggestion, please tell me.
See you.
My solution was something like this: DeskI only:
a)
– First of all, You need to drag all the dimensions and measures in the query panel.
– Create one block Table1 with Dimension W and measure B.
– Create another block Table2 with Dimension Y and measure A.
– Next create another block Table3 with Dimension W and Y with A or C.
– Place the blocks on top of each other.
b) You would create a @prompt something like @Prompt{‘Select option:’,‘A’,{‘Dim W’,‘Dim Y’,‘Both’},mono,constrained)
c) Based the on the user input, Let’s assume user has selected ‘Dim W’, then you will display Table1 and HIDE Table2 and Table3 in your report. Similarly you have to do for other selections.