Workflow Profile Active Property

Gidon_Albert In your case above, if the scenario is not in the list then it is disabled. It will leave this table.

Take the code below and paste it into your data adaptor.
Test like this : 9 is a Variance scenario. Try there to disable and enable. You will see the result of the query. It will disapear.
Obgiously also chagne the name of the ProfileName. 

SELECT
  WorkflowProfileHierarchy.ProfileKey
 ,WorkflowProfileAttributes.ProfileKey
 ,WorkflowProfileHierarchy.ProfileName
 ,WorkflowProfileHierarchy.CubeName
 ,WorkflowProfileHierarchy.ProfileType
 ,WorkflowProfileAttributes.ScenarioTypeID
 ,WorkflowProfileAttributes.AttributeIndex
 ,WorkflowProfileAttributes.ProfileAttributeValue
FROM dbo.WorkflowProfileHierarchy
INNER JOIN dbo.WorkflowProfileAttributes
  ON WorkflowProfileHierarchy.ProfileKey = WorkflowProfileAttributes.ProfileKey
WHERE WorkflowProfileHierarchy.ProfileName LIKE '%Task_A1%'
AND WorkflowProfileAttributes.ScenarioTypeID = 9

 Later you can simplify this query to only get the profile names...

-5, "All"
-1, "Unknown"
0, "Actual"
1, "Budget"
2, "Flash"
3, "Forecast"
4, "FXModel"
5, "History"
6, "Model"
7, "Plan"
8, "Tax"
9, "Variance"
10, "Administration"
11, "Control"
12, "LongTerm"
13, "Operational"
14, "Sustainability"
15, "Target"
101, "ScenarioType1"
102, "ScenarioType2"
103, "ScenarioType3"
104, "ScenarioType4"
105, "ScenarioType5"
106, "ScenarioType6"
107, "ScenarioType7"
108, "ScenarioType8"

Please give some kudos if it helps. 🙂