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 and sameburn for your answers,
Unfortunately, no luck yet.
I made one more test, setting the factory at the MU level, changing the query as:
SELECT * FROM MyTable WHERE MyField = 'XFBR(WSMU, MyFunction, Param1=XYZ)'
I removed the OS Param, so I removed a doubt about it.
If I "Test" the Data Adapter, it works fine.
If I run the Report from Report Designer it works fine.
If I run the report from my dashboard, I get the following error:
Error processing XFBR String 'MyFunction'. Unable to find the Workspace Assembly Service Factory class for name 'WSMU' in Workspace 'Default' and Maintenance Unit ''
No problems at all if I call a "traditional" XBFR (outside from the Workspace)
Thanks for your effort
FabioG
Just tried to remember what our issue was. Someone was having trouble with a parameter that I'm sure was working previously now complaining about the same thing as yours. The parameter referenced an XFBR in a workspace service factory. Had to change to directly reference rather than use WS/WSMU. They were in the middle of UAT and didn't have time to look into it a great deal. Not sure if they ended up figuring out why the original issue occurred.
Changed to: XFBR(Workspace.WorkspaceNameHere.AssemblyNameHere,XFBRNameHere)
XFBRNameHere being what lands in args.FunctionName