Cubes

101 Topics

Fetching 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)
Solved
dinishkrishna
2 months ago Place Application Build
118Views
0likes
8Comments
TransformationEventHandler & 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?
Solved
SWilyums
2 months ago Place Application Build
3.2KViews
0likes
4Comments
Dynamic Cube services
Hi All, I am trying to explore and use Dynamic cube services for one of the requirements however not sure where to start on this. Could you please help me with some inputs around this if anyone has implemented this ? Thank you.
Solved
Ganeshk12
2 months ago Place Application Build
1KViews
0likes
3Comments
Report Designer
I would like to create the Report that runs to multiple Entities and my table of content would be list of Entity. I would like to make use of report designer component which is in OneStream . Can someone please help me understand how to do that
NoorMohd
2 months ago Place Application Build
12Views
0likes
0Comments
Ho 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.
OSAdmin
2 months ago Place Application Build
2.3KViews
2likes
4Comments
Cube 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?
Archana
2 months ago Place Application Build
48Views
0likes
7Comments
Cube 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'
Archana
2 months ago Place Application Build
85Views
0likes
14Comments
Attribute 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 ? Thanks
Keyser_Soze
3 months ago Place Application Build
46Views
0likes
2Comments
Org by period Config
I've heard about org by period since my first exposure to OneStream but I see nothing in the docs and no clear discussion about how it works or what the limitations/requirements are. Where does this information live?
Solved
photon
3 months ago Place Application Build
69Views
0likes
6Comments
Export Data of Selected Parameter
Hi All, I am trying to create the dashboard where I pass all dimension from combo box to button taht triggers the DM sequence that has the Export Data step. I get the following error mentioned below. FYI please see the screenshot of the export data step mentioned below. Can someone please help where I am going wrong please help me with the approach. Thank you
NoorMohd
3 months ago Place Application Build
49Views
0likes
6Comments