OneStream Community

CarlosAlvear

Hi all, In a case we'd like to have a CV with 3 columns using different intercompany groups (group 1, group 2, group 3), for a particular account (1 row). Do you know how this can be done? I could do a member list but this would show the detail of ev...

Unable to delete Entity member v2 · 03-27-2024

Hi all, Short question. I have a message similar to this: "Unable to delete member 'XXXX'. Error removing member. Member 'XXXX' has data. Same as in post Unable to delete Entity member - OneStream Community (onestreamsoftware.com) With the exception ...

Delete user groups using a XML file · 02-21-2024

Hi all, Does anyone know what's the command line to delete a security group using an XML file? equivalent to the action="delete" for metadata for instance. Thank you Regards p.s.: there's this way using an extender rule: Bulk delete security group

CarlosAlvear · 02-02-2024

Hi all, Is there a way to export (for instance to text or CSV file) the error message from a set of confirmation rules applied in a workflow? For now I see it's possible to export one at the time (meaning the error message from one rule) using right ...

CarlosAlvear · 01-17-2024

Dear all, I'd like to know whether you've been faced to this issue. When defining the CV there are several nested dimensions in the row definition and I'd like to show it so that the header is repeated to avoid empty headers on the rows (see image be...

CarlosAlvear

Hi Krishna, Sure, let's say that base entities are 1000 in total and they are split in 3 groups using some text parameter to identify the group; 400 for group A, 300 for group B and 300 for group C. Adding all groups would make all entities and the i...

Re: Unable to delete Entity member v2

Hi Jack, That wasn't the answer because the cube was already empty (no data cells). At the end there were some data on journals that needed to be cleared before deleting the member. Thank you

CarlosAlvear · 03-16-2024

Hi Scott, I haven't tried this but I think it should work. First, maybe you can set up a workflow so that you have one input per year so you can import all the data per month at once. Then I think in the data source, you'd have to add 12 amount sourc...

CarlosAlvear · 03-03-2024

Hi there, You can also export the file, in app/load-export file. Select transformation rules, and then the rules you want to download. You'll get an XML file that you can read and update if necessary. Regards, Carlos

CarlosAlvear · 02-19-2024

Hi Jen, Maybe a dynamic calc member that recovers that information can do the work. Regards

OneStream Community

User Statistics

User Activity

create an intercompany subtotal in a CV

Unable to delete Entity member v2

Delete user groups using a XML file

Confirmation rules - Export of error messages

repeat row headers in a CV using Data Explorer

Re: create an intercompany subtotal in a CV

Re: Unable to delete Entity member v2

Re: Importing XFD multiple amount columns

Re: Transformation Rules (trx) Export Multiple files

Re: Percent Consolidation