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 MyTable WHERE MyField = 'XFBR(MyBR, MyFunction, Param1=|!prm_Whatever!|)' I was surprised to see it working, but this is not the point. When MyBR is defined as a Business Rule, everything isworking fine. Then I moved the Business Rule into a Service XFBR. Since the Factory is defined at Workspace level, I converted the query as: SELECT * FROM MyTable WHERE MyField = 'XFBR(WS, MyFunction, Param1=|!prm_Whatever!|)' Directly testing the Data Adapter everything works fine, I can see the converted query and also the results. Now, the problems: The above mentioned Data Adapter is used by a Report. When the XFBR is defined under the Business Rules area, everything is ok. When I launch the report (from a Dashboard), i get the following error: Error processing XFBR String 'MyFunction'. Unable to find the Workspace Assembly Service Factory class for name 'WS' in Workspace 'Default' Not clear what I'm missing. Can someone point me in the right direction, please ? As an additional info, let me say that the DataSet/DashBoard/etc were moved from the Default WorkSpace into a brand new WorkSpace (but I cannot see any reference to the Default WorkSpace in Data Adapter or Report) Thanks a lot FabioGReport Scripts
Hi all, I'm trying to figure out how to leverage on Report Scripts using OneStream objects. Is it possible to leverage on BRApi inside scripts events ? A direct call to BRApi class results in an error, I'm wondering if there's some workaround or trick to reach the object. Best Regards FabioG
Data Audit Dashboard
Hi All, I am trying to create a dashboard to extract the data for the given point of intersection basically I have given all the dimension parameter for the user to select and click on the button download that runs the DataManagement job and will extract the data for the selected POV . I am able to achieve the above requirement just like an enhancement I want to also get the data of the user details who has loaded data into those point of intersection. Can some one help me with the lead how can I achieve the above user details that would be really great. Thank YouApplication Logo in Report (and Scripts)
Hi all, I'm building a Report Component from scratch, but I'm not able to put the Application's Logo (defined in Application Properties / Logo File) in its header. I can add an Image control, but I must fill it with a file (or URL), looks like I cannot bind the control to the Application's logo (and IMHO this would be really helpful) I also tried to look at Report's Scripts, I see a lot of events, but I cannot find documentation to use them (maybe there's something I can do through them, to grab image from Application Properties, injecting it into the component) Just wondering if there's something I could do... Any help would be really appreciatedHo to extract a hierarchy for any dimension in Level format in OneStream?
Originally posted by Vignesh Mohan Hi, How can we extract the hierarchy of any dimension in an excel in a Level based format starting from top most level to the bottom most level for every base member ? Basically I do not want a Parent-Child format extract. Please find the attachments for the sample screen shot.Export Data of Selected Parameter
Hi All, I am trying to create the dashboard where I pass all dimension from combo box to button taht triggers the DM sequence that has the Export Data step. I get the following error mentioned below. FYI please see the screenshot of the export data step mentioned below. Can someone please help where I am going wrong please help me with the approach. Thank youManaging Application Secrets
Hi all, While getting into OS, I'm trying to figure out how to leverage on its framework... And I have a question related to secrets management. Let's say that - at application (workspace?) level - I need to access to a remote service that requires an OAuth token (or user/pass tuple, or whatever I need to keep away from user's eyes - and fingers). The above mentioned secrets should be (visually?) managed by an administrator. Does OS offer something out-of-the-box to accomplish this task ? And, in case, can we leverage on some API to retrieve secret data ? Thanks for Your answers. FabioGIntellisense on Custom Code
Hi all, I'm quite new in OS and, as a Dev, I'm writing some code in Assemblies/Business Rules. I'm experiencing an issue with Intellisense. While I'm working from inside a class, I can see all the hints supplied by intellisense for all the Standard/OS Classes/Methods and for the Methods inside my current class. Unfortunately I cannot see hints for my other custom classes/methods that I wrote under the same assembly/namespace (they are correctly referenced, the assembly is compiled) I tried adding triple-slash comments, but - again - no luck. Just wondering if there's something I should do to make intellisense works or if I stumbled in a platform's limit. Thanks in Advance for Your precious help FabioG
