Hi,
can I create a Variable like a Hierarchy?
the problem I'm having is like
1. I have a custom Input control: Select by "Product" or by "Customer"
The Product is Hierarchy Dimension and Customer is Regular one
I have in my table Dimension a condition:
if selection = "Customer"
then [Customer]
else
[Product]
The problem is, in the table the Product is coming as flat and not as Hierarchy when I'm using the Variable.
If I put normally Product, the hierarchy works perfectly.
Any tricks?
Thans.
Regards.