The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Export Data (Including Dynamic Calcs) using a DataBuffer
I am trying to export Data including dynamically calculated accounts using a DataBuffer (Not just base members but all intermediate levels). I can do this by looping over Accounts+U1+U2 combined wit...
There is no need for parentheses inside FilterMembers, just list all the filters you want to apply. I may be wrong, but I think you should be able to have multiple filters for the same dimension and they will act as OR, in the same way as in Calculate filters.
As for exporting dynamic data, I would recommed using FdxExecuteCubeView instead.
JackLacava
OneStream Employee
OneStream EmployeeThere is no need for parentheses inside FilterMembers, just list all the filters you want to apply. I may be wrong, but I think you should be able to have multiple filters for the same dimension and they will act as OR, in the same way as in Calculate filters.
As for exporting dynamic data, I would recommed using FdxExecuteCubeView instead.
The CubeView method is awesome, thanks a bunch !
Would you recommend separating data (Non dynamic/Dynamic) using FdxDataUnit & FdxCubeView then joining tables later on ? or we can insert everything in the CView ? (time-wise)
The cube view will pull your ALL your data.
Why do you want to split it out and then try to merge it back together? That seems like you would create more potential for data issues/risk.
- JackLacava
Fdx calls are already heavily parallelized, so you won't gain anything (from a performance perspective) from splitting them. It might make sense from an organizational/maintenance perspective, depending on your requirements (i.e. sometimes, stuffing everything in a single CV is just hard from a design perspective).
