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

FabioG's avatar
FabioG
Contributor II
1 year ago
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...
Extensibility
  • DanielWillis's avatar
    DanielWillis
    1 year ago

    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.

sameburn's avatar
sameburn
Icon for OneStream Employee rankOneStream Employee
1 year ago

Hi FabioG

Are you logging the result of your parameter passed into your XFBR?

Also have you tried passing in fully substantiated parameter name e.g

SELECT * FROM MyTable WHERE MyField = 'XFBR(WS, MyFunction, Param1=|!Default.prm_Whatever!|)'?

Now that you have moved from default workspace that might be the issue

Hope this helps

Sam