Can we change data through dataflow using RDB cubes?

TelDant

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.

Samson Sunny

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

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

Hi @Gerald Gendreau ,

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

Best,
Helmut

Gerald Gendreau

Hi @Helmut Heimann

Thank you for replying to me :)

Here is the calculation I tried to perform :

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

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

Best,

Gérald

Helmut Heimann

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

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 :

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

Hi @Gerald Gendreau ,

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

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

This is something that most relational databases handle differently…

Best,
Helmut

Andrea Duò

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

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

Thanks for letting us know, @Gerald Gendreau .

Fethi ZERARA

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

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.