Forum Discussion

Gidon_Albert's avatar
Gidon_Albert
Contributor II
2 years ago

Workflow Profile Active Property

I have a data adapter with a query that lists all workflow profiles in the application. I need to exclude from that list all the inactive profiles (Profile Active=False) Where is this property in th...
Workflow
  • NicolasArgente's avatar
    NicolasArgente
    2 years ago

    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...

  • NicolasArgente's avatar
    NicolasArgente
    2 years ago

    -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. 🙂

Gidon_Albert's avatar
Gidon_Albert
Contributor II
2 years ago

Got it.

So if ProfileAttributeValue for AttributeIndex 1300 is 1, the profile is active for the respective ScenarioTypeID.

It looks like:

  • ScenarioTypeID 0 = Actual
  • SceanrioTypeID 1 = Budget
  • ScenarioTypeID 9 = Variance

Not sure about all the other types.

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

    -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. 🙂