OneStream Platform Forums

We have several equity accounts with "USDOverride" entered for Text 1 in the "Vary by Scenario Type And Time" section of the member properties. Those accounts are not translating from local currency to USD.  Any ideas why that would be? Thanks!

Hi, I have a process that would be run at the month end to lock the workflow. Once the workflow is locked, you need to refresh the application to see the lock icon on the period in the workflow. The icon doesn't change until you hit the refresh button. Is there a utility in the business rule to refresh the application (I would need to include this utility in the business rule) ? Ragav.

Is there a way to enable Account descriptions in other languages like Dutch?

Hi everyone, I am trying to add records to a table via an Excel Table View. Using the example in the Table Views documentation, I am able to update existing records; however, any new records added are cleared once I submit the sheet. Is there additional code I can add to allow the Table View to write new records to the table? Thanks! Molly

I need to move data between two mutually exclusive cubes. Cube1 (FinPlan) U3 dimension base level is ProductType, Cube2(SalesFcst) UD3 base level is SKU which rollup up to ProductType. SKU also has a Text6 field containing its ProductType Code.   I also have separate Account dimensions: Cube1 uses FinAccounts for Forecasting, while Cube2 uses the SalesFcstAccts dimension   To move the data from Cube2 to Cube1, I tried using a Business Rule using the api.Data.ConvertDataBufferExtendedMembers function Cube is an option:    Dim summarySalesFcstData As DataBuffer = api.Data.ConvertDataBufferExtendedMembers("SalesFcst", "Fcast1", dbSalesFcstData) However, it didn’t replace the SKU with its ProductType. Does anyone know is this function will work between mutually exclusive cubes with different account dimensions. The second approach I would like to try is to extract the data from Cube2 including the SKU Text6 value of ProductType, then I

Hi !I'm interested to get data from the AuditFXRate table, however this table is not giving the Currency names, but only its ID.The problem is that, the Currency names are nowhere to be find in the datatable of the application ( it is not in the "Member", "MemberProperty" or "MemberDescription" table). The only plase I can get a reference of these currency is in the "AppProperty" table, where all currency are stored in one row.Needless to say, the table "FxRate" is not showing the Currency Name as well 🙂 --> Where can we find the CurrencyID + CurrencyName information in OneStream ? Regards,

Hi All,   I am wondering if there is a way to display a text value in a cube view cell directly from a cubeview member filter?  In other words, in the same way that you can use a member filter with GetDataCell to force a number to be displayed (ie. A#Net_income:GetDataCell(100) will display 100), can you do something similar for text values like A#Net_Income:GetDataCell(Hello) to display Hello in the cell?  It doesn't work for me and I have also tried using A#Net_Income:V#Annotation:GetDataCell(Hello) and that doesn't work either.   Any thoughts?   Thx, Mike

I am trying to clear entered data from the particular Cube but unable to do so using "Clear Data" Rule. Can anyone suggest me the process to clear data from any cube without disturbing other cubes' dataset.

Hello I have built a workflow structure for a statutory application where every legal entity has is own workflow. In the entity assignment only 1 entity is assigned to the specific workflow. Data load and input forms work fine because Onestream blocks user to enter data on an entity <> from the WF entity. Inside each entity workflow we enabled the user to post adjustments.   But for journals Onestream behaves differently.  Because when creating a journal, Onestream propose the list of companies the user has access to regardless which is the company assigned to the workflow.   Here I am in the workflow of company 1.   But Onestream prompt with the list of entities I have access to. So I can post a journal on entity XYZ on "company 1 workflow". So I am allowed to post a journal on an entity outside the assigned workflow.   Is there a way to force the user to post a journal only to the workflow entity?   Thanks, Marcello      

Hi I am tried to configure a hard error on quarters and warning on off months for IC balances above thresholds.   The error I can use frequency Quarterly but for the warning I want it to run 1,2,4,5 etc.  I tried #TWFYearM1 or just 1 or just M1 but none of them worked.  Help?  Also checked the documentation says nothing about format and there are no examples in Golfstream.

I can use substitution variables across multiple OneStream applications on the same server. Question Credit: Gabriela Columna   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi ! I came accross the "State Indicator" dashboard component, but I can't seem to find any information about how it's used and how to configure it, either in the online help and on the community. Could you please let me know if someone has already used it and what's the purpose of it ?   Many thanks ! Regads,

How do I view the POV of the datacell executing BusinessRule.DashboardStringFunction XFBR business rule?I think I can run this statement:Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = "  & viewMember.tostring) Is there a faster way to view all 10 dimesions in POV of the datacell ? These do not work: Dim POV As POV = ViewMember.GetItem(api.Pov.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = "  & POV.tostring)    

Happy Labor Day for USA. Happy gas shortages, high electric bills and soon coming freezing winters for many of us around the world.I renamed my Cubeview from CV1  to CV2_deleteVersion08302022. Why did my workflows  automatically change its configuration to use new name CV2_deleteVersion08302022? Should it not remain as CV1 ?  I'll try to give a screen shot

Happy Labor Day!!How can I use BusinessRule.DashboardStringFunction, i.e. XFBR string business rules to extract text out of a datacell in cubeview that has users' text stored in V#Annotations?We have successfully used XFBR string business rules to extract amounts from datacell in cubeview. However, when I tried similar lines of XFBR code in my cubeview – I am not able to pull users’ text.It is returning zero. Users are putting text into CV cell that has this combination - A#Explaination:U8#Comment:V#Annotations . Here are a few lines the don’t seem to work1)Dim Explain As DataCell Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, cube,"A#Explaination:U8#Comment:V#Annotations" ).DataCellEx.DataCell2) I tried the next line:Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"A#Explaination:U8#Comment:V#Annotations" ).DataCellAnnotationbut I get the error message : " Does not recognize .DataCellAnnotation. 1) Error at line 71: 'DataCellAnnotation' is not a member of '

Hello,   I have a Cube View that prompts the user to select the month for the report when it is run.It would be great if it could select the current year's first month by default. I have tried some different things in the Default Value such as WFYear, T#WFyear, |T#WFyear| and others but cannot get the default I need. Does anyone know what the syntax that I am looking for is? Thank you very much for your time and involvement!      

Hello Team I created a Nested member expansion under a cube view. It works fine with grouping of the nested dimensions as in picture#1.  But by default it always have the list grouped. Is there an option to have them all ungrouped by default (pic#2)? Thanks!!

Hello All, It might sound like a simple question but I could not find the code in snippet or elsewhere of how to grab in a rule a list of all groups a user is part of. Could someone share how to do that ? Thank you Matthieu

Hello,   I have this Cube View that I created in which I have to move the half year (H1) column to be in between Q2 and Q3 in order to match the formatting of the report that I was given as the model. I have attempted to make some changes to accomplish this but I have not been able to do so. I am displaying the quarters as Time:T#WFYear.Quarters       How can I accomplish this formatting goal? Furthermore what is the synthax that would allow me to display a single quarter of my choosing?    Thank you in advance for your time and cooperation!

Hi All, Does anyone know of nice reporting on the metadata and the properties of each member?  Basically, I am looking for something like the Dimension Library Grid View to be displayed in a user-friendly report.  Before we start building something I wanted to make sure someone doesn't have an easy solution for this.  Would want something that users could easily access perhaps via Cubeview or Dashboard content. An example would be a report that shows all of the accounts with their metadata properties (ie. description, AllowInput, AcctType, Text1-8, etc.).  I checked the Application Reports (RPTA) that is in MarketPlace but it doesn't have anything.   Thx, Mike

Hi all, How can I run a batch file from a Workflow within OneStream?

We have added a new dimension and associated transformation rules. Previously this dimension we set to 'None' through a static value text definer from the Data Source.I have removed this and now added the respective transformation rules needed, however when retransforming the data, this new UD is still defaulting and sitting as 'None' Any ideas? Or do we need to remove all the data files themselves and reupload to update the mappings? 

  I can change accounts and entities by scenario, just using scenario views Question Credit: Peter Fugere   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello,   I have this cube view that I made, in which I am having issues in the secon to last column. I am trying to see what the difference between each quarter is between the forecast and budget scenarios.When I run my cube view, I get a single difference between Q1 forecast and Q1budget only, and Q2 trough Q4 are nowhere to be found. I was expecting that what I typed would give me the difference between each quarter, not just the first.       Can you share what your thoughts on what I am doing wrong please?Your time and input is appreciated in advance!

Is there any way to edit Transformation Rules in Bulk?When I try loading a trx file or xml code into the system it doesn't overwrite the rules which causes issues in someplace.Is there a way or a template where with direct upload I can delete that transformation group and create a new one with the same name. (Example- Dimension delete template where uploading a certain xml file directly deletes some dimension members)Thanks.