Board 12.6.0.1 : The JOIN function is not supported anymore

Julien CARDON · 2023-08-14T20:59:21+00:00

There was an error rendering this rich post.

Hello,

In Patch 12.6.0.1, as per the release notes :

Dataflow : The JOIN function is not supported anymore and should not be used in the Dataflow configurations

⇒ Could you please explain if there is a change in the code related to JOIN() function : All dataflow with join() will now fail ? or it is for information purposes only ?

I'm in v12.6, and I would like to know if my dataflow using JOIN() will work as expected in v12.6.0.1

regards,

julien

Find more posts tagged with

Accepted answers

All comments

Krisztina Zappert

I have a follow-up question - I only know of a JOIN funciton in the data readers, where can I find this JOIN in dataflows?

Julien CARDON

yes, it's not documented but known by board consultants when using Board 10.

I think a lot of DEVs are still using this function

My question now how to check quickly on each DB + Capsule which procedure has JOIN() dataflow

Samson Sunny

Hi Julien & Krisztina,

Yes the JOIN syntax has been used since B10 but has been deprecated since the adoption of Board 12. They most likely won't work from the new 12.6 patch. Use the normal multiplication with the extend calculation as they offer better performance.

Thanks,

Samson.

Andrea C.

Hi Julien & Krisztina,

Thanks for your feedback.

In 12.6 main release it was indeed found as an issue causing dataflows containing JOIN syntax to fail. This issue has been fixed in the 12.6.0.1 patch release.

As my colleague Samson mentioned the usage of JOIN syntax is not required anymore since the adoption of Board 12. From B12 we do not require customers and consultants to know these complex syntaxes and setups , it is instead Board itself to choose the most appropriate dataflow algorithm based on cubes dimensions/dataflow configuration.

This means that, if the conditions for a JOIN algorithm are in place, Board will automatically run the dataflow in JOIN without the need for you to specify the syntax. On the contrary , if there is a better algorithm to execute that dataflow Board will choose that one.

Up until 12.6 the JOIN syntax was anyway still forcing the dataflow in JOIN mode, even if this was not the most efficient algorithm to use.

With this patch release , if present in the dataflow formula, the JOIN syntax will be ignored and Board will run the dataflow with the most appropriate algorithm. So no need for adjusting all the dataflows in your application if you upgrade to this patch.

Following your comments we will change the release notes to make this more explicit.

Andrea

Federico Cazzalini

https://community.board.com/discussion/comment/15239#Comment_15239

Thanks @Andrea C.

it is absolutely important to keep in mind - as you said - that from B12 we do not require customers and consultants to know these complex syntaxes and setups , it is instead Board itself to choose the most appropriate dataflow algorithm based on cubes dimensions/dataflow configuration.

but I would like to highlight this important part:
In 12.6.0.0.85662 main release it was indeed found as an issue causing dataflows containing JOIN syntax (explicit formula JOIN() written in the dataflow) to fail.

This issue has been fixed in the 12.6.0.1.87034 patch release.

ciao!
federico