Forum Discussion

Keyser_Soze's avatar
Keyser_Soze
Contributor
10 months ago

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...
Data Management
  • JackLacava's avatar
    JackLacava
    10 months ago

    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's avatar
JackLacava
Honored Contributor

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.

Keyser_Soze's avatar
Keyser_Soze
Contributor
10 months ago

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)

  • Steven's avatar
    Steven
    Contributor II
    10 months ago

    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's avatar
    JackLacava
    Honored Contributor
    10 months ago

    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).