OneStream Community

jrk · 04-20-2023

Is there a way to report first Value for Each Time Period similar to TB First setting in Essbase? M1 .. M12 M1 Value to be shown for FY

jrk · 07-11-2022

We have an issue where in an excel template when opened by few users the formulae doesn't work as expected They get _xlfn ._xlws prefix before the functions which is because workbook contains a function that is not supported in the version of Excel t...

Mass Delete Members below Orphan · 06-07-2022

I'm looking for an option to mass delete members marked as ORPHANS in a dimension, I tried few options but if there is any data in the application for any of these ORPHAN members the delete fails Wanted to know if there is a work around or another wa...

jrk · 04-24-2024

@Mer - Were you able to resolve this? Even with Can Load Unrelated Entities set to False and Entity Assigned to parent WF, this setting only works for Import type. I hope OS enables, Can Load Unrelated Entities even for Input Form like adjustment typ...

jrk · 05-11-2023

Our CV has other account types, we used the row override function along with the variableRow Range -> Row1 (This is where the Beg Balance account is in the CV)Member Filter -> T#WFFirstInYear

Re: Unable to delete Entity member · 05-11-2023

That's the feature in OS, Metadata cannot be deleted without clearing the data for that member

jrk · 04-28-2023

Are you using the metadata templates to generate the XML? And changes you referred as done in the template?April 1st : Adding Member AApril 2nd: Deleting Member AApril 3rd : Adding Member AIn this case instead of adding an entry again on April 3rd.. ...

Re: Mass Delete Members below Orphan · 06-09-2022

Cleared the data now to delete these membersWas trying to get the parent member ID for one of the orphan members ID and then wanted to delete all the members below that parent member ID. But somehow the below output returns blank, looks like ORPHAN m...

OneStream Community

User Statistics

User Activity

Reporting the First Value for Each Time Period

Issue with Excel template

Mass Delete Members below Orphan

Re: Import form cells using excel template - Validations help request

Re: Reporting the First Value for Each Time Period

Re: Unable to delete Entity member

Re: Metadata XML Extraction Issue when multiple add/delete for the same member

Re: Mass Delete Members below Orphan