OneStream Platform Forums

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

Hello All, I'd like your input on whether it is possible, or not, to conditionally display or hide a dashboard's component ? I have a case that, depending on the scenario selected in the workflow, I want in my dashboard to display, or not, a button (that will then allow user to seed forecast, but I want them to be able to do that only when they are doing their forecast, as dashboard is shared across scenarios) I tried to use a XFBR that would return me a different value (True or False) depending on the scenario selected and add this XFBR as value of the setting "Is Visible" of the button component, but that didn't work (thrown an error "Index was outside the bounds of the array"). So I don't know if it's because it's not possible or I did an error but open to any suggestions to make this requirement work Thank you Matthieu

Hi,I need to build a cube view where I want to have Accounts base as well as U1 Base. Something like this: The problem is when I am running this - Onestream crashes. Supression settings are on: Is this because of too many intersections to look at?Account Dimension has approximately 6000 base members and U1 has 1200.Can anyone suggest a way on how to build this?Thanks.  

Hello, Is there a way to make cells display numerical data in the millions of dollars amount? As an example 1,500,000 would be displayed as 1.5 I have looked around but did not find much information on the NumberFormat paramater so it is kind of confusing in terms of synthax. Thank you in advance for your time and participation.

Hi,   I am working with WorkflowClusterPk objects and I know I can get the ScenarioKey, which is an integer, like this: Dim scenarioKey As Integer = si.WorkflowClusterPk.ScenarioKey   How do I get the scenario name (as a string) from the ScenarioKey? Is it possible? Alternatively, which function could I use to get the current workflow scenario name?   Thank you

Hello, I have a blank line on the left in this Cube View, under Total OpEx. I’d like for this line to be completely blank, is there a way to make the highlighted icon disappear? Thank you for your time.     Thank you in advance for your input!

Hi all, I am trying to create a journal where the UD dimension elements are selectable on rows. The default setting shows only accounts in the rows while the UD elements are in the journal POV.    How can I move some of the UDs on the rows to achieve an HFM like journal where the user can reclass from 1 UD element to another UD element? Thanks for the help Marcello  

Hi All,Can we build a transformation rule with a logic that if the target of lets say UD4 is 'xxxx' and source Account number is 'yyyy' then UD3 gets mapped to a particular code?To simplify- Need to look at Target for UD4 and Source for Account to map to a specific UD3.Thanks.

Hello, I am trying to have a member rule dynamically calculate and not consolidate to parent entities, which is working.  However, it also needs the member rule to override the summation of MTD to YTD.  I need the account to recalculate always.   i have a simple api.data.GetDataCell ("A#Account1 / A#Account2) I have the settings: account type: dynamically calculate formula type: dynamically calculate Is consolidated: Conditional is there something else i need to do?  thank you

I need to build a button where with a single a DM Sequence with multiple steps as well as a Dashboard Extender rule runs.I earlier thought that we can have a Execute Business Rule Data Management Step as one of the steps within the sequence but I wasn't able to find Dashboard Extender Rules within that.Can any of how guide on how that can be done? Thanks.

I have a cube view where some of the mathematical operations in the last two columns on the right ( Difference and Percent Difference) are not working. The formula that I have in these last columns is as follows:GetDataCell(BWDiff(CVC(OP) ,CVC(Actual))):Name(Difference) GetDataCell((CVC(Difference) / CVC(OP)*100)):Name(Percent Difference)   The yellow highlighted cells in the right hand columns are the ones where the math is not working and they are not populating with results.   Below is the structure of the cube view I have:   I have noticed that the cells on the right columns where the math is not working and not populating are the ones where the corresponding row has accounts that are in the form of a sum of two or more accounts, as an example for my Row1 I have: GetDataCell("A#60100+A#60900"):Name(Salaries & Benefits)   It is apparent that the issue in the cells that are not populating is due to the accounts in those rows being the sum of two or more acco

Hello, I cannot find where is the place where to set the folder directory of server files (using the data import profile type).     Thank you for your feedback.   Marcello  

Hi All,So I copied scenario using the Data Management Job and using the below Custom Calculate Rule:Api.Data.Calculate("S#ScenarioType1:O#Import:V#Periodic = S#Actual:O#Top:V#Periodic")Now whenever I am running a consolidation for ScenarioType1 at the parent level, all the values within the base is getting removed and neither is the parent populated. Can anyone help me with incorrect step am I doing?

Hi OneStreamers,   I am trying to build an XFBR which I will link to a CV Column, that will either "True" or "False" Depending on the value of a parameter.   However I am finding trouble returning the value. I came up with this but it seems tor eturn the Default Value of the parameter and not the Selected Value :  "If args.FunctionName.XFEqualsIgnoreCase("CheckScnForVisibleColumn") ThenDim ScnParamName As String = "3_cm_param_S_SelectFC"Dim ScnParamValue As String = ""ScnParamValue = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, ScnParamName)brapi.ErrorLog.LogMessage(si,ScnParamValue)" Appreciate your help 🙂    Regards, Adam    

This is a basic question related to cubeviews. When I open cubeview_1, it closes cubeview_2.  When I open cubeview_2, it closes cubeview_1. Is there a way to keep both my cubeviews open in the desktop?  This seems like a silly U/I constraint to restrict users from working with more than one cubeview at a time.  We are using Desktop v.6.5.0.12623. Any help would be appreciated. Thanks, David PS. I have lots of peeves about the U/I but this is a major one.  Others include No standard ribbons, like every other windows app Navigation tabs that are shown across the BOTTOM of the Window!?  Mousing around the top, left, and bottom of my screen is just bad. Very low support for keyboard shortcuts. (even basic things like Ctrl+N, Ctrl+S, etc) Virtually no right click (context) menus etc.  None of these are rocket science, and hopefully I'm not the only one who is complaining...  

Cube views are the main building block for reporting 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 All, I want to display the default currency value for specific entities in a cube view. Account being displayed is of type Balance so ShowCurrency setting fails to display currency here. Thinking of writing a XFBR rule to pull currency and display custom names in the rows along with Entity names. Is there a better alternative to achieve this? Any leads would be appreciated.

Hi all,I would ask your help on this topic.I would like to develop a workflow in which the requested steps are different from month to month.The goal is to have a basic input package for all months plus additional steps required only during the quarter closing periods (MAR, JUN,SEP and DEC). See the example below ExampleJAN:    Forms:    Balance Sheet, PL    ValidationFEB:    Forms:    Balance Sheet, PL    ValidationMAR:    Forms:    Balance Sheet, PL, BS movements, Additional disclosure (like flows, headcounts...)    Validation    CertificationAPR:    Forms:    Balance Sheet, PL    ValidationMAY:    Forms:    Balance Sheet, PL    ValidationJUN:    Forms:    Balance Sheet, PL, BS movements, Additional disclosure (like flows, headcounts...) 

We'd like to calculate CAGR in cube views, is there a formula to use in the cube views? If there are formulas that only work for dimension members and business rules I'm also happy to hear, then link to the cube views. I already tried "POWER(x,y)" and "x^(1/y)" and they don't work. Thank you in advance!

is it possible to add a blank row in the account field?  i found that you can use A#None and it will make the numbers blank. is there something else you could use to make the numbers blank and make it say something besides None or something else? 

Hi, is there an easy way to prevent users to work on wrong periods? It seems that all periods in Onestream are open for data load.   This request is mostly related to statutory consolidation.   My concern is that some end user can start working of Jul 2042 (instead of July 2022) after realizing after a week that he is working on the wrong period. I know that in Hyperion the admin had to "initialize" the data unit setting the "Review level" as "First pass". If status is not "First pass" nobody can work. Instead in Cognos Controller the same feature is achieved with the "Submission" creation, where the consolidator selects Scenario and Period to open and which forms are assigned to the specified submission. If Cognos submission is not set obody can work.   I am wondering if there a standard feature in Onestream to lock all periods and then enable them month by month?   Thanks in advance for the help, Marcello