Member PropertyID Data Dictionary
Hello OneStream Community, A few days ago a colleague of mine wanted to know the meaning of the various PropertyId constants present in one of the Application Database Audit Tables. I was unable to find any OneStream specific documentation on this PropertyId code and its meaning, so I created a business rule to complete the puzzle and get what we needed for the metadata audit at a very granular level. For any one else experiencing an issue similar like this here is a table of the Member property Id's and their meaning. Dimension | PropertyID | PropertyDescription Entity PropertyID | 100 | Currency Scenario PropertyID | 100 | ScenarioType Account PropertyID | 100 | AccountType Entity PropertyID | 150 | IsConsolidated Entity PropertyID | 200 | IsIC Scenario PropertyID | 200 | InputFrequency Account PropertyID | 200 | FormulaType Flow PropertyID | 200 | FormulaType UDx PropertyID | 200 | FormulaType Scenario PropertyID | 300 | DefaultView Account PropertyID | 300 | AllowInput Flow PropertyID | 300 | AllowInput UDx PropertyID | 300 | AllowInput Scenario PropertyID | 400 | CalculateFromGridsGroup Account PropertyID | 400 | IsConsolidated Flow PropertyID | 400 | IsConsolidated UDx PropertyID | 400 | IsConsolidated Scenario PropertyID | 500 | ManageDataGroup Account PropertyID | 500 | IsIC Flow PropertyID | 500 | SwitchSign UDx PropertyID | 500 | AlternateCurrencyForDisplay Account PropertyID | 600 | UseAltInputCurrencyInFlow Flow PropertyID | 600 | SwitchType Account PropertyID | 700 | PlugAccount UDx PropertyID | 10100 | IsAttributeMember UDx PropertyID | 10200 | AttributeMemberSourceMember UDx PropertyID | 10300 | AttributeMemberExpressionType UDx PropertyID | 10400 | AttributeMemberRelatedDimType1 UDx PropertyID | 10500 | AttributeMemberPropType1 UDx PropertyID | 10600 | AttributeMemberComparisonText1 UDx PropertyID | 10700 | AttributeMemberOperatorType1 Scenario PropertyID | 30100 | InputViewForAdj Account PropertyID | 30100 | InputViewForAdj Scenario PropertyID | 30200 | NoDataZeroViewForAdj Account PropertyID | 30200 | NoDataZeroViewForAdj Scenario PropertyID | 30300 | NoDataZeroViewForNonAdj Account PropertyID | 30300 | NoDataZeroViewForNonAdj Scenario PropertyID | 30400 | ConsolidationView Scenario PropertyID | 30500 | Formula Scenario PropertyID | 40000 | UseInWorkflow Scenario PropertyID | 40100 | WorkflowTrackingFrequency Scenario PropertyID | 40500 | WorkflowNumNoInputTimePeriods Scenario PropertyID | 50100 | UseCubeFxSettings Account PropertyID | 50100 | UsedOnEntityDim Flow PropertyID | 50100 | FlowProcessingType Scenario PropertyID | 50200 | FxRateTypeForRevenueExpense Account PropertyID | 50200 | UsedOnConsDim Flow PropertyID | 50200 | AlternateInputCurrency Entity PropertyID | 300100 | FlowConstraint Account PropertyID | 300100 | FlowConstraint Entity PropertyID | 300200 | ICConstraint Account PropertyID | 300200 | ICConstraint Entity PropertyID | 300400 | UD1Constraint Account PropertyID | 300400 | UD1Constraint Entity PropertyID | 300500 | UD2Constraint Account PropertyID | 300500 | UD2Constraint UDx PropertyID | 300500 | UD2Constraint Entity PropertyID | 300600 | UD3Constraint Account PropertyID | 300600 | UD3Constraint UDx PropertyID | 300600 | UD3Constraint Entity PropertyID | 300700 | UD4Constraint Account PropertyID | 300700 | UD4Constraint UDx PropertyID | 300700 | UD4Constraint Entity PropertyID | 300800 | UD5Constraint Account PropertyID | 300800 | UD5Constraint UDx PropertyID | 300800 | UD5Constraint Entity PropertyID | 300900 | UD6Constraint Account PropertyID | 300900 | UD6Constraint UDx PropertyID | 300900 | UD6Constraint Entity PropertyID | 301000 | UD7Constraint Account PropertyID | 301000 | UD7Constraint UDx PropertyID | 301000 | UD7Constraint Entity PropertyID | 301100 | UD8Constraint Account PropertyID | 301100 | UD8Constraint UDx PropertyID | 301100 | UD8Constraint Account PropertyID | 500100 | WorkflowChannel UDx PropertyID | 500100 | WorkflowChannel Entity PropertyID | 500300 | SiblingConsolidationPass Entity PropertyID | 500500 | AutoTranslationCurrencies Entity PropertyID | 700100 | InUse Account PropertyID | 700100 | InUse Flow PropertyID | 700100 | InUse UDx PropertyID | 700100 | InUse Entity PropertyID | 700200 | AllowAdjustments Account PropertyID | 700200 | Formula Flow PropertyID | 700200 | Formula UDx PropertyID | 700200 | Formula Account PropertyID | 700210 | FormulaForCalcDrillDown Flow PropertyID | 700210 | FormulaForCalcDrillDown UDx PropertyID | 700210 | FormulaForCalcDrillDown Entity PropertyID | 700300 | AllowAdjustmentsFromChildren Account PropertyID | 700300 | AdjustmentType Entity PropertyID | 900100 | Text1 Scenario PropertyID | 900100 | Text1 Account PropertyID | 900100 | Text1 Flow PropertyID | 900100 | Text1 UDx PropertyID | 900100 | Text1 Entity PropertyID | 900200 | Text2 Scenario PropertyID | 900200 | Text2 Account PropertyID | 900200 | Text2 Flow PropertyID | 900200 | Text2 UDx PropertyID | 900200 | Text2 Entity PropertyID | 900300 | Text3 Scenario PropertyID | 900300 | Text3 Account PropertyID | 900300 | Text3 Flow PropertyID | 900300 | Text3 UDx PropertyID | 900300 | Text3 Entity PropertyID | 900400 | Text4 Scenario PropertyID | 900400 | Text4 Account PropertyID | 900400 | Text4 Flow PropertyID | 900400 | Text4 UDx PropertyID | 900400 | Text4 Entity PropertyID | 900500 | Text5 Scenario PropertyID | 900500 | Text5 Account PropertyID | 900500 | Text5 Flow PropertyID | 900500 | Text5 UDx PropertyID | 900500 | Text5 Entity PropertyID | 900600 | Text6 Scenario PropertyID | 900600 | Text6 Account PropertyID | 900600 | Text6 Flow PropertyID | 900600 | Text6 UDx PropertyID | 900600 | Text6 Entity PropertyID | 900700 | Text7 Scenario PropertyID | 900700 | Text7 Account PropertyID | 900700 | Text7 Flow PropertyID | 900700 | Text7 UDx PropertyID | 900700 | Text7 Entity PropertyID | 900800 | Text8 Scenario PropertyID | 900800 | Text8 Account PropertyID | 900800 | Text8 Flow PropertyID | 900800 | Text8 UDx PropertyID | 900800 | Text8
Running task scheduler on a specific business day each month
Hi all, Can we schedule a task to run on a business day each month, for example, between the 1st and 7th? I know we can set it for specific days and weeks, but is there a way to make it more dynamic? Any suggestion would be appreciated. Thank you. Best, JackyXBRL Reporting
Hi! we are facing Corporate Sustainability Reporting Directive in Europe, and we need to report in XBRL format since the 1st jan 2026. we are looking for solutions on how to report in this format from Onestream. Is there some tool / connector you may know that can be applied? Do you have any recommendations on the architecture to do that? Thank you!
View OneStream licenses
Is there a way to see the current OS license that is installed? We have recently had the number of user licences increased and now want to check that this has been applied, I'd hoped this would be in an obvious place like the environment or security but can't see anything that shows the current license (just being able to see the number of enabled users that the license allows would be a good start).
Cube View DatePicker, Time Zone and Custom Calculate
We're working on a solution, where users can enter and view a date through a Cube View using the Cell Type Date. The challenge is how OneStream handles date's (datetime) with time-zones. When a date is saved to the backend, it's converted to UTC time-zone. The Date component in the Cube View is also Time-Zone aware, so that it uses the local time of the user, to convert back from the backend UTC to local-time. The challenge with this is 2 fold: 1) Assuming we would calculate a rent for a given period. The user, based in CET time-zone, enters 2022-1-15 using the Gridview. This date is converted to 2022-1-14 as UTC (2022-1-14 23:00:00). Using a Custom Calculate method to calculate the rent from start (2022-1-15), now adds one day more, as the server time is UTC. (don't mention Daylight Saving Zone) 2) If another user, based in US Central, is reviewing data in the same Grid View (and same POV), this user will see a wrong date, as the server UTC date, is converted to this user's local time Is there a way to specify in the Cube View, that when using the Date/DateTime picker, that the component should ignore time-zones? Or are there other usable solutions for this issue? Cheers
Remove Alt Hierarchy Parent-Child account without removing from the original Heirarchy
Hello, I mistakenly added a sub parent along with 3 base accounts to an alternate hierarchy. Is there any way to remove the parent child relationship in the alternate hierarchy without removing it completely from the original hierarchy?
