Discuss the features and functionality of OneStream.
Recently active
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.
Hi All, Is there a way to integrate OneStream with Hyperion to extract data from Hyperion without user intervention?
A user must upgrade to the latest software version in order to continue using Onestream Question Credit: Nick Hymes 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 Team, We have IE and Edge browser on the system. Once opened the OneStream application when we do Windows shortcut as per below screenshot it is creating the Windows short cut on the desktop. And, then when we open the OneStream application using the shortcut , it is opening on IE browser. How to create a shortcut for Edge and the application should open on Edge Browser when we use the shortcut. Thank you, Praveen
Was the OneStream product itself built using VB.Net? If so, I'm pretty impressed!! If it was built using C#, I'm wondering why customers are then forced to use VB.Net for business rules? It seems like a double standard. Is there a licensing reason why VB.Net is redistributed to customers while C# is not? If it isn't about licensing then maybe onestream has internal BR tooling that is incompatible with C#, or third party tooling that is incompatible? Any info would be appreciated. Obviously the selection of either .net language it is a matter of choice ... but if OneStream picked C# for development of the product, then they should allow customers to pick C# as well for our business rules.
It is important to gather reporting requirements after the initial build stage of the project. Question Credit: Becca Speese 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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.