OneStream Platform Forums

Hi Team, Can Tableau Connects to One Stream ( on Azure Cloud ) ? Best Regards and Thanks Darpan Bhansali

Hi all! Having a copule of questions about consolidation method input and storage:  - Could you please advise on any way to input consolidation method, except changing it directly in Application-> Entity Dimension -> Entity member property? - Why the consolidation method property, when retrieved through the Cube View, is seen only at C#Share level? The consolidation method account is a DynamicCalc member one, and there is no any restriction on the level of consolidation it should be calculated on fly: Select Case    api.Entity.OwnershipType()Case ownershiptype.FullConsolidation    Return 1Case ownershiptype.Holding    Return 2Case ownershiptype.Equity    Return 3Case ownershiptype.Custom1    Return 4Case ownershiptype.Custom2    Return 5Case Else    Return 0    End Select       

Is it possible to dynamically set the Bound Parameter of a Supplied Parameter? I have tried to use and xfbr rule to do this but the supplied parameter but this does not work.

Hello - I am am trying to produce the parent for an entity under Gathering_Processing segment node. However, because this entity is shared, the parent entity returned by the VB below is not the one I need. The parent returned is RRC_STXGasUtility which is flat hierarchy and includes the entity in question. Can you please advise?   Dim ggpelimftr As String = "E#Gathering_Processing.Descendants"Dim ggpList As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(api.pov.EntityDim.DimPk, ggpelimftr, Nothing) For Each ggpe As MemberInfo In ggpListDim parentIdstring As String = String.EmptyDim ParentList As List (Of Member) = api.Members.GetParents(api.Pov.Entitydim.DimPk,ggpe.Member.MemberId,False)Dim ParentMember As String = ParentList.First.ToStringDim ParentArray() As String = Split(ParentMember)parentIdstring = ParentArray(2).Replace(",", "")parentId = Convert.toInt32(parentIdstring) Next

Hello,    I am trying to create a hierarchy for cubeview reporting that is based on a series of metrics that are extracted from the Journal Line Item application database table.  The metric is based on one half of the JE, but it is only applicable if a specific account is used as the other half of the JE.    For example, if I have two journal entries, one using accounts A & B and one using A & C, I need the data from account A, but only for the first entry because the other half of the entry was to account B.  Because the second entry used account C I don't want that value captured in the metric.   I have been able to compile the SQL extract for this, but was wondering if there was a function in the business rules that would allow me to populate a dimension member, similar to a Finance member rule or api.data.calculate.getdatacell, that could be used in a loop, based on the row values extracted, each row being a combination of dimension base m

Hi !We are trying to figure out ways to automatically upload data using either Business Rules / Data Management / Task Scheduling. Is there a way to automatically upload data from flat files or databases using these three components ?Data Management seems to provide only Export functionalities. Regards,

I can have less detail in a base cube. Question Credit: Peter Fugere 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

We have successfully set up and use workflow channels (tagged to accounts and workflow profile steps) in our divisional (Base Input) workflow profiles in our application build.  The steps and data lock based on their workflow channels appropriately.  However, we are having trouble getting Workflow Channels to work properly when it comes to the workflow profile (Parent Input) used by central finance.  The central finance team needs the ability to book historical USD overrides on select equity accounts on behalf of the divisions for all non-USD base entities in the OneStream application.  We are not using and have not configured the use of any UD dimension in our Workflow channels to this point.As of right now, we have assigned the central finance team their own Input Form profile step so they can submit these Overrides to the configured accounts (using Flow dimension).  We have given that profile a unique Workflow Channel and assigned the accounts specified in t

I have a client that needs to demonstrate to their auditors that no one except the IT group has the ability to create and delete users. When I use the Security Audit Report it shows the security roles for the application related functions but it doesn't list any of the "system" security roles such as "ManageSystemSecurityUsers". Is there another report that would provide this information for the auditors?

Hi all,I have a matrix load, on which account is matrix. One column with a specific account needs to go to 2 different accounts. For this I just reference the same column twice. This works fine.The issue is, the first instance the UD5 is coming from column 5, the second instance UD5 should come from column 16. How could I achieve this?Thanks!Tim

Does anyone know if OneStream is capable of exporting into AWS S3 bucket?Thanks.

Hi.  Is it possible to set Certification Profiles so they only show on a Quarterly basis?  The questions can be set to quarterly but the Profiles still exist in the off-quarter months and require a Certification sign off even though there is nothing to certify.  I have a client who needs an employee to certify a question on a quarterly basis and this employee does not have any other certification or workflow responsibilities.  

I am looking for tips on batch automation business rules. Currently when our scheduled trial balances are loaded the whole upload will fail if one transformation mapping error is present. As you can imagine this can slow the close process down significantly. Does anyone have any suggestions on how to allow the batch to load the validated accounts and only error out the transformation errors? 

Is there any function or SQL to identify the newly added member in OS ? Ex - If I added an new account and I want to check whether the data was loaded to that new account ?   Thanks  

I may have a requirement to filter a member list based on the project manager. Whenever data is loaded the PM assignment may change. I am thinking of potential ways to capture the current PM assignment, but don’t know if they are possible. Leverage a text field to input the project manager name.  Then use a variable like UserName or  UserText to create a member list. Is it possible to create a member list/parameter using |UserName| or UserText variables      U2#TotalProject.Base.Where(Text1 Contains |UserName|) Given the Text1 value on the project can change every time data is loaded, is there a way through a data load to update a text field? Load the PM into a data cell using the View member “Assumption” and None for most other dimensions.  Then trying to create a member list with logic..something like where Username=Assumption value of current period. This removes the need to update Text1.  If it could work, I think the evaluation time

Hi, I have an account member A#salary which is being computed using BR1 in CV1 and I need to use the computed value in another CV2 using BR2 to compute account member A#61000101. Tried as below: api.Data.calculate("A#61000101:U2#Staff:U4#None:U1#7330:O#BeforeAdj = A#Salary:U2#Staff:U4#None:U1#7330:O#Top") Remaining dimensions is all same between two. Kindly advise.  

An account can exist in multiple account dimensions. Question Credit: Peter Fugere 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 have a dynamically calculated member formula. It is returning the wrong value for each Quarter, it should be the sum of the M1+M2+M2 ($1,614,441.60) and not be recalculated ($1,649,190.40). Is there a member property or formula examples that can help me resolve this issue. Thanks. Sample calc Drill down formula I tried setting a different formula on the quarter, but I get the error message “The Dynamic Calc Member Formula is recursively calling itself:.     Thanks,    

Hello all, Asking for a client: they've been live for several years and they would like to perform a clean up of their security user groups. They need to obtain a list of the groups that exist in OS that are no longer used/referenced anywhere in metadata, workflows... Pre-built Security reports do not offer this. I'm guessing we need to put together a query to the DB but I don't know all the tables that reference a user group ID. Can someone help please?

Hello All, For the Transformation Rules, 1-1, Composite, Range, List, and mask rules,  what are order of operations in rule types?  Do the rules that run later overwrite previous results or does it ignore later matches after a match is made?  Where can I find documentation on this?   Thanks!

Hi all, do you know if there is a way to put a conditional formatting based on element properties? Like haschildren, text1 = to a certain value,....? This is an example of what I would like to put in the conditional formatting box. But I don't know if this is doable and if yes, how? Thanks in advance for the help Marcello    

Hi all! I need your help with a finance BR. I have a Budget scenario with different versions children members (ex: Budget, Budget_v1, Budget_V2, etc.) Right now my script goes like this:  Dim isBudget As Boolean = api.Pov.Scenario.Name.XFContainsIgnoreCase("Budget") If isBudget  Then I am trying to find a script where I don't use "Contains", as if new scenarios are created in the future, the word "Budget" will always need to be apart of the member name, which is not ideal. Any suggestions how I can call the children members of Budget? Thanks

Hi All, I am new with OneStream and I am taking the ReadyTech Lab exercise-- Implementing_OS_Lab_3_Starting_with_Workflow_Exercise.   The requirement is to select the BudWorking-Budget Working Scenario as shown below.       However, in my application, there is no BudWorking-Budget Working Scenario. I have followed all the steps in the instructions. What might be the problem and how could I fix it?   Thanks a lot in advance!   Kind regards, Mulin

Hi everyone, Is it possible to call the Rebuild function in VBA ? The goal is to update a Quick View by typing in a new period to avoid going into Member Filter and change the period manually (workbook contains multiple QV (ext. I know that Time Functions can be used so users can update through Cube View but the client insists on building a macro.

Hi All!   I want to implement a Data Management that read and modifies data from the cube. The only problem is that the rule type Extensibility Rule does't have the option api.Data to be able to acces to the data from the cube. I'm tring to create a Finance rule that is called by an Extensibility Rule. Here is the example: But I get the error: 1) Error at line 33: Value of type 'ExtenderArgs' cannot be converted to 'FinanceRulesArgs'. ¿Can I call a finance rule directly from a dashboard or from a data management? ¿Is posible to call a Finance rule from a  Extensibility Rule like I'm tring to do? ¿There are some Imports that I can use to be able to use api.Data in a Extensibility Rule?   Thank you! And hope that this helps some people!