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.

FabioG's avatar
FabioG
Contributor II
1 year ago

S0N1C43V3RThanks for your answer, I guess it works if you define an XFBR in the assembly without leveraging on the Service Factory (that's what I'm doing).

DanielWillisThanks for the hint, it worked... BTW, I don't like it so much, looks like we're adding a lot of overhead to accomplish something simple. I mean, we're adding a new Literal parameter (to execute an XFBR call) that is inserted into a SQL command, just because the Report component (this is my idea) is not addressing correctly the WS/WSMU shortcuts. 

Don't know what You think, but IMHO this should be considered as a bug (?)

Thanks a lot for Your precious help

FabioG