OneStream Platform Forums

Originally posted by George Waddell 11/6/2019 Hello, Working on a client App that does not require currency conversion (only USD involved). Wondering what any considerations should be with setup (present and future). Anything special to be aware of when dealing with only 1 currency? Future considerations with setup today vs. adding translations possibly in future? Also noticed when trying to enter data in CV to "Local" member for Budget Scenario, could not enter unless Consolidation Member POV was set to None (??). Entities are tagged as USD.

Originally posted by Cosimo Palmisano 8/1/2019 FX Report - do we have an out-of-the-box report, cube view or dashboard for showing FX rates stored in an app?

Originally posted by Hein Scholten11/5/2017 Trying to open an XLbook from the Spreadsheet but that doesn't seem to work. I can open XLS but no XLbooks. Tried Open with... but that don't work either. Has anyone tried this? Or do we still need the add in for XL books?

Originally posted by Andrea Tout6/26/2018 Hey there! I am trying to do a spreadsheet form. So the form template is built as a dashboard because if you build a spreadsheet form, any prompts will show up as a dialogue, not be nested on top of the form. So instead I am making a dashboard that runs the spreadsheet with a combo box. It works for the most part, but every time I run it I get this error, but when I make a selection, in the combo box, it all runs fine. Has anyone seen this? I want to try this for my users but the error makes it look wonky.  

Originally posted by Andrea Tout 12/19/2019 Is there anything that we have that pulls when a user was created and by who? 

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 Craig Masters4/5/2018 Is there a setting that needs to be changed to allow Zero's to loaded? When I load a file with zeros, those lines are stripped out in the staging table. I need to merge a file with zeros to replace the amounts currently in the system.

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 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 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 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