The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Using Assembly's XFBRs
Hi all, I'm in trouble in using an XFBR from an Assembly, inside a Data Adapter. I've just discovered that it's possible to use the XFBR function as part of a SQL Command, like this: SELECT * FROM...
Do you get a more interesting error in the error log?
You can also try putting your XFBR in a parameter and using that in your data adapter. I think i've always done that.
You can also move your SQL/data source to a data adapter rule in your service factory.
Thanks DanielWillis for your answer,
made some more test on my Data Adapter, executing it through the "Test Data Adapter" button. I changed the query, just to see how translation behaves:
AND a.Cube LIKE 'XFBR(WS, All2Like, Param=TEST)'
AND a.Cube LIKE 'XFBR(Workspace.MyActualWorkspaceName.MyActualAssemblyName, All2Like, Param=TEST)'
AND a.Cube LIKE 'XFBR(Workspace.Current.MyActualAssemblyName, All2Like, Param=TEST)'
AND a.Cube LIKE 'XFBR(XFBR_GetParamValue, ParamValue, Param=TEST)' => This is the "old style" Business Rule
Once translated it's like this:
AND a.Cube LIKE 'TEST'
AND a.Cube LIKE '#ERROR: XFBR[Workspace.MyActualWorkspaceName.MyActualAssemblyName, All2Like, Param=TEST]'
AND a.Cube LIKE '#ERROR: XFBR[Workspace.Current.MyActualAssemblyName, All2Like, Param=TEST]'
AND a.Cube LIKE 'TEST'
I'm currently on 8.4.0, I'll manage to repeat those tests on 8.5
Best Regards
FabioG
Do you get a more interesting error in the error log?
You can also try putting your XFBR in a parameter and using that in your data adapter. I think i've always done that.
You can also move your SQL/data source to a data adapter rule in your service factory.