Discuss the features and functionality of OneStream.
Recently active
Originally posted by Eric Osmanski3/28/2018 Spreadsheet as Form: Is there anyway to embed the parameters from the CV as drop downs as to not get prompted every Refresh and again on Submit?
Originally posted by Felipe AlcortaIn our previous consolidation/reporting tool (Tm1/IBM), we always had the ability to group certain members together without having to create a hierarchy. We could group them manually by picking them or grouping them based on a particular attribute. Can OS do anything similar? For example, if I want to group members 1, 2, 3, and 4 but they have different parents, I'm trying to replicate the XFGetCell (1+2+3+4) functionality so that I just pull a single grouped member. TIA
Originally posted by Chad FortmanOS Version: 6.0 Platform: Cloud Hello, I am working on an enhancement for our automated change management process. Lately the focus has been on Workflow Profiles. Within the AuditWorkflowProfileEntityCalcs table (Application Database) you will find a column for CalcType which holds a numerical value. I would like to find the enum or table that holds the friendly name that correlate to these values. The API Details & Database Documentation help file does not seem to contain anything related to this column. Anyone know anything about this?
Originally posted by Samuel EsquedaHow can you programmatically roll through Transformation Rules? I have a BEX query that needs to query a list of nodes that I hope to save in a UD Transformation Rule. My thought is I can list the nodes in a Rule and have the users edit them as needed. When it is time to run the BEX query, I can query that Transformation Rule and use that list of nodes in the BEX query. My problem is I do not know how to roll through Transformation Rules. Anyone know if this is possible or if I should store this list elsewhere in OneStream? Any feedback is very much appreciated. Thanks!Sam
Originally posted by Darryl GerrowDoes anyone know if there is a system Metadata Dashboard that will show me when relationships change in a dimension? I seem to only see the ones that show Insert/Change/Delete members, nothing about relationships.
Originally posted by Jean-Daniel PelchatIs it possible to display a value different than the Member name of the View dimension ? For example, the View = Trailing2MonthTotal. But in the cubeview, I would like to display a shorter texte, example "Trailing 2 Mth". Thanks,
Originally posted by Felipe Alcorta Hi all: In our current model, we have 100-200 new dimension members every month with actuals from our source system. Part of the maintenance is the manual add of descriptions for all these base members. I am doing it via a grid view in the dimension library but OS only allows me to copy paste (from Excel) one at a time. Is there a way to copy/paste multiple at once using the grid view? Or is there a better way? I'm hoping I can leverage Excel + OS front end rather than having to find a solution via the Marketplace. TIA
Originally posted by Krishna SrinivasanHi - I have a custom calc and I am trying to execute the below calculation and I am getting an error has anyone encountered it ? Is this something because the data type should be in Decimal ? Any help would be appreciated. api.data.calculate("T#2020M2=T#2020M2" * (1 +100) ) Error in DataBuffer.operator *. Error in DataBufferCell.operator *. Value was either too large or too small for a Decimal.
Originally posted by James KirkbyWe are working to build a set of cube views which will eventually become pages of a management operating deck. The cube views will contain the same set of rows month to month, however, the column set will change as the year progresses. Example: Q1 - Actual, Budget, PY Actual, Variance to Budget, Variance to Prior year Q2 - Actual, Outlook, Budget, PY Actual, Variance to Budget, Variance to Outlook, Variance Prior Year Q3 - Actual, Forecast, Budget, PY Actual, Variance...etc.... I would like to have our cube views return the correct column set based on the POV Period. I'm guessing there is more than one way to do this. Does anyone have an example of this? I was thinking an XFBR String directly in the column sharing name would work, but I'm not sure if that's allowed. Or can you only do this in Dashboards with literal value parameters? Thanks.
Originally posted by Keith Chapman Is It possible to add a member to the View Dimension? Say Current Month Vs. Prior Month Variance Member? We would like to be able to Drill down on the Current Month Vs. Prior Month Variance # that we now have created in a report.
Originally posted by Alona Edwards
Originally posted by Dhwanish Patel Hello, I have 12 different applications, and I want to provide access to 12 different users to these applications. How can I assign security to these 12 different users at once? Instead of going to 12 different applications and assign users. Thank you in advance.
Originally posted by Jill BalkeIn using RCM, we have some accounts that we would like to mark as Not Required, due to mapping changes in the Transformation rules, but also, to be on the safe side, we would also like to be able to make sure that no new balances wind up in the old accounts. Is it possible to setup a Dashboard that would look at the Not Required accounts in order to ensure they truly stay at a zero balance?
Originally posted by Dipali Pawar
Originally posted by Sheila GraffOur company is in the build stage. We are looking for some input from OneStream clients on their experience with building a granular workflow profile. Looking for pros and cons. If you stayed with this approach or ended up pulling back. Any insight is appreciated! Thanks!
Originally posted by Diane Rochford How to I get the variance explanations, entered at base entity, to agg to the parent entity?
Originally posted by Ashish Magar
Originally posted by Todd Allen Hi all, I have a question in regards to the Financial category. What is the best practice for naming conventions when first creating a cube. Should it be the name of the organization or something more generic?
Originally posted by Darrin SutherlandI have created both a Basic Chart and an Advanced Chart in a Dashboard. The Cube View for the charts has 1 row (Sales) and 4 columns (Actual, Budget, Forecast, and Prior Year). I want a bar chart that shows the four scenarios side by side. For the Basic Chart I chose a Type of Bar and for the Advanced Chart I chose a Type of BarSideBySide. In both cases, when I run the dashboard, the four data points overlay each other instead of being side by side. I can see the four different numbers on the screen, but only the top bar is visible and the others are hidden behind it. Can anyone tell me what setting I might have set incorrectly? Thank you.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.