OneStream Platform Forums

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 Chul Smith4/27/2020 How can you re-open workflows?

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 Michelle Greenberg We are in the process of implementing OneStream and our biggest business is on SAP S4.  We historically had an automated interface from SAP to BPC and would like to do the same with OneStream.  We are looking for other customers that have successfully implemented this that would be willing to share their experience

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 Justin MartinHi everyone,  I noticed in the Excel Add-in settings there is a setting called "Enable Macros for XF Event Processing." In the Design and Reference Guide, it says this setting enables Excel macros for OneStream XF api calls. Does anyone know where I can find more information about this?

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 Krishna SrinivasanDoes anyone connected Oracle Database as external DB ? If so could you please provide the connection string OLEDB or ODBC ? When I try to connect am getting the below error using OLEDB ?

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 Michel SabourinHow can you select which Cube View rows go to the secondary y axis in the dashboard chart?

Originally posted by Brad KoteckiIs there a way, or a best practice recommended, to point an XFGetCell formula to one or multiple members of the same dimension without adding parent level members in the dimension hierarchy? As an example, if we have entities 1 through 5, I'd like to be able to change an input cell to any combination of those and have an XFGetCell function to pull in the sum of all the data points referenced. Currently I'm thinking this would require nested If functions, but that seems like it would quickly get to an unmanageable length as the number of members grows.   Thanks Brad

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 Sarika PatilData from particular workflow profile, Scenario and time has been cleared. Trying to reload data  for the same workflow profile scenario and time. Got below error while loading .csv file Error: An Entity with same key already exist for .csv type file.    

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?