Discuss the features and functionality of OneStream.
Recently active
Dear Community, Can we export a hierarchy/hierarchies into a relational table? For an instance if I want to export the complete hierarchy of any Dimension into a table view format whether it will be possible? I could see we have a Load/Extract to extract the metadata for a hierarchy, is there any other way to showcase or export into it in the form of tables?
Hello All,We've created a cube view to which users can submit weekly numbers & commentary using excel cube view. The intention is to provide them with about 50 rows for commentary (Not all rows would be used each month). Hence, we intentionally want to keep blank rows without suppression for users to enter data. Is there a way for the blank rows to not automatically suppress? Every time we hit refresh all blank rows disappear.We tried to toggle suppression settings in preferences to 'False' but no luck. Any help is appreciated!
Do comments consolidate up to parent entities via new functionality or does the below method of creating a dynamic member need to be utilized in order to consolidate comments up to parent entities?Finance Dynamic Calc: Annotations Consolidations - OneStream Community (onestreamsoftware.com)
We have a dashboard with a button that displays a dialog for user entry. The base dashboard has a cubeview that needs to refresh based on the values modified via BRApi.Finance.Data.SetDataCellsUsingMemberScript() calls. We are using a XFSelectionChangedUIActionType.CloseDialog task result to close the user entry dialog. Is there a way to programmatically refresh the base dashboard?
I need to test if a workflow channel is locked in a BR before performing the BR actions. Can I test if the channel is locked? How?
Hi All,Ive got a problem with transformation/load cube workflow steps in our build, It has been in our applications for over six months (an older dev application has the same problem). This error doesn't seem to cause a problem in our data although may affect a dimension we put into our application for future use, I want to isolate it regardless. The error is an "Object reference not set to an instance of an object error" and doesn't actually stop the workflow step from completing, making it difficult to track exactly what is going wrong. It also doesn't flag when compiling all business rules being only apparent whilst running the rule. This error occurs on all the load/retransform steps I have tested although that doesn't help much as a lot of our transformation rules overlap.Id really like to know if there is a way of viewing which business rule is failing on running these processes but cannot fathom how, is there a way to do this? Thanks,Tom
Hi,I want to use the XFMemberProperty in a cube view to call the number of no input periods in a scenario. This isn't returning a number though or anything. I get an error.XFMemberProperty(DimType=Scenario, Member=|WFScenario|, Property=NumberOfNoInputPeriodsPerWorkflowUnit))Has anyone had success with this? I am not sure the property name to use here, what I have is a guess; variants of this didn't work either.Perhaps there is an easier way to get the last no input month into the time filter? I want two columns, on would be the actuals YTD and include the T#YYYYM[number of no input periods], the second would use the same time filter but use the rest of periods in year time expansion.
When running a book, sometimes the user will be prompted with a second dialog box. The first will include all applicable parameters for them to select. After clicking 'OK', a second dialog box will pop up that reads: "There are no additional parameters for the selected item. Select OK to continue." Only after that will the book run. What causes that second dialog box and is there any way to stop it from happening?
I have been trying to give a couple of our users access to the Database Page in the System Pane. I created a new security group named DatabasePageAccess (and SystemPaneAccess) and add another security group and 2 specific users to this new group. I then changed the security group on the System Security Roles for the DatabasePage System User Interface Role to "DatabasePageAccess" and SystemPane to SystemPaneAccess. Asked the 2 users to test it out. They were able to see the System Pane now but cannot see the Database page still. I have been going in circles and cannot reason why they cannot see the database page when I seem to have done it all correctly. Has anyone else ever seen this?System Security Roles Screenshot from User (does not show the Database page as an option)
My CFO would like to be able to select a combination of children in our Department Dim and see our Net Income. Is there a way to dynamically calc that value. In the list below, he is asking if he can select to exclude IT from his query. We use FXGets alot but could also work in a QV member selection. Was wondering if maybe a BR could be created but not sure how to reference which to exclude in a FXGet. Would think it would have to be on the UD8 Dim or something. He wants to be able to toggle between different views. ie What does it look like without HR and Finance. Trying not to create a ton of Alt rollups in the Dim for all the different combinations. Ex: UD1 Total BU's Plant BU's SGA BU's Finance HR IT ....
I set up a Hybrid Scenario with a Data Binding Type of "Copy Input Data from Source Scenario." I tried following the example in the Design and Reference Guide (below) for the Origin dimension, where the properties are as follows: - Member Filters to Exclude: O#Top.DescendantsInclusive - Pre-aggregated Members: O#Top=O#Import When force consolidating, I get data in both O#Import and O#Elimination, but O#Top for my source scenario and hybrid scenario agree. Is there any way to only copy data into O#Import? As a side note, if I change Pre-aggregated Members to O#Top=O#Elimination, I only get data in O#Elimination. Thanks! Molly
Dear Team,I'm trying to check if value of a specific column is <> 0, if isn't I would like to inform user by some kind of Message Box.I was trying to use SaveDataEventHandler, but the issue is this value is not inputted by user - it's calculated by UD8.Do you think there's any another possibility? Thanks a lot!
The display of the parameter shows 2 Accounts selected but when retrieving the parameter in the business rule only the first one is passed.If I display the list box selections on the dashboard it shows the correct selections, comma separated.If a comma is in the string that is passed to the Business rule, only the information before the comma is recognized. If there is no comma, the whole string is recognized. Label:Copy '|!Prm_SourceScenario_QMC!|' To '|!Prm_TargetScenario_QMC!| ' For A# '|!Prm_SourceAccount_QMC!|' , T#'|!Prm_SourceTime_QMC!|' , V#'|!Prm_SourceView_QMC!|' , F#'|!Prm_SourceFlow_QMC!|' Button:{CopyQuorumToForecast_QMC}{Prm_SourceScenario_QMC=[|!Prm_SourceScenario_QMC!|], Prm_TargetScenario_QMC=[|!Prm_TargetScenario_QMC!|], Prm_SourceAccount_QMC=[|!Prm_SourceAccount_QMC!|], Prm_SourceTime_QMC=[|!Prm_SourceTime_QMC!|], Prm_SourceView_QMC=[|!Prm_SourceView_QMC!|], Prm_SourceFlow_QMC=[|!Prm_SourceFlow_QMC!|]} &n
Hi Experts,I want to limit my cons member only to "Elimination". can I use "api.pov.cons.Name.XFEqualsIgnoreCase("Elimination")"
hello Team; I was using Reporting Studio for a 6.X version, now our environment was upgraded and download the client version (7.3.3) the Reporting studio is not in the package, I searched in OnePlace for the software but can't find it; does anyone knows where could I download? or it was disabled for new versions. Thank you in advance and Best Regards.Mario GV
I am going through the process of making an application multi-language. There is one area that I cannot work out and it is an important element: Certification Questions. I am using XFStrings to hold the translated text and this is then used on Cube Views, Dashboards, Confirmation Rules etc. Certification Questions do not execute the XFString function and there is no event I can find for building the Certification Questions form. Does anyone have any ideas?
Hi Experts,When do we exactly use DataBuffer1, DataBuffer2 in rules. while we have databuffer in api.much appreciate if one example can be provided atleast
I know we can use the Matrix setting in our Data Sources to import data where time periods are in the columns (i.e. M1, M2, M3, M4, M5 M6 etc.).Is anyone out there aware of a way to extract data out of OS in the same type of format (time periods in columns); either by way of a DM step or any other way?
A Form Template is required in order to use a Cube View for data input. Question Credit: Chul Smith 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 all, We have a Global Chart of Accounts that is used for both our Statutory and Management reporting. For our management reports, there is a requirement to have expense items below OP showing as negative - such as Tax, Interest, Depreciation etc. Opex accounts above OP will be shown as positive, as is currently happening. I understand this could be done by allocating the sign flip to the specific accounts in the transformation rules and/or changing the account type to Revenue, however, this is only relevant for the Mgmt set of reports, not the Stat reports. I'm interested in seeing if anyone has any ideas for how to show different signage on certain reports, rather than applying them all reports. On the cube views, the rows currently us A#M_NPAT.base for the entire CoA . Thanks in advance. Andrew
Hi Experts,I am trying to read the member ID in data buffer to assign some values accordingly, But it is giving in correct ID seemsin the log file i can see ID as "-1" , Generally Member ID was different in the dimension library if this is readying correctly - Kindly confirmDim vSrcUD2Split As String() = Split(sText2,":")Dim GetUD1Ac As String = Trim(vSrcUD2Split(0)):Dim GetUD1Mvt As String = Trim(vSrcUD2Split(1))Dim vTgtActID As Integer = api.Members.GetMember(DimType.Account.Id,GetUD1Ac).MemberPk.MemberIDapi.LogMessage(vTgtActID) Outcome is : -1
Hi,I'm using a Derivative Check Rule for the first time - using the sample available in GolfStream (HoustonSalesDetailOffset > ValidateCheckSum) - the Rule itself is working fine, I am getting the correct Pass/Fail Status. My question is where can I expect to see the CheckRuleMessage displayed?GolfStream Sample: My Result (partial screenshot only as from Client App):It feels like there's a column missing from the screen? Or perhaps it should be a pop-up window on the right like with other Validation/Intersection errors?Thanks in advance for any help!
I have 50 rows and 4 columns, here I have to do a calculation with cell wise.For eg: col4row20 = col1row1 / col1row10 col4row21 = col1row2/col1row11 col4row22 = col1row3/col1row12Likewise I need to input the multiple formulas for the cells, here what type of member formula I can use.
Is it possible to use the right click - Navigate button in a quickview?This button shows up but it is greyed out. I would like to see if there is a way to navigate to a dashboard similar to creating a linked dashboard in a cube view. It would pass the default parameters (ie EntityNavLink) from the quickview.
I have a case where the client needs to add members to a dimension regularly and the ADM, Add Dimension Members, dashboard is idea as found in GolfStream. However, there is a problem in the ADM_SolutionHelper rule that stops this from running. It doesn't compile properly. Error compiling Business Rule 'ADM_SolutionHelper'. 1) Error at line 136: Property 'Name' is 'ReadOnly'. 2) Error at line 137: Property 'DimId' is 'ReadOnly'. Can someone explain how to resolve this please.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.