Discuss the features and functionality of OneStream.
Recently active
Hi, My client has asked me to build a report with all subsidiaries and associated companies with respective Percent Ownership. I am aware that I can retrieve this through XFGetRelationshipProperty in Excel add-in but I wonder if there is any way to retrieve it in a cube view?
Originally posted by Jacqueline McBrideI tried running a CubeView I just created and received the following error message: "Error processing shared Cube Views. The maximum number of Cube View references has been exceeded." The application I am working in shares many row sets and column sets for various CubeViews. Does this error message means there is a limitation to the amount of times you can share rows/column sets? Thanks in advance! -Jackie
Hi , I was wondering if anyone who has implemented OneStream has come up against issues from their IT Security people with OneStream decision not to empoly a Web Applcation Firewall (WAF) as standard. This seems to be a common requirement of most IT Security governance approvals so I'd be interested in seeing if anyone has had this issue and how they resolved/accomodated it. many thanks Steve
Hi, I noticed that when exporting a workflow/cubeview to excel the default save location of that file is C:\Users\xxxx\AppData\Local\Temp\OneStream. The local IT group policy is to empty that folder upon rebooting the computer. This path is not setup in my own/local excel options. Is there a way to change this folder location to for example 'downloads'?
Originally posted by Priya GnanabhaskarWe have created a department level report which shows all expenses pertaining to a department in our actuals cube. This report consolidates the balances across all our legal entities for each department [e.g. IT]. The expectation is to create a drill through report that shows all the data loaded from the GL across all entities. In the current drill through the user has to drill through each entity to see the transactions loaded from GL. Is there any way to achieve this drill through?
Originally posted by Cheryl Nasta Has anyone successfully created an external data connection to a database on an AS400?
Hi, Can anybody help with this error? what we need to check for this in business rule.
Is it possible to change the Fiscal Year Month Type in the time profile after an application has had data loaded to it? For example from Fixed Weeks 4-4-5 to Calendar Month?
Currently when we open excel the context pane automatically opens. Is there a way to disable so that it does not appear automatically?
Hi,I have persistent derived figures in some calculated accounts that I cannot delete.My account is set with ZeroViewFoNonAdj = YTD, but for some reason the derived figures still appear in Grey in my Cube View:Is there an soft way to clear or reset this (except a Clear/ reset scenario) ?Thank you.Aurélien
Hi everyone, I have been looking in the marketplace to see if there is any tutorial about 'Best practice' to set up Securities in OneStream. I couldn't find anything. Do you have any approach to suggest? Do you use the Child/Parent group often? It seems like it could become quite messy.. Any comment is very appreciated Thank you in advance
Looking for anyone who has used the CVRC() function successfully in their Cube Views. If so, is there anything special you are doing with the syntax for the Row or Column Index #?According to the OS documentation, I should be able to simply do this: GetDataCell(CVRC(RowName,RowIndex,ColumnName,ColumnIndex).... ETC.) Example: GetDataCell(CVRC(MyRowA,1,MyColA,2) + CVRC(MyRowB,2,MyColD,4) But even with the most basic test cube view, the result is always giving me an Invalid Index error.Is there some special way to express the row or column Index # that I'm missing here?Thanks in advance for any advice
Is there an easy or single step way to add a book to run from within another book? Trying to avoid re-creating the book from scratch just to use elsewhere.
SOURCE: ONESTREAM CHAMPIONSHi Team,Just want to understand, can we customize the standard Drill down reports or may be add 2 more rows in there and call some cube view reports from there.https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/7e895d9991933241d561622179a47990f62958d3.jpegCustomized Drill down.jpg701×421 61.3 KB Regards and ThanksDarpan Bhansali
Originally posted by Eric Osmanski 5/15/2020 Is there something up with V#Footnote and V#AuditComment? We have a form where the user needs to enter in comments. There are no conditional input rules in this application or Data Cell Access restrictions on the Cube. If we use V#Annotation, V#Assumptions, or V#VarianceExplanation, then everything is good and the column is open for input. If we use V#Footnote or V#AuditComment, the column is read only. What am I missing?
Hi,Is there a way to find the primary node or secondary node of a member with alternate hierarchies in OneStream like the default parent of a member in Hyperion HFM?
Hello, This is in reference to accepted code sample posted for adding a dimension member through an Extender Business Rule. https://community.onestreamsoftware.com/t5/Accepted-Code-Samples/Extender-Auto-Create-Member/ta-p/6921 SaveMemberInfo Want to understand which tables are impacted by execution of the routine SaveMemberInfo. Does this make entry to the following tables? Member MemberDescription MemberProperty Relationship RelationshipProperty Please mention if I have missed some table here. Also, the article says that audit information is not stored with this save routine. Kindly confirm if below are the audit tables which should have the relevant details: AuditMember AuditMemberDescription AuditMemberProperty AuditRelationship AuditRelationshipProperty Would like to understand in general what information do below tables store? AuditParserDimensionAttributes AuditParserDimensions AuditParserLayouts
Hi All, I am trying to get my member formula to calculate an unbalanced balance sheet and I built a Quick View to see the calculation. However, it does not seem to be calculating anything with the member formula. The following is the member formula under 'Calculation Out of Balance' If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity())) Then api.Data.Calculate("A#Calc_OOB:U1#Manual_Input:F#EndBalLoad:I#None = A#Total_Assets:F#EndBalLoad:I#Top - A#Total_Liability_Equity:U1#Calculations:F#EndBalLoad:I#Top") End If Any guidance would be greatly appreciated!
We have a bunch of related party accounts that need to equal other locations within the company similar to intercompany. It would be nice if this can be added to the IC matching table that is on the workflow. I do not want these to eliminate but have visibility to the locations that these accounts are out of balance. Has anyone dealt with something similar to this and if so how do you go about it?
Hi,Do we have a mechanism to map unmapped item to a holding member ( specific member of the dimension) during the data load to prevent data load failure.Thanks
Hi All - I am attempting to export Stage Data through a Data Management Job using a Business Rule. The customer is hoping to remove some columns from the export and filter down the data by selecting Entity & UD1 prior to the export. Has anyone ever modified the data export sequence extender rule? Thanks, Emily
What is the best approach to choose the first base member in a hierarchy, the following member filters not returning the expected results. E#|CVEntity|.Base.First nor E#|CVEntity|.First.Base or E#|CVEntity|.Children.First.Base Entity keeps pulling in POV as in CV which is a parent the goal is to pick one single member from the hierarchy for Input thanks
I have a tabbed dashboard with three tabs displaying cube views. I would like to give my users the ability to print, export to excel or to pdf with a single action instead of doing so with each cube view individually. I would appreciate any approaches that community can suggest. Thank you.
Hello team, I am trying to get a dump of Yearly data in one table where I will use joins of member table with data records and want to expose this in BI viewer so that analysis can be nicely done on Month on Month, YOY basis etc. however pulling so much data seems problematic and I came to know about a term 'FDX' (Seems Fast data Extraction). Kindly help with some details on it, I could not find any content on this. Thanks Satish
We would like the ability to auto consolidate 2 other constant ex rate scenarios once we have consolidated the main Actual scenario. We want to retain the ability to consolidate the main Actual scenario in isolation also i.e. we don't want to consol all 3 scenarios every time. What would be the best way to do this?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.