OneStream Platform Forums

Hello - Is there a way to have a Ud8 dynamic calc sum up certain entities based on a text field? I am trying to tag a text field on certain entities and have a dynamic calc aggregate the entities based on what that text is. Example:  entity 1 - text 1 "abc" entity 2 - text 1 "abc" entity 3 - text 1 "def" I want the value of entity 1 + entity 2   Thank you!  

Hi,Is it Possible to extract any metadata (For Example Account) from one environment and upload the same into another environment? Thanks,Madesh K

Hi,Does anybody know what is the "ColumnDisplayType" parameter under the Column Format, part of the SQL Table Editor ?I am keen to know how to use it, as I can't find any information on this.Screenshot of the mentioned field below : Regards, 

Hello,I would like to know if it is possible to format only one word or part of a word in a dashboard label :- How can we make only one word in bold in a label, and not just the complete sentence ?- Could we use conditional formating in order to format only a specific word (for instance, a user login) ? Many thanks,

Wondering if anyone has encountered the issue? It's a simple PDF report book with straight forward column set, but there are slight misalignments between numbers. Ideally, looking for right side justification. Thank you

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