Monthly vs Yearly Cube View Data
Hello everyone! I require some assistance regarding the following objectives that I have in mind for this cube view. Showing the monthly data input cells (which I have done), along with the total sum of all the months in the year. Getting a percentage by using the monthly data / current year. Currently, the Amount 227.00 under actuals - 2025 column is a member filter under rows/columns whereby i use getDataCell(CVC(Col, 1) + CVC(Col, 2) .... CVC(Col, 12)) which I know it isn't the best idea. But I want the column under 'Total' to show this amount and with this amount, I will calculate the percentage in the next table. For example, on the 2nd table (green cells), on row ACTYPE001, when the user click calculate, the answer should be 1/227 x 100 = 0.44% at Jan 2025, 2/227 x 100 = 0.88% at Feb 2025. Please advice on how I should approach these issues or any improvement or suggestion I should be doing.24Views0likes1CommentEntity - In Use Feature
Hi all, We have a situation where an Entity was created and incorrectly set up and contains data for period 2024M12 and 2025M3. We decided to create a new Entity and updated the transformation rules to ensure that the data loaded goes to the newly created member and not the old one. We have set the consolidation and ownership percentage of the old entity to 0 as added measure. We are now faced with the challenge of not deleting the member as it contains data. Kindly asking if it is advisable to set the In Use feature in this scenario and is there any impact that would cause. Thanks in advance.22Views0likes1CommentAdd culture to user security
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!Solved24Views0likes4CommentsAccount is invalid due to Aggregation property
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.13Views0likes2CommentsCan we write a dynamic calc in Scenario member
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?26Views0likes1CommentOrphan Members
Hi Team, I have a question around the orphan members. I know that when we remove the relationship, the member gets moved under the Orphan section. After moving to the Orphan section, can we load data into the member through the Workflows? Thanks in advance AKSolved2.7KViews0likes7CommentsFetching 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)Solved123Views0likes8Comments