Solved
Dynamic Cube Data Load from BiBlend Table
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 ...
Yes, it is possible with the "With Calculations" options.
Requirements to get the standard basic translation to work:
- FX rates (duh)
- In your ReadDynamicDataUnitContentTimestamp method, make sure you are NOT returning DateTime.Now - otherwise dataunits never get a chance to actually translate or consolidate
- In your ReadDynamicDataUnitData, make sure you check which Consolidation (currency) member is requested, returning only base data for local (e.g. If api.Cons.IsLocalCurrencyForEntity() And Not api.Entity.HasChildren() Then ... - same thing as in consolidation formulas).
- for all other consolidation members, return an empty dataunit (e.g. Return New DynamicDataUnitData(api, DateTime.Now, 10) )
This configuration will provide data for Local, and then you can launch a Translate in the usual way.
Otherwise, in your code you can check for the Consolidation member in api.Pov, and return translated data yourself (i.e. with custom code doing the calculation). As mentioned by rhankey​ , this allows you to provide translated data even without the "with calculations" option.
