Recent Discussions
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
Time Profile: Time dimension at week level vs at month level with weeks in UD
Hi All, I am designing a new app with huge data set at detailed level and need time at weeks level. I would like to know if going by custom profile with time dimension at weeks level would be more efficient or having time dimension at month level and using WEEKS in User defined dimension would be better in the performance. It would be great if you can share some pros and cons for both the approaches and which one would be optimistic. Thanks in advance.
Removing Period Selection When Data Value is removed from a Text property
I am attempting to update the "text" property (which varies by time) for my UD1 members using a business rule that pulls data from a custom table. The update process works as expected without any issues. However, when I remove a data value from the table, OneStream removes the value from the text property, but the corresponding period remains selected, showing blanks (see Screenshot 2). I am removing the data value using the "Else" condition as shown below (Screenshot 1). Can anyone provide insights on how to also remove the period from the selection when there is no value? TIA Screen Shot 1: Screen Shot 2:
Slice Security - Data Cell Access
Can someone please explain the difference between "Apply Access" and "Increase/Decrease Access" in Slice Security ? For Example : How it makes a difference when selecting "Apply Access - All Access" Vs "Increase Access - All Access" Also please advise any training materials for Slice Security?
Weekly time application
Dear Community, Since I can create a weekly calendar using a customized Time Dim, what is the "Fiscal Year Month Type" such as Fixed week 4-5-4, 5-4-4 in the time profile used for? If it is used for fiscal year purposes, how can I see the impact? I tried to play around time profile, and it doesn't seem to impact anything. Please provide some ideas. Thank you8.4 Dashboards for phone, tablet, web and windows App
Hi All We are using 8.4 at our new client and have been tasked with creating dashboards suitable to view on a tablet, web, windows app and phone. We have created different dashboards for each of the different devices, i.e. tablet, phone, windows app and web but have noted that for example, the phone dashboard formatting shows differently on each phone, depending on the phone screen size and it does not auto adjust to fit the screen size of every phone. Same as for tablet, web and windowsApp. Where can I get settings for auto fit on each device so that it shows uniformly on each device regardless of screen size?
