Discuss the features and functionality of OneStream.
Recently active
Hi Everyone, Thanks in advance for the responses. I am reviewing the impacts on a force consolidate on a specific entity and noticed that my results differ when i run a force conoslidate from a cube view and a force consolidate using the calculation definition within process cube. I made sure that my POV was identical on the cube view versus the process cube. Can someon explain to me what the difference is or how there could be a difference between the two methods? Thank you!
Good Morning, Everyone -- I have a report which showcase forecasted KPIs using a set of assumptions and conditions. There is a growth rate that is been used to grow the KPI for each forecasted month. Do we have something similar within Golf Stream? Would appreciate any ideas. Thank you!
We just downloaded the latest version of ACM released in March. I am using the ACM BRs to load hierarchies from a table into OS dimension. I have populated the member and tree tables as needed and everything seems to be working fine, however we are not seeing an option in which this load would follow a “merge” like behavior. Currently if my table does not have a specific member or relationship. Onestream is just deleting/orphaning those members. Is there a way to have this behave like merge that it does not delete existing members in Onestream which is not present in the table or incoming load. We had similar behaviour in prior version of ACM but are not seeing this now.
We have data imported periodically to a Scenario with the following setup - Retain next to True and everything set to Periodic inclusive of the data source and TR as shown below. The account is an Expense type. In the example - M4 is the only period with a value for this specific intersection, which we see in the Import data screenshot. The Cube View screenshot shows the periodic and YTD views wherein it appears that the periodic M5 value is reversed even though is no data loaded for that period. Based upon my settings and the data presented here I did not expect to see the M5 reversal amount. Does anyone have a suggestion as to why the value is reversing in the next period and how to resolve this so that this doesn't happen?
I have seen a few posts related to this topic but have yet to find any concrete answers. We are looking for a way to sum members when going to the base level with a where clause without seeing all base members. For example, we would like to get a sum of all of our Value Added Products. Our UD4 dimension lists our products and we stipulate whether they are Value Added or not by putting "VAS" on Text Field 1 of the base member within UD4. Ideally, we could compare our Total Sales at a top level with our Value Added Sales without seeing each individual products. We are looking to report on all of our Value Added Products without seeing each base member. We have tried a few business rules and other suggested avenues but we are not seeing the results we had hoped for. If anyone has any insights on this that would be greatly appreciated.
I am building a data adapter utilizing the SQL command type. In my query, I reference the ConsId field. What database table can I join to for the Name/Description fields for the ConsId field on my primary table? For example, I can join to the [Member] table on the [DimTypeId] and [MemberId] fields to return Name/Description fields of an entity or account, ect. I'm also looking for currency ID Name/Description, if that is held in a different location than ConsId. Example of my query: SELECT JLT.[ConsId] FROM [JournalLineItem] as JLT LEFT JOIN JLT.[ConsId] = [Tbl_Cons_DimensionData???] WHERE JLT.JournalID = 'ABC'
Hey All,I'm trying to add a column (bar) chart on top of this line chart. But I want it to reference and add a dollar based stats account (e.g. Avg Fleet Total) bar chart. I noticed there is a way to add a second axis on the right - so wondering if I can have two charts on the same pane. Appreciate the help folks. Thank you!
We currently use the XFR_MemberListRanked business rule (from Golf Stream) to rank items in our cube views. We have a request to rank based on percentage. I'm curious if anyone has a solution for this or has done this in their application.
Hi All - I'm trying to understand why this would occur. I had loaded some prior year data, but somehow one of the month is showing negative numbers. I tried to consolidate but it wouldn't change. Wondering what I need to do to fix this?
Hello, Apologies if this seems like a rather basic question but I couldn't see anything in the Golfstream app. Is there a standard business rule I can take which copies data from one POV into another and modify it so I can effectively combining two base entities into one? Thanks, Oliver
What is the best way to stop administers to see the PLP Register and plan tables from the system /database tab. We have added the access/maintenance group for ancillary tables setting in the config file, however that is only stopping getting the to the PLP register dashboard. However it is not stopping the following two items Admins being able to go to system/database and see the table dataIf I create a new dashboard with a data adapter and write a sql query on the register table, any user with access to the dashboard is able to see the salary data. What is the best practice for this. Also – if we use any additional custom tables to load additional comp related data , is there any way to provide security on those custom tables ?
Hi,We have created one Cube view with using "True (but determine sparse rows using other columns)" option under Allow Sparse Row Suppression in Column level and gave "True" under Allow Sparse Row suppress in Cube View properties level as we have used Nested members in Rows with Parent.Base member combinations in Member filter level. When we run the report, it suppresses the rows as per other column even though formula column is having data also. Ex: Cube view created with 2 columns1st column with Account12nd column with calculation GetDataCell(A#Account2 + A#Account3)Row is getting suppressed if Accout1 doesn’t have data even though Account3 is having data also. If we remove above suppression options report throwing an error as exceeding the rows limit since hierarchies are big. Could you please let me know if there any option we can use to show the data at 2nd column level in above scenario
Hi, We have created a cube view report with nested dimensions in row. Our requirement is to add header for each dimension. Attached the screenshot for reference. Could you please let us know how to add the header in this case. Thanks & Regards, Madesh K
Hello everyone - As the title mentions. How do I grab a list of entity members which contains the word "district" within its name/description?
Hi, We would like to have account instructions in one place like a manual on how each account in the Balance Sheet and Income Statement etc. should be used. Are there anyone that has tried to incorporate that into Onetream? Like below: All suggestions highly appreciated
Hosted by Azure/Managed by OS, so never spent anytime learning how to monitor our environment other than at the very high level (System-Environment-Refresh). Hoping someone can point me in the right direction. Really looking to see how long Excel queries take, steps within consolidations and just general overhead. I seem to remember something provided within Azure to monitor but not sure if that is still around or not. We are heavy for 8 days and adding more functionality so need to make sure we can still run acceptable during that time.
Originally posted by Ashok AmreshWe are loading data using SQL connector business rule and it works fine manually. looking for a way to load it automatically using a extender business rule and then calling from DM step. has any one done this? can you share sample code if possible?
I have a report that uses it's own conditions to calculate a value. Is their a way to over-ride the blank/data cell in cube view, and have it run a simple IF conditional calculation? Most of these conditional calculation are for KPI's (basically forecasting for 2023 and on..). One of the condition within excel I'm referencing. Would appreciate your suggestions. Thank you! Best, Mustafa
Hi OneStream Gurus, I have a workflow profile with multiple rows (assigned entities, parent node....). One calculation definition executes a data management sequence. I am using the WF text to pass the entities to the DM sequence and this works fine.. But I was wondering if there is a way to pass the entity from the calculation definition row to the DM calculate sequence or the data quality event handler business rule. As expected if I use the E#Root.WFCalculationEntities in the DM calculate it runs for all entities defined in all rows. Thanks Maja
Is it possible to have a number formatting to show a dash "-" rather than a zero "0"? Thanks
Hi, I am (again) trying to use parameters in a SQL table editor. My parameter is set in order to get a column from an SQL table. When I test the parameter, this is working fine. However, when I add this parameter (which is a bound parameter) to the column of my SQL table editor, I do have the set of value from my parameter, but when I save the selected element, it appears blank. When I check the SQL table itself, I can see the value. This is probably silly, what am I missing ? 😓 Parameter definition : SQL statement : SQL table editor for the selected column : AllowUpdates = True, ColumnName = INDEX_CSR_CAT03, DefaultValue = |!P_CSR_QUESTION_LIST!|, Description = [Question code], ParameterName = P_CSR_QUESTION_LIST State of the SQL table editor before save ; State after save : SQL table :
We have cubeviews were we have enabled "Include Cell Attachment Status" and we want all comments printed on the PDF report at the end with reference to the POV, is that possible and if yes how do we do it? We have used Annotation Detail as we what our users to be able to have answers questions in a new Annotation Detail. Any advice highly appreciated! // Katarina
Hi OS gurus. Hoping to get a little help on converting a Hyperion line of codethat is using SUMRANGE to OneStream. Here is the Essbase line I am trying to convert: IF(@ISMBR("Assoc Ex Elim"))@SUMRANGE("Cash - Asset",@CHILDREN("Assoc Ex Elim"));ENDIF This piece of code is going to reside in a Flow member that has already been setup as a DynamicCalcTextInput member. It already has codewhere it is calculating account "A29970 - Assoc Ex Elim" based on if a Cash account is positive or negative. It works good but is doing it for all UD1 members, we want UD1 member named"Assoc Ex Elim" to not use this Cash account formula but rather just consolidate what it's children have. This is what the Hyperion code is doing. I have tried the following but no data comes back for it:If api.Pov.Account.Name = "A29970"Dim UD1NAME As String = api.Pov.UD1.Name If api.Pov.UD1.Name = "Assoc Ex Elim" api.Data.Calculate("F#ENDBALCALC=F#ENDBALCALC","A#A29970",,,,"UD1#[Assoc Ex Elim].Childr
Hi, Is there a way to set up dependant parameters, ie. Paramater value that depend on another parameter?The idea is that the user select a value among a list in parameter A (which is not a dimension element), then the list in parameter B will be filtered based on what has been selected in Parameter A ( not dimension elements as well). Regards,
Hi - I have created a routine in Connector Rule to fetch the Worker data from HCM and I was able to assign it to a variables and able to print it successfully. My question is below 1. How I can assign the variables to the List because I am trying to use this connector rule in Data Source and trying to bring the data to the OS stage Area ? is it possible, My function return type is task for the RESTAPI call. 2. Or I can create a Extender Rule and create a Table in the Backend and import into the table and create an another connector rule to bring it to the stage. Any suggestion would be appreciated. Thanks Krishna
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.