Can we create a Variable to use as input Parameter in SAC with import connection.
Here, i need to create a variable "Metric" with 2 values like Grp1 and Grp2. and map certain measure to each group.
In story, need to use newly created Variable as Page filter where when we select a group then corresponding data should be visible and vice versa.
Page filter would be like
Measure will be defined in following manner:
IF(Metric = 'Grp1', Measure1)
IF(Metric ='Grp2', Measure2)