Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that when you select first column the 3rd column changes dimension.
If you select 3rd column (without back button) you can't unselect that column because affects distinct tables.
Example 01254:
Whitout selecting anything
selecting first column
When you select first column, then the 3rd column brakes down with pack info.
And if i select anything from 3rd column then without back action you can unselect that column by many clicks that you make in the cell.
Is there any way i can make that user won't be able to click in 3rd column, or i have to leave this 'bug' in user hands?
This on same column
Dimension:
=if(isnull(KIT_NombreHijo),Cod_NombreProducto,KIT_NombreHijo)
Condition:
GetSelectedCount(Pe_NumPedido)=0 and ((GetSelectedCount(Cod_NombreProducto)>0 or GetSelectedCount(Cod_CodigoArticulo)>0) and GetPossibleCount(KIT_NombreHijo)>1)
Dimension:
Cod_NombreProducto
Condition:
GetSelectedCount(Pe_NumPedido)=0 and ((GetSelectedCount(Cod_NombreProducto)=0 or GetSelectedCount(Cod_CodigoArticulo)=0) And (GetPossibleCount(KIT_NombreHijo)=0 or GetPossibleCount(Cod_CodigoArticulo)>1))
The first and second column are:
First Cod_CodigoArticulo (numeric code, same for 2 dimensions)
Second Year (same 2 dimensions)
Try to use the 3rd Dimension in expression instead of Dimension
I thought it would work but it wont, as it was a calculated dimension with condition, when i copy paste dimension and condition the break down won't occurs because is the dimension that makes the breake down as the other dimensions are same
Can you post what is the condition are you using?
Question updated
If anyone is still looking for an option to make dimension unselectable (for example in the table):
1. Create an alternate state in master items: i.e. NewState1
2. Edit the table that you want to have dimensions unselectable and go to alternate states --> change to your NewState1
3. Use set analysis in the measures in this table to ensure these are referring to the default state, not NewState1 by adding {$} to the expression like that: Sum({$}Measure).
As a result it is still technically possible to click and select the dimensions in this table, but it won't have any effect as no other objects are using this alternate state, and measures in this object are referring to default state {$}.
If you want to just make one of the columns/dimensions unselectable that solution won't work.