I am currently working on a Dynamic Cube with Data Binding Type (Share Data using Workspace Assembly). I was able to load Local currency data from BiBlend table and verify data using Cube View. Does Dynamic cube support Translation & Consolidation? I was unable to view translated data.
Hi, with the setting you used, you can "share" data dynamically. So you could pull the translated data from the BIBlend table and display it on the parent currency member in the consolidation dimension. Consolidated data could be displayed using dynamic aggregations in your workspace assembly code. But that dynamically aggregated data would not (automatically) take into account the consolidation rules applied in your cube solution.
Take a look at the different data binding types here:
Dynamic Cube Data Binding Types
I think what you need is to use "Copy Input Data From Workspace Assembly". So you copy the data from BIBlend to C#Local and then consolidate the dynamic cube.
Please note that this is just how I understand it at the moment. I did not test what you want to do here yet, but I am interested in your experience, so please share if you get it to work like this.
I believe they can also use the "with Calculations" option.
Thank you for the responses, I will share an update once I get it working as expected.
