Recent Discussions
Workspace Assemblies Extensibility Rule
Has anyone been able to get an extensibility rule to work in the workspace assemblies? I've looked and I haven't seen much of any documentation on this. I'm working in 8.4 and have the rule working when I have it using the regular extensibility business rule which is attached to a DM job to run. When I try to move it to a workspace assembly and put it on a DM job it doesn't work. I've created a new file as the Extensibility Business rule source code and have the same code with no errors. I don't see an option in the Ws Assembly Factory to specifically call out extensibility rules either. So far I've been successful with getting an XFBR, Extender Rule and Custom calculate rule to work in assemblies but extensibility doesn't seem to work. Below is the error I am getting.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 You
Metadata UD3 dimension update
I need to make some changes to the UD3 dimension hierarchy member names and was wondering if there is a way I can do a mass update. For example, the coding used for UD3 name OLD_XXX will need to change to NEW_XXX. There’s ~266 members I need to update and many more to come. Can you please advise if there is an easy way to make this change? Thanks!Application 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 appreciatedEliminations between Balance & P&L accounts
Hi everyone; we have an application using standard elimination, we have been used eliminations between balance account and P&L accounts, I created a new account in Balance sheet accounts with plug account as Assets, create another P&L account (Revenue) using the same plug Asset account; now when runs the consolidation & Eliminations, there is a difference with balance, is unbalancing. Is there an specific configuration that I need to setup into the accounts? Thanks in advance and best Regards. Mario GVHo 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.
