OneStream Platform Forums

Why is our UD8 Level1 formula called multiple times by cubeview- for over 25 mins? this member is the first column in our small report with other column being a month.We needed to display Level1 member to Level8 (our .base member) of our accounts dimension in a cubeview.It runs withing 1 min when there are only a few hundred rows of accounts to report.However, when we tried to change that report to include base members of our product dimension, it is taking over 25 mins to run –for  just for one entity.  The problem seems to be in our UD8 formula called level1.We logged the calls to UD8 member Level1. It seems to be looping through this level1 multiple times.We may expect less than 1,000 rows for one entity and for one account, using suppress zero.To limit the minutes it takes to run, we had to set “Max Unsuppressed Rows per page “ and Max Seconds to process” to 6 mins in our cubeview.

Is it possible to use conditional suppression in CubeViews? For example, I would like to suppress row/columns when a value is greater than zero.

You cannot change BiBlend configuration if a Workflow “Blend” step has already been executed Question Credit: Jack Lacava 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 Everyone, I hope all are well.   I am trying to use the GetICMemberFilter function in a business rule but I don't know how to get the VarybyCubeTypeId.   Does anyone would know how to obtain the VarybyCubeTypeId using a XFBR?   Thank you for all the help.

Hi All, I am trying to find the best way to load my budget day. I currently have 22 departments, 207 accounts and 100 facilities that I need to load too. Do either of you have any suggestions on what's the most effective way to get my data loaded in OneStream that will take the least amount of time? I greatly appreciate your input.   

Hi community, refering to the solved request in the link: Solved: Show 0.0 in Cube View Data Cell instead of blank cell - OneStream Community (onestreamsoftware.com) Is it also possible to get a drill down here? That doesn´t work with the described UD8 anymore. Thanks.

Hi Team i have created a Bi Viewer report by fetching the People Planning Plan Data tab using SQL Data Adaptor and getting this error while opening the report from Workflow. My assumption is this error is popping up because of large dataset in the people planning data tab, as this is opening with lesser amount of data records, is there any way to make it work or to increase the no of rows for a bi- Viewer report?

Hi All,For some reason, we are getting errors (#Error) when we use the XFMemberProperty function in Excel with Account for the following 3 Member Properties; Input View for Adjustments, No Data Zero View for Adjustments, and No Data Zero View for Non-Adjustments.  Every other property returns a value or a blank cell which is what we want.  Any idea why these properties cannot just return a blank cell as opposed to showing an error? Thx,Mike

Originally posted by Hubert Gao Hello, In CubeView, is there any setting to show Zero for No Data cell instead of showing empty cell? Thank you!

Hi all,In our use case, users are uploading data through files into OneStream. Is there a possibility to check if the file have 1000-seperators in the file and block the upload if this is the case? Reason is that within one workflow the 1000 seperators could differ between users and we want to avoid issues in this instance. Ideally we have a parser rule that checks the amount column.With kind regards,Tim Vierhout

Hi,I wonder what's the difference between IsConsolidated member property and Aggregation Weight which is relationship property? When one's usually set IsConsolidated to False? I can imagine that it make sense for non-additive values (like KPI's), but I'd rather use for that Aggregation Weight, so not sure what for is that differentiation. Any tips, example use-cases?

Data generated by dynamic CubeView calculations can be imported into other Cubes or Scenarios” Question Credit: Jack Lacava 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

I am using the below formulae to fetch members in a cube view. Account -> A#Root.CustomMemberList(BRName= abc,Param1=value1) The results from BR defaults the indentation to 0 instead of the indentation that is mentioned in the formatting tab.   Do you know how we can change the indent level to 3 after the members get returned from BR.     JackLacava 

Hello! Does anyone have experience reporting across two applications in the same environment? I've been in touch with OS support who's still working on it but wanted to pose this to the larger customer/consultant community to see if there were any options or solutions out there already being used. Thanks!

I have two questions: ud3 text2 has text which is the entity on where we are going to seed to..  1) I want a memberlist where Text2 is not blank or has no data. I am wondering if Text2 <> '' is the correct way to go? 2) What is the syntax of brapi or api.logmessage to see what is in the memberlist?   'Dim memberFilter_UD3 As String = "Cb#CONCUBE:U3#PCHEAD.Descendants.Where(Text2 DoesNotContain '')" Dim memberFilter_UD3 As String = "Cb#CONCUBE:U3#PCHEAD.Descendants.Where(Text2 <> '')"Dim UD3List As List(Of Memberinfo) = api.Members.GetMembersUsingFilter(api.Pov.UD3Dim.DimPk,memberFilter_UD3)   'api.logmessage("UD3List", String.Join(vbnewline, memberFilter_UD3.Select(Function(x) x.GetType.FullName))) BRAPI.ErrorLog.LogMessage(si,"1_Target_ " & UD3List)   For each UD3 as Memberinfo in UD3List etc. etc. BRAPI.ErrorLog.LogMessage(si,"Test " & UD3.NameAndDescription)' &" " & UD3.Properties.GetUDProperties.Text2.GetValue())

1.How can we use the below member filter in red colour inside XFCELL. How can we use it? XFCell(Cb#GolfStream:E#[NA Clubs]:C#USD:S#Actual:T#2022M1:V#YTD:A#69000:F#None:O#Top:I#Top:U1#Top.base.where(Text2 contains '|WFYear|'):U2#Top:U3#Top:U4#Top:U5#None:U6#None:U7#None:U8#None) 2. How can we use GetDataCell(A#A100+A#200) inside XFCELL to calculate some expression.   Thank you!!!

Hello, We need to clear data on the specific intersections of Account, Entity, UD2, UD3, and UD5 members (all members from the remaining dimensions). The data is copied from the Actual to the Forecast scenario. So, I tried to use clearcalculateddata API in the member formula but it is clearing data on that account for all members of UD dimensions. Can you please help with the simplest way to clear the data on a specific intersection?   Ex. We need to clear data for the below intersection. The below line is clearing the data for A#7041 irrespective of other defined UD members. api.Data.ClearCalculatedData(True,True,True,True,"A#7041:O#Import:F#Base:U2#13056:U3#327:U5#01973")  

Hello all .    i am trying to display in a cubeview a list of accounts with specific constraints related to FLow , for example i want to display Only accounts with having Flow = EQU . any idea which function to use ? i tried the [Where] clause it didnt work out. would the [Option] be helpful ? which arguments should i pass 

Hi,   I have an existing extensibility rule which copy some data from a source scenario/period to a target scenario/period.   This is the "core" of the code Dim listDriversDataCellExFilterdForDriversTarget As New List(Of DatacellEx) For Each itemDataCellEx As DataCellEx In listDriversDataCellExFilterdForDrivers   itemDataCellEx.DataCell.DataCellPk.TimeId = TimeTargetId   itemDataCellEx.DataCell.DataCellPk.ScenarioId = ScenarioTargetId   listDriversDataCellExFilterdForDriversTarget.Add(itemDataCellEx)Next itemDataCellEx   Now, I was trying to update this to only copy data where UD3=None, but I am not sure on how to do that. I can see datacells have a function called GetUD3Name, but the function requires a FinanceRulesApi parameter.   Would using the GetUD3Name function work for my scope and what would be an example of valid FinanceRulesApi parameter?   Thank you

Hi All, Is it possible to pass a member list, in my case flow members, as a list parameter in a cube view combo box? I know a delimited list would normally be used for this purpose however I need the list to be dynamic based on the dimension library and will be storing the selection to the Annotation view member. For context I am trying to allow the user to select a default mapping for an allocation rule which will require the user to select the lower-level default allocation member for a specific flow. Many thanks in advance. Nick

In a cube view, how can I use a manual input value in the formula in another column? Col1 Col2 Col3 EndBal Input Value EndBal - InputValue Many thanks in advance. Winni

Hi All, We have a client who wants to exclude a subsidiary from their reporting rollup starting mid year in May 2022. Unfortunately the consolidation view is set to YTD so it appears that when we switch the consolidation percentage to zero then it reverses all of the YTD data for the whole year opposed to just excluding the data beginning in May.Is there a simple solution to resolve this? Or is a business rule required when divesting mid year? It seems like a requirement that should be pretty common and have a pretty straightforward solution like in Hyperion but we haven't had any luck so far.   Any thoughts or guidance is greatly appreciated.   Best, Joe  

Hi, are there any capabilities to use visualizations like Matplotlib? If not, any plans for this?thanks,Greg

Hello! How do you manage recurring journal entries? We go through a manual process where we pull the JE data out of OS, manipulate the information into a text file and load the text file to create whatever JEs are needed the next period but it's not an easy or straightforward process. Please let me know if you have a better way! Thanks, Nicole

This is probably quite a basic question. I have a vendor file with multiple currencies going to a single account. Can anyone advise the best way to do this as there is no option in the Data Source or Transformation rule to vary the currency. Do I use a separate member in the Flow dimension and set the "Flow Processing Type" to "Is Alternate Input Currency For All Accounts"? Appreciate the help - thanks