Forum Discussion

srisarsani's avatar
srisarsani
New Contributor II
26 days ago
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 View. Does Dynamic cube support Translation & Consolidation? I was unable to view translated data.

 

Cubes
Methodology
  • JackLacava's avatar
    JackLacava
    9 days ago

    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.

8 Replies

  • srisarsani's avatar
    srisarsani
    New Contributor II
    24 days ago

    Thank you for the responses, I will share an update once I get it working as expected.

  • Henning's avatar
    Henning
    Valued Contributor II
    26 days ago

    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.

    • JackLacava's avatar
      JackLacava
      Community Manager
      24 days ago

      I believe they can also use the "with Calculations" option.

      • srisarsani's avatar
        srisarsani
        New Contributor II
        10 days ago

        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?

  • srisarsani's avatar
    srisarsani
    New Contributor II
    8 days ago

    Thank you for your suggestions. I was able to read data from BiBlend table to C#Local, Translate and run Consolidation.

    Few things that I have noticed, translation does not work if we use a Dynamic dimension member. Currency name is displaying as USD in C#Local, even though Entity currency is something else like CAD, MXN.

    • JackLacava's avatar
      JackLacava
      Community Manager
      8 days ago

      That's probably a bug in your code, sorry 😊