Dynamic Cube Data Load from BiBlend Table

Question

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.

JackLacava · Accepted Answer

I was not able to translate data in Dynamic Cube using Data Binding Type - Share & Edit Data Using Workspace Assembly with Calculations. I have tried Translation Algorithm options - Standard using business rules for FX, Custom. Cube View shows same data values in all Currencies (Local, Translated, Elimination, USD and other Consolidation members). Can you provide some insight if translation is possible in Dynamic 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.

Henning · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded