Cube View formatting
Have a question regarding Cube view formatting. The client has a column for comments where large commentaries are written point wise which currently are seen as one line. They want to view the same like excel where comments are seen point wise one below another. How can the same be done. Also while exporting the report in excel the wrap text option in the Column cell format under excel only wraps the entire cell but it does not show the comment point wise one below another5Views0likes0CommentsFetching text property by time
Hi, I'm trying to display a time-variant text property of the UD1 dimension member in a report. The challenge is that the text value can exist in any period of the member, so I currently loop through the forecast periods (spanning two years) to retrieve the values. While the code works, its performance is not good. Is there a way to fetch or look up the text properties by time (possibly from a specific table) without iterating through all periods? Any command or optimized approach to achieve this efficiently would be highly appreciated. Dim Date As String = $"{year}M{month}" Dim timeID As Integer = timedimhelper.getidfromname("Date") Dim myVaryByTimeId As Integer = BRApi.Finance.Members.GetMemberId(si,DimType.Time.Id, Date) Dim mbrText As String = BRApi.Finance.UD.Text(si, 9, mbrId, 1, -1, myVaryByTimeId)Solved95Views0likes8CommentsTransformationEventHandler & ExecuteFileHarvestBatch
Hello, Our transformationeventhandler rule adds missing UD1 members to an unmapped parent. The rule works and has been for a few months. A couple of weeks ago I built a business rule which leverages the utitlity "ExecuteFileHarvestBatch". I have the relevant settings as True. Dim valTransform As Boolean = True Dim valInterest As Boolean = True Dim loadCube As Boolean = True Dim processCube As Boolean = True The batch rule was built so I could schedule the data load. What I am noticing, is when the scheduled job (which calls a DM job with the rule) runs there are failures because of missing UD1 members. If I, then run the import/validate/Load and Process steps manually there are no errors and the missing UD1 members get added. It is as if the TransformationEventHandler is not being executed when the import process runs via the scheduler/dm job/rule. Any ideas for suggestions of where to look?Solved3.2KViews0likes4CommentsHo to extract a hierarchy for any dimension in Level format in OneStream?
Originally posted by Vignesh Mohan Hi, How can we extract the hierarchy of any dimension in an excel in a Level based format starting from top most level to the bottom most level for every base member ? Basically I do not want a Parent-Child format extract. Please find the attachments for the sample screen shot.2.3KViews2likes4CommentsCube View Group - Forms
Hi, I'm trying to figure out how can I make few rows as un editable. Example: highlighted rows in below screenshot. I remember this can be done through Row overrides but its not working. In column member filter, I defined two dimensions as below. What should I define in Row override to have 'Total Revenues', 'Total Expense' and 'Personal' rows un editable?45Views0likes7CommentsCube View
Hi, I'm trying to create a form with set of accounts in rows and column should be for adding the adjustments. Here, I do not required to pull any data from the cube. Instead I have to update the adjustments based on the scenario selected. This should be a separate form where the adjustments data should not update the existing forecast data. POV: Parameters in POV are defined to pull the accounts accordingly. Rows: Columns: Issue: I couldn't get the form with editable fields. refer screenshot below. FYI: Can Modify data for Column is set to 'True'85Views0likes14CommentsAttribute Members on Entity Dimension Do Not Translate ?
I'm using attribute members, unfortunately on the entity dimension, so the associated data is stored and not dynamically calculated on Parent Entities. These attributes members do not translate to foreign currencies during the consolidation process ! I'm using a 'Custom Translation', and when I execute the method 'Api.Data.Calculate()' or 'Api.Data.CalculateForTranslation()' the attribute cells do not translate. The only way I was able to actually convert them is by using Data Buffers and forcing the conversion. Is there a reason why ADC methods do not translate attributes ? Is there a hidden property to activate in order to take these members into account ? Should I use 'Api.Data.Translate()' instead of ADC ? Thanks42Views0likes2Comments