Can we change data through dataflow using RDB cubes?

TelDant
TelDant Customer
Name Dropper First Comment Level 200: Building A Planning Solution in Board
edited October 2023 in Platform

Hi All, Thanks for reading my message.

I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes.

However, I can make changes using a direct data entry.

Is it possible to use dataflow to delete, update or create rows into RDB cubes?

Thank you.

Tagged:

Answers

  • Samson Sunny
    Samson Sunny Employee, Community Captain
    25 Answers 100 Comments Third Anniversary 25 Likes

    Hi Telmo,

    Yes you can perform a dataflow from MDB to RDB cubes to update/insert/delete rows in the database.

    This is a known issue in previous versions of Board and has since been fixed from Board 12.6.0.1.87034.

    Thanks,
    Samson.

  • Gerald Gendreau
    Gerald Gendreau Active Partner
    Second Anniversary First Comment Name Dropper Board Developer

    Hello Samson,

    https://community.board.com/discussion/comment/15691#Comment_15691

    I have some trouble to perform update value from MDB to RDB Cube. I have the version 12.6.0.2.137981

    Both cubes are at the same granularity but the update is not perform. if the bug was fixed or my version does not contains the fix bug ?

    Thanks

    Gerald

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi @Gerald Gendreau ,

    could you please provide a screenshot of the dataflow, especially the "Extend" section?

    Best,
    Helmut

  • Gerald Gendreau
    Gerald Gendreau Active Partner
    Second Anniversary First Comment Name Dropper Board Developer
    edited January 10

    Hi @Helmut Heimann

    Thank you for replying to me :)

    Here is the calculation I tried to perform :

    image.png

    And in detailed, here is the granularity of each cube :

    image.png

    I tried both with all extended calculation check and with none. Both way result KO.

    Best,

    Gérald

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi @Gerald Gendreau ,

    thanks for the reply. You'll need to extend on all entities when flowing data into an RDB.

    I think it a bit peculiar that your RDB Cube has only 3 digits (V174). Are you working on a migrated database?

    Have you tried to input data directly into the RDB via a DataView, does that work?

    When you run the procedure in debug mode—does the TEMP Cube have the values you expect?

    Best,
    Helmut

  • Gerald Gendreau
    Gerald Gendreau Active Partner
    Second Anniversary First Comment Name Dropper Board Developer

    Thank you for responding me very fast,

    I am not working on a migrated database, cube V173 is an old cube that we keep using even after our upgrade on Board. But even if I created a new RDB Cube, it does not work like expected :

    image.png

    I double checked several times that my temp cube have data in debug mode.

    Have you tried to input data directly into the RDB via a DataView, does that work?

    Yes, datas shows correctly in BW table.

    Thank you again for the support

    Gérald

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi @Gerald Gendreau ,

    ok, can you please check the write-back options in the RDB query, that should look something like this

    image.png

    Another thing is that you might want to try different options here—regarding date format, and/or conversion

    image.png

    This is something that most relational databases handle differently…

    Best,
    Helmut

  • Andrea Duò
    Andrea Duò Employee
    Fourth Anniversary 25 Up Votes 25 Likes 10 Comments

    Hi @Gerald Gendreau,

    please let us know if any of @Helmut Heimann's suggestions help. If you are still encountering issues, I'd recommend to open a support case on support.board.com so we can take a deeper look at your case.

    Thanks!

    Andrea

  • Gerald Gendreau
    Gerald Gendreau Active Partner
    Second Anniversary First Comment Name Dropper Board Developer

    Hi Helmut and Andrea,

    Unfortunately, I was not able to perform the calculation even with Helmut's suggestion.

    I will raise a ticket to help me understand why I can't do calculation between MDB and RDB cube

    Thank you again for the time you've spent on the case.

    I will return the quick feedback here in case other user face the same issue than me

    Bests

    Gerald

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Thanks for letting us know, @Gerald Gendreau .

  • Fethi ZERARA
    Fethi ZERARA Active Partner, Community Captain
    Fourth Anniversary 100 Comments 5 Answers 25 Likes

    Gerald Gendreau,

    If this configuration isn’t working for you, you might consider using the bulk insert as a workaround.
    This approach should correctly update the RDB table.

    Best,

  • Navan Mehra
    Navan Mehra Employee
    Third Anniversary 10 Comments 5 Up Votes Level 100: Foundations of Building in Board
    edited January 18

    Hi @Gerald Gendreau @TelDant

    I have seen this happen in ver 10, so I am unsure if it is still relevant to version 12, but it is worth trying if you haven't tried it already.

    1. Delete the table in your relational database
    2. Within Board, go to cubes, then to the RDB cube. Use the option to create the target RDBMS table
    3. Use this cube linked to newly created table in your dataflow

    Try this and see if this helps.

Categories