OneStream Community

Steven · 07-13-2023

I would like to create a derivative transformation rule that will add _Qty to the end of the Account and pull the ActualQuantity field from the data source as the Amount.My DataSource has a field for ActualQuantity.I have a Derivative Rule that looks...

Steven

Have you tried using the marketplace solution: "OneStream Parcel Service"? You can automate sending reports to email or file.

Steven · 06-20-2024

kmd, I am not aware of a way to do this without using a business rule/ sql code; however, have you set your "Grid Rows Per Page" in your user security to 1000? This is the max rows you will see on a grid and may decrease the number of pages you need ...

Steven · 06-13-2024

Use the Market Place Solution: Parcel Service to email the reportsCreate the reports (xfDocs)Create a Distribution Group (Group of users/emails)Create a Package (reports to send)Create a Package Group(Group of packages)Create a business rule to ship ...

Steven · 06-07-2024

OS_Love, Yes, when you "CLEAR" the workflow, it clears the data that is in the stage tables. If you want to clear the data in the cube, first clear the workflow and then click retransform, then validate and load. This will Load nothing into the cube ...

Steven · 06-04-2024

@JC_Hackkett - it sounds like you have a couple of gateways setup in SIC and you are trying to use the direct connect gateway , but you can only use the Database Gateway in your Smart Integration Function. Is this correct? What methods are you using?...

OneStream Community

User Statistics

User Activity

Derivative Transformation Rule ActualQuantity field as Amount

Re: Scheduling Security Audit Report

Re: Export ALL import stage data - is this possible?

Re: Monthly standard excel report distribution to non onestream users

Re: workflow Clear

Re: Compile SIF using Gateway Direct Connect type to connect with SAP