OneStream Platform Forums

Hi, we have a custom member filter in a cube view (i.e. E#Root.CustomMemberList(BRName=X, MemberListName=Y)), and it seems to disable row suppression.In other words, the cube view brings back all filtered members in rows, regardless if there is data, even when the row suppression settings are set.Has anyone else experienced this and can confirm/deny? And if so, is there a way around it? We based architecture on CustomMemberList following the same rules as any other member filter.Jon  

  I have the following cube view in Oneplace and I would like to know if it is possible to create subgroups below the Main group.  For example I would like to create a subgroup of Income Statement report, Revenue reports etc.  They are currently in separate groups in the cube view set up but that does not seem to translate to Oneplace.  We are currently on 7.3.3 and moving to 8.5 in the next month.    

Hello, I've successfully set up an automatic upload using the Harvest Folder. However, I want to use the Skipline functionality within the file to reduce the import size. This works perfectly when I manually import the file into the specific Import Step. But when using the automatic upload via the Harvest Folder, the Skipline functionality doesn't seem to be applied. Does anyone have an idea for a possible workaround?

Hi guys,I need to create a pie chart on a report component (under dashboard), but this pie chart has the particularity that, instead of showing up the labels of the data presented in the chart itself, i need to show the Total Amount inside the pie. The achieve this, i wanted to add an XF label taking the total from the cube, but  when i set the label over the chart then i have the error "The control is overlapped". Do you have any workaround / solution to allow the controls, in particular the labels, overriding a chart?note: ok under preview that works, but at the end i need to use this report component in a docx file (with narrative reporting) - that's blocking me to use the report.Thanks a lot in advance,Regards,Florence

When we created our application years ago for a particular source our account mapping only needed the Source Account to map.  Now I have a need to do the account mapping based on a Location Source field that denotes a location for just two records exceptions.  Can I make a Composite Rule mapping that somehow includes the location from the Source file to create a composite rule for this exception or is the only solution to now include the source location field on my data source, and modify all the current mappings to have a wildcard for that field except my exceptions that need to be mapped to a different account.

Hi I linked several cube views into Excel with the settings below (Version 8.4.0). I then created some basic formulae within the cube views. E.g. = C25. The Excel formula is retained by the first cube view but in the other cube views it is moving up 4 rows on each refresh. The Cube View Connection options are the same in each one. I have tried selecting/deselecting the insert/delete rows & columns and including/excluding the header. The cube views all have some rows with a specific account and at least 1 row that uses “.Base”. Has anyone come across this before? Thanks. Robert

Hello,I need to create a pie chart in a report component (under dashboard). So i created a very simple cube view with 2 elements of the UD1 dimension, and 1 column showing up an account. With this cube view, I created a data adaptor, with Command Type = Cube View and Data Table Per Cube View Row = False; when I open the data adaptor then I can see the correct data, with 2 rows and 2 amounts then.Now, when I create a report component and add a pie chart on it, the pie chart appears properly and as expected (2 pieces in the pie, for each UD1) but it appears twice ! And twice the exact same pie! Any idea from where/which setting this is coming from please? I am struggling in finding it.. Thanks in advance,Florence

I need to be able to visualize a cube view in english and in spanish.The description of the account member is set in spanish, and if I put something in the 'English' line, because the user security only has the English option in culture, the cube view would come out in english. So i need to be able to add another option for culture in the user security. ¿How can I accomplish this?Thanks!  

Add a lock-in challenge to the application close "X" button in top right of window. This would prevent a nuisance situation where I've mistakenly closed the application when trying to open the POV pane. 

Hi,I have a classique cubeview that uses !prm_entity! as Entity POV.When using classic Dashboards, everything works as expected.When converting the dashboard from "Embedded" to "Embedded Dynamic" and using a simple Factory service to add the template cubeview stored component, nothing more: then the !prm_entity! POV of the cubeviews seems not interpreted at run time, no prompt showup and this cubeview displays a blank page. When checking cube POV we can see parameter is handled like a string in the POV.Any idea what basic setting i am missing to do in the Dynamic Dashboard way to let OS prompt for the prm_entity parameter value?Thanks in advance,

I have informational account created to store some Include/Exclude value by Entity. Now, I dont want this account to be translated and consolidated so, I have tagged AccountType to "Non Financial" while Aggregation to False. However when I turn on false its become invalid while True makes it Valid for input. Any idea what causing the issue? Based on the OS doc any informational account can be set to False.    

Hi, I want the hierarchy illustrated below. Entity B owns 90% of entity C, and in the consolidation of entity B we calculate minority interests of 10%. At this step, I have no doubts. However, entity A owns entity B 100% and also owns entity C 100% (90% direct + 10% indirect). So, in the consolidation of entity A, we need to eliminate the calculation of minority interests done previously in the consolidation of entity B.I don't know how to set the properties to do this. Can someone help me?  

Hi, I was wondering if we can write a dynamic calc in the scenario dimension? I see the field for writing the formula but somehow it is not returning anything. How can I enable the type to dynamic calc so that it works as how we use it in account or UDs?  

We wish to disable Native Authentication once we go live on V8.  If Native authentication is enabled, all users must enter their username and then the authentication occurs.  In V7, that wasn't required.  In V7,  we utilize several native accounts for testing - i.e. TestUser1, TestUser2 - that the admins can leverage when working with security.  They use their SSO account to launch one window of OS and login natively with the test user on another instance of OS, enabling them to make a change in their admin window, refresh, and test the change in their other instance.With disabling Native Authentication, our IT department suggested we create Azure test accounts that can authenticate  like our normal user account through the shift/right click and "run as other user" function to login as that t-account.  However, this doesn't seem to work - nothing happens after clicking on the shortcut and entering the t-account credentials.  Is it safe

Hi All, Finished the installation of the databases and webserver on the machine, following the installation guide it reached a point where it told me to test the application and login for the first time using preset credentials.I tried inserting the standard credentials but I would get the error message "Unable to log on user 'Administrator'.  The password was reset and needs to be changed." and it does not allow me to change the password (see screenshot below).This is a fresh installation and the standard credentials were never used before, did some error occur during the installation or is there something I have to do to make it work correctly?Any help would be greatly appreciated,Alberto

Originally posted by Mike TurbesHow can I copy a tab in Excel that includes 1 or more Quick views to a new tab or to another file? Thanks, Mike

Hi, Is there a way to open a dashboard within the same page of a dashboard by clicking a button in OneStream? Thanks

Hi Everyone. I would like to know how I can remove zero values in my GetDataBufferUsingFormula. Dim DatabufferCalc As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(E#" & strParentEntity & ".Base,E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base:S#[" & strScenario & "]:T#" & strPeriod & ":O#Top:I#None:U1#ALL_DEPARTMENTS:U2#ALL_PRODUCTS:U3#CORP_RPT:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None,A#411000)") And from the result, I would like to obtain the entity, and from that entity, know its Text1, Text2, and Text3. However, for now, I see that I can only obtain the account and the rest of the properties such as the UD Dim DatabufferCalc As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(E#" & strParentEntity & ".Base,E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base:S#[" & strScenario & "]:T#" & strPeriod & ":O#Top:I#None:U1#ALL_DEPART

Hi Team, Generally, In Scenario settings will updated the "Workflow Start Time & Workflow End Time". so here we want to get these workflow time rang in Cube View. (Eg: Work Flow Start Time: 2025M6 & Work Flow End Time: 2026M5). Based on scenario selection in  the report, we should get the (12 periods) time range in report.  Please help us to get the solution. Thank you, Shiva Prasad

Pls share how to run1. a traditional BR via a member formula2. an assembly BR via a member formulaThank you - OS SME.

Is it possible to get this setting in a business rule?Thanks,Scott

Hi, wondering if anyone has created something like an "Administrator-lite" role that gives the user an ability to do 90% of actions in the tool, but stay away from things like fx, mapping changes, and data loads.  I really just want these users to create cube views and reports only without giving them keys to everything else. Would this be solved by adding a new group, or any other recommendations on how to solve?  Thank you!  

Two part question. Comparing Actuals as other Rates to remove currency flux We want to take our Actuals and view at PYE, PYP & budget FX rates to take out flux in currency.  Is there a feature (outside of creating BR's or Alt Rate types) to do this. We currently have built 3 scenario for the above rates and it works as expected for base level members.  Where we run into issues is with converting to Reporting currency at parent members.  Ex is converting our EMEA entity (currency - EUR) to USD.  The BR seems to store the USD value at the base entity but is converting from EUR to USD at parent level using OS logic (ie current defined rate for Actual scenario).  It is not consolidating up the USD value but converting from EUR at parent member. This BR was created almost 6 years ago when we implemented so hoping there is something out-of-the-box now that will do this. I am exploring creating 3 new Rate Types: PY Budget, PYE Actual & PYP Actual.  I wo

Hi, I notice that with dashboards, when allowed to prompt the user for values for their parameters, save the  user's last used value in said dashboard and populate that as the default value when prompted. By comparison, cube views don't store that information, and populate whatever is in the default value for the parameter when prompted. Is it possible to change what behaviour is used when parameters are requested from the user from a dashboard, and how would I do so? Thanks! Alex

Hello! I need to split an entity into three separate entities using transformation rules and percentages. For example, I need to split E#50 into E#50B - 33%, E#50D - 33%, and E#50L - 33%. I've read that derivative transformation rules can be used for this purpose, but I'm unsure how to implement them. Additionally, I need to divide the amount of E#50B into two UD1s U1#2345 -50% and U1#2346 - 50%. Here's what I've attempted so far: What would be the proper way to do it? Ideally, we would like to store the percentages in UD4, so users can update them in a form. Is that possible? Thanks,