OneStream Platform Forums

I am receiving this error when writing a business rule, any idea on how I can remove this error? Here is the portion of the business rule where I am using 'si': Dim objXFResult As XFResult = BRApi.Finance.Data.SetDataCellsUsingUsingCsvFile(si, filePath, delimiter, originFilter, targetOriginMember, loadZeros)  

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 appreciated

I have several excel reports that use macros for sorting the data rows. The macros work when I am in excel and run after I refresh OneStream, however, when running the report in a book and generating to PDF the sorting macros are not running correctly. We have found that different preference settings within the excel add-in help with getting the macro to run in Excel, but I haven't been able to figure out why it's not working in the book. Any help or ideas appreciated!

Can I extract multiple Cube Views using parameter selection in one go using a Data Management job? 

Hello Everyone,I was wondering if anyone has experienced and resolved the issue I am finding. I am working on an excel workbook that has tabs corresponding to each workflow step consisting of various forms.  These forms have parameter requirements. The request is to have the parameter dropdowns on each excel tab. The issue I am having is some of these form tabs have the same parameters. I am met with the popup, this parameter already exists when trying to introduce it a second time on a different tab.  I know you can set one parameter to work across the entire workbook however that is not what my client wants.  The only way around this that I have found so far is to make multiple copies of parameters within the Application however I would rather not have multiple parameters that are the exact same. The other option is to have a separate excel workbook for each Workflow task.I find even setting the parameter to be used across the entire workbook to be a bit clunky.Thanks

Does anyone know how to add another row or column level dimension to an existing QuickView? The rebuild button in the Panel doesn't seem to be activating or changing anything. Can you please show me how to do it properly? Also doesn anyone recommend any beginner video tutorials, there doesn't seem to be much online.

Dear colleagues, Please advise do you have experience with automation of exchange rates calculation. We need to pick up daily rates for different currencies from different source websites, calculate monthly average rates and end of reporting period rates and upload them to the correct time period in OneStream.  Where can I find guidance to solve this task?

Hi Team, I just want to create a report, in that report user can review like (which user has certified the respective entity in the workflow with date and time). i could not able to find in which application database table certification status details will store. can you please help us with the table name. so that we can write method query to fetch the data.

Dear all, Could you please advise is it possible to generate and send direct link to certain cube view to recipient according to which he can open cube view (so that he doesn't have to search for a folder and cube view in this folder in OneStream)?  

Hi OS Community, I’m revisiting our key reporting dashboards and wanted to check if there have been any updates to the tabbed layout functionality. Since our dashboards pull large datasets from BIBlend tables, we’ve used button components as tabs to avoid long load times caused by the tabbed layout preloading all content at once. Has there been any change that allows us to restrict data loading when opening a dashboard, or is our current approach still the best practice? Thanks!

We are using the multiselect tool to gather certain entities for reporting, which will show up in rows in a cube view. We're returning to the cube view the values from the multiselect via an XFBR. When the user chooses the entities, we can't get the resulting members in rows to show as description, only as member name. Anyone know how to return the description in a cube view/report? 

Is there a way to extract a table with the processed information in tables that resulted from a rolling forecast?

I wanted to know if there is a way to automatize the process of import of data so that a user does not have to do it, as the client wants it to be done 2 times a day without a person being involved

We have a chart in which data will be at 0 for most of the year.  Is there a way to tell the chart not to print the remainder of the line if it is 0?  We tried to set up a member to return Nothing if the data = 0.  It looks like the chart is interpreting Nothing as 0.  Is there a way Ii can say if a cell is 0, set it to NoData.  And would that make the chart stop showing the lines on 0?As we move through the year the actual number will get bigger and the drop to 0 for the remaining months will look even worse.Thank you,Scott

I have a button on a dashboard that needs to change the values of two parameters with one click of the button. Is this possible without building an XFBR? The "Bound Parameter" property implies it can only control one. Placing a comma between two parameters in this property does not acknowledge the second parameter. 

Has anyone experienced after creating a shortcut that the OneStream icon is missing from the shortcut? If so, does anyone know how to resolve this issue? I know I can create my own icon and map to it, but I would think that this should be there.  Thank you

I want to give users the ability to add attachment in the cell with a dynamically calculated UD8 member. Dynamic calculation places the value of 1 into that intersection if the file attachment is present and the value of 0 if there is no attachment. I use these values to change the formatting of the cell if there is an attachment. I am an Admin and I have no problem attaching the file. However, other users are getting the "Error saving data attachment" message. I wonder what governs this and if I can give my users the ability to add attachments to that cell? Any suggestions are appreciated.    

Hi Community,Is it possible to execute a Book from a business rule?Regards

Hi, I'm trying to figure out how can I make few rows as un editable. Example: highlighted rows in below screenshot. I remember this can be done through Row overrides but its not working. In column member filter, I defined two dimensions as below. What should I define in Row override to have 'Total Revenues', 'Total Expense' and 'Personal' rows un editable?

Hi, I'm trying to create a form with set of accounts in rows and column should be for adding the adjustments. Here, I do not required to pull any data from the cube. Instead I have to update the adjustments based on the scenario selected. This should be a separate form where the adjustments data should not update the existing forecast data. POV:             Parameters in POV are defined to pull the accounts accordingly. Rows:  Columns: Issue: I couldn't get the form with editable fields. refer screenshot below. FYI: Can Modify data for Column is set to 'True'  

Hi everyoneWe recently upgraded to OneStream version 8.4 and are generally enjoying the experience.  I do have a question that I would like to pose to OneStream and the broader community.  Within the "Fixed Issues" section of the version 8.4 release notes there was the following:What was this intending to resolve?  We have seen an issue when we try to connect to both the OneStream and EPM excel add-ins to retrieve data from both systems.  When logging into the OneStream add-in, we get the following error message.  The solution has been to disable the EPM addin, close Excel, relaunch it, login to the OneStream addin.  Once we've done that, we can reenable the EPM addin, login to that, and then we are good.  Until the next time.Our hope was that setting the add-in compatibility filter to true, as shown below, would resolve the issue we are seeing.  Unfortunately that is not the case.   I'm looking for any advice or detail on fix in t

As you can see I'm not even sure how to title this post. I have a user from a sub who has asked whether there's a way to create a popup message to the individual trying to import data if they are loading to an incorrect (but viable) intersection? I've been asked similar questions in the past about creating popup messages.  I assume there must be a business rule we could create but not sure if such a thing would be possible during an event like importing data. Thoughts anyone?

Hi, I have a use case to format V#Annotation text fields in a Cube View to Red when it's blank, with Entity in CV rows. I'm using a Literal parameter, and using the XFBR to return "Background=Red" for the purpose. The issue I have is that I cannot seem to get Entity from Cube View to use in XFBR. Since Scenario and Time are tied to Workflow, can get those with no issue. Below is my code section to get Scenario, Time and Entity, but Entity is null when I checked inside the XFBR rule. string wfSceanario = args.SubstVarSourceInfo.WFScenario.Name;  //works string wfTime = args.SubstVarSourceInfo.WFTime.Name;  //works string currEntity = args.SubstVarSourceInfo.PovMembers.Entity.Name;  //doesn't work   Anyone has advice on how to get the Entity name used in Cube View Rows, in my case? Since Entity is not passed, all my cell rows are Red now.    My Row definition in the Cube View: Appreciate the help!

Edit: Have determined that if I remove a column from the BI grid view and then replace it, data will populate the component again. Still don't have a reason or fix for the issue.    Hello, I have a BI viewer that works fine in the initial setup/shows data pass through. I will run the BI in a dashboard once and it will also work correctly. If I run the dashboard again, it stops displaying data. I checked and my data adapter functions as expected, and if I delete the BI and make an identical version it will also work initially in the BI Viewer component once and the dashboard once.  The viewer operates off of two combo box member lists, and I've confirmed that those update my dashboard data set rule when I refresh my dashboard.  If anyone has any input on this situation it would be much appreciated.

Hello, I'm learning to use BI Viewer, is there a way where I can drill down the entity dimension from region to base level? I've tried different expansions and I either get only regions or everything and when I try to drill down the region, it just gives me the region again and not the base entities that make up those entities. Thanks, Will