OneStream Platform Forums

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.

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 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!

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 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 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

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

Hi I am looking for a way to restructure a part of our UD1 hierarchy but there over 1,600 lines to move so I don't really want to copy and move them individually to their new locations. Is there a way to upload the new structure and overwrite the old one, or a faster way of copy/move the base levels. Thanks Simon

Hello,I am creating a cube view to be used in a Dashboard on an Workflow in order for a client to enter Quarterly Commentary.I am having two issues.1. When I set the time on the Explanation Workflow(Annotation) column to a Quarter, I receive green cells and cannot enter a comment. When I switch it to the quarter month, I have white cells and can enter a comment. I just want to confirm that this is normal functionality and that we cannot write comments to the quarter.2. The second issue is that I would like to write the comment to the BeforeAdj Origin member. I am able to do this when I have the Explanation (Annotation) column looking to one of my Forecast scenarios. When I switch the column to look at the Actual scenario (which is the scenario I want to be looking at) the cells turn green. In this case, they only turn white if I switch the Origin member to Import. I must have a setting somewhere that needs to be adjusted but I am having trouble locating it. Any insights would be greatl

I want to apply background color for each row of a grid view based on column value 

Hi all, We are trying to import an excel report into powerpoint. This works fine. However, there is an issue with the borders that are appearing in the picture, as the picture does not seem to fill out the picture that is inside the powerpoint. Is there anything we can do to remove these borders in the picture? Please see an example: Named range in Excel: How it appears in the powerpoint picture (I highlighted the red) Ideally we would not have the white spaces in the picture. Any idea on which options could be used to stear this? With kind regards, Tim

Hello, I'm trying to find a way to call an Extensibility Rule in Data Management sequence, is that possible? Thank you  

Hi  We are looking at inputting certain Balance sheet entries at Parent entities. Is there a way to get OneStream's intercompany matching tool to work Parent to parent (rather than either base to base or base to parent)  Ideally I don't want to substitute a 'proxy' base member when entering at the parent level  Thanks in advance 

TeamAm new to the Onestream. Can someone please guide me how to extract and load metadata in Onestream using flat files/Excel files.RegardsVarun

I want to creat a report as below. The issue is with the Comments under column2 , I want to insert something lika a text box where i can write in a paragraph for summary. Thanks in advance !  

Hi all We have a process where we update dimensions and their children on a regular basis. This means we need to delete the relationships between parents and children and then reload the new updated dimensions...etc.  This takes a very long time, because we have a lot of dimensions.  Has anyone out here used a script to make this process faster, we we to not have to reload everthing, but only update the changes made to the different hierarchies? Thank you for any suggestions Nouria