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.

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

Hi FabioG ,

For these errors:
AND a.Cube LIKE 'XFBR(Workspace.MyActualWorkspaceName.MyActualAssemblyName, All2Like, Param=TEST)'
AND a.Cube LIKE 'XFBR(Workspace.Current.MyActualAssemblyName, All2Like, Param=TEST)'

I believe the syntax should be this for the XFBR service:
XFBR(Workspace.workspaceName.WS,MyStringFunction) 
XFBR(Workspace.Current.WS,MyStringFunction)

If you are using the maintenance unit service factory, here is the syntax:
XFBR(Workspace.workspaceName.maintenanceUnitName.WSMU,MyStringFunction)
XFBR(Workspace.Current.Current.WSMU,MyStringFunction)

Hope this helps.
-Eric

FabioG's avatar
FabioG
Contributor II
1 year ago

Hi EricTelhiard 

Thanks for Your kind answer

AFAIK the placeholders WS and WSMU represent the factory to use, and they're not supposed to be used at the end of the string Workspace.Current.....

Using WS or WSMU you're referencing the factory specified at WorkSpace or Maintenance Unit level

Regards

FabioG