Discuss the features and functionality of OneStream.
Recently active
We are looking for ways to reduce the data unit size in one of our cubes in order to increase reporting performance without having to do a redesign. We currently have +20k UD1's and +10k accounts in this cube and 16 years of historical data. Would updating the "In use" tag to false for inactive accounts and UD1's reduce the data unit size and help improve data pulls and reporting performance for current years? We aren't able to completely remove these accounts/UD1's because we are going back 16 years for historical purposes.
Hi All, I'm trying to display prior 6 months in my cube view. For e.g. if my WF time is 2021, I want the CV to show last six months in 2020 (Jun - Dec) and so on. I tried using half year member filter, but it didn't work as it should. Any suggestions will be appreciated. Thank you, Mustafa
I've been creating cube views and have sometimes found that I may forget to update a row that is part of a reporting segment. This results in the sum of the rows not equaling the total row for the reporting segment. Does anyone have any suggestions on how I can create a row in the cube view that validates that the rows of a reporting segment equal the total row? I would want this row to be invisible and to have a condition that it would only display if there was a variance. I'd be looking for something like this: Row 1: $100 Row 2: $100 Row 3: Total = 200 Variance = 0
Account dimension member "In Use" property (Vary by Scenario Type and Time) set to Scenario Type = "Control" and Time to "2022M2", Stored value "False" However when I try to grab the InUse value via a BR it always returns "True" Dim varyByScenarioTypeId As Integer = ScenarioDimHelper.GetIdFromName(si, "ActCon") Dim varyByTimeId As Integer = TimeDimHelper.GetIdFromName("2022M2") Dim boolInUse As Boolean = BRApi.Finance.Account.InUse(si, memberId, varyByScenarioTypeId, varyByTimeId) But works fine if I set the Scenario Type = "Actual" or "Budget". Doesn't work if Scenario Type = "Control" Any ideas?
Is it possible to use data from attributes and attribute values in a cube view row or column filter?
Is there a way to use functions as parameters in an XFGetCell formula? I want to retrieve values for the previous month to compare to the actual month. It would be nice to use something like T#MonthPrior1([actual month]) instead of using some excel functionality to calculate 2022M1 and use that.
Does anyone has a NotePad++ language definition file for OneStream rules? Thanks in advance.
How do I set up drill down for relational sources in BI Viewer?
Hello,I am wondering if you can provide any issues or conflicts that may arise by changing the "Input View For Adjustments" from "Periodic" to "YTD" on a Scenario? How does this impact historical data? What happens to Periodic journals booked in a previous month, do they automatically convert to YTD, or do they stay Periodic? I'm looking for any best practices on making this change. Thanks!Regards,Ronnie Karpinski
Good morning All, How do I make build this dynamic calculation for my Monthly Rate KPI CV? It takes the new month and divides it by the previous trailing month (e.g. Jan-21/Dec-20, Feb-21/Jan-21....) Here is the code I wrote: Dim RentalRevenue As Decimal = api.Data.GetDataCell("A#NetIncome:U4#[Rental Revenue]").CellAmount Dim RentalRevenueTrailing1Mo As Decimal = api.Data.GetDataCell("A#NetIncome:U4#[Rental Revenue].Prior1").CellAmount Return RentalRevenue/RentalRevenueTrailing1Mo Any ideas will be appreciated. Thank you. Best, Mustafa A
Hello Everyone, Looking for a quick help Please. Here I am trying to write a Dynamic Calculation code which will follow the exact logic of PVA translation however will use rates from previous year. So kind of a Constant currency solution. However when I am in Time period 2, I am unable to pull data from different periods, This calculation works If I make my T#Hardcoded e.g. 2020M1/2020M2. Current outcome is all zeros 😞 Please help with any solution anyone has or can point me to right direction - since unable to understand what is missing. Thanks Satish
Hi all, I have a dynamic calc that displays zeros instead of null when the source cell is null. In the image below, MTD_CF is dynamic and it shall display None data under certain conditions. When None is null, MTD_CF is showing 0. Is there a way to avoid this so the dynamic calc shows nulls as well? I've tried with RemoveZeros, like this: Return api.Data.GetDataCell("RemoveZeros(V#" & view & ":U1#None)").CellAmount The code returns the result, but does not remove the zeros. Any ideas? Thanks in advance. GSF
Hello: I've integrated a set of transaction details from a GL into a bi-blend cube within OneStream. I'd like to aggregate along the UD1 dimension so we can see the data at the parent level for each transaction. The dimension consists of a set of parents with a few base members rolling up to each one, it's a pretty simple dimension. I'd like to be able to see the parents in a column with the base members in the other column. Note: that the base member is being passed directly form the data source, i.e. It's a pass thru mapping. An example of a parent child relationship is below: Parent: Clubs Base:1000 Base:2000 In the ud1 value column, I'd like to only see "clubs" while in another column I would like to see "1000" and "2000" values in another. I know that in the ud1 when I aggregate this dimension, I'll see the base member and the parent members in the same column for UD1 even if it's the blend unit dim. I'm passing the base values into an attribute. Is the only way to exclude non-bas
Hi, I am working on a huge report (via Cubeview) with over 3 million rows with data, and i am unable to export to Excel nor PDF. Error message siad that the maximum row allowed is 1 million rows. Does anybody have an idea to increase the number of rows please? Thank you very much Khanh
Hi All, How do I make my Cube View display prior2 year (2020), but only the last six months. Any suggestions will be appreciated. Thank you!
How do I make the entity column to align left? Excel has it's own formatting, but it changes back every time I refresh my workbook. I'm using an excel-add-in. Wondering if there is any alignment setting, that could be changed in OneStream. Any ideas? Thank you!
Hi, We have built a cubeview in OneStream. Now we are having a requirement to get input/comment from user and store it back in OneStream. Is there any KB article or something to refer? Please suggest how to achieve this. Thanks & Regards, Madesh K
Hi, I have two question in one:1. I'm trying to add a variance column in a Pivot in BI Viewer for amounts that are split by 2 scenario's, actuals and budget. What is the most practical way to do this? I thought I would add a variance in my cube view used in the cube view md adapter but this is not picked up by BI Viewer.2. Can I sort this variance column by the amount value?
Dear Community, We're trying to change our hierarchy structure for the new year. That means creating new rollups (D22_xyz), and inserting members within those structure. It's the exact replica, but we're just copying the hierarchy from D21 and changing it to D22. However, I'm curious if their a BR to compare between the old hierarchy v. the new one. It would help to compare and know if we have missed anything. Any ideas or suggestions will be appreciated. Thanks!
There is a new column-store storage engine for reporting out of Onestream called "Analytic Blend". I have been examining the related documentation, and hoping to find an API that would allow this engine to return data for ad-hoc queries. We have custom processes that require CPM data from onestream. These processes would greatly benefit from the ability to retrieve query results from Analytic Blend. Is there any technical documentation that would help software developers to interact with that column-store data? I have the "BI Blend Design and Reference Guide" for XF 6.3.0, but no other resources beyond that. That document primarily describes how to prepare the Blend output database. But it doesn't describe how client applications might use the results. Can I assume this is because the because the database is standard Microsoft technology, (ie. that it only requires standard SQL knowledge/skills)? Can I assume that querying data from this Blend database would be fully suppo
I have a loaded set of base data in our People Register, but this needs to be amended to capture New Hires, Leavers, Promotions etc. I had thought that this would be possible by using the excel file template that was used for loading the base data. I've tried doing this for a leaver, where I have manually changed the base entry to show the "to period" as the month that the person leaves and then created an entry in my blank template to show the remainder of the period with no salary (this enables me to build a bridge of starters, leavers etc.) When I load the file the new entry overwrites the row already in the People Register. What I need it to do is to add a row. The load method in the file shows "Merge" and I wonder what I should change this to in order to get the import of the adjustment file to add the adjustment rows rather than overwrite them.
Hi all Onestream stores a lot of information using an integer ID instead of a name. And most of the time we also deliver a simple way, to get objects (or names of objects) using an api or brapi call. Somehow getting the name of a dimension from its ID is an exception. Is there a simple way to do it? Cheers
Hi, in the getting started with BI viewer I see they make use of a date field, which enables you to drill down to quarters/months etc. How do you create such a field (I guess I have to something with the time dimension which contains my years and months). I'm struggling with finding an expression that works...
Hi everyone, Quick question re Dashboards. When you use a parameter in a Cube View there is an option to display the Member Filter using a "Member Dialog" Parameter Type. This shows you the results in a hierarchy that can be expanded or collapsed. When building an interactive dashboard I need to present the user with a large number of members to select from. The Combo Box option isn't particularly easy to browse through as it simply lists the members (albeit this can be indented with a BR to imply the hierarchichal relationships). Is there a way of replicating the Member Dialog Parameter Type in a Dashboard component? Regards,Lee
Hello Experts, I am trying to export Cell Details to a CSV using a business rule function as shown below: If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("Export_CellDetails_CSV") Then Dim wfUnitInfo As WorkflowUnitInfo = api.Workflow.GetWorkflowUnitInfo() Dim SRCTimeName As String = wfUnitInfo.TimeName Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si) Dim timeStamp As DateTime = DateTime.Now '.UtcNow Dim AESTNow = System.TimeZoneInfo.ConvertTime(timeStamp, TimeZoneInfo.FindSystemTimeZoneById("AUS Eastern Standard Time")) Dim timeString As String = AESTNow.ToString("yyyy_MM_dd_HHmm") Dim xfolderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp(si, True, configSettings.fileShareRootFolder, si.AppToken.AppName) Dim csvFilePath As String = xfolderPath & "\" & "Cell_Details.csv" If File.Exists(csvFilePath) Then File.Delete(csvFilePath) End If
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.