06-25-2024 04:22 AM
Hi,
I'm trying to copy consolidated data from one Cube to another one. All the process works perfectly except for the consolidated data. C#Elimination is not being imported.
The part of the connector rule where I think there is a problem is here, but I don't know how to solve it:
Dim dtDataRecord As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si, myCube, "E#E004",
"C#Local:P#PL00", ScenarioTypeId.Actual, "S#ACT", "T#"& wfTime, "YTD", True, filterF, _
4, False)
Thanks,
06-25-2024 04:26 AM
Hi @daniel,
I don't think you can export data with an FDX query from the Elimination level. It would only export C#Local as you have specified in the query.
To export Elim data you'd need to find another approach.
06-25-2024 04:29 AM - edited 06-25-2024 04:32 AM
As far as I can think, you can:
There are other options if these does not work for your use case. Happy to give you more details if needed.
06-25-2024 04:27 AM
Hi @daniel . The FDX Data Unit BRApi does not extract Relationship data. You could try the FDX CubeView BRApi built off of a Cube View... or a Data Management Export Data step
06-25-2024 09:11 AM
Keep in mind that if you are able to copy the C#Elimination:O#Elimination data as noted by others in this thread, if you consolidate that data in the target cube, the eliminations will get re-written in the target cube based on the relationships and data in the target cube. That is unless you have turned off elimination logic in the target cube or do not plan on consolidating data in that cube.