view the POV of the datacell executing BusinessRule.DashboardStringFunction XFBR business rule?
How do I view the POV of the datacell executing BusinessRule.DashboardStringFunction XFBR business rule? I think I can run this statement: Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = " & viewMember.tostring) Is there a faster way to view all 10 dimesions in POV of the datacell ? These do not work: Dim POV As POV = ViewMember.GetItem(api.Pov.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = " & POV.tostring)Solved5.7KViews0likes10CommentsWhere clause in Member Filter Builder
Source: Migrated from Champions I’m trying to use the below member filter to remove only the intercompany accounts. This works, but I lose the indents from using Tree Descendants. A#410000.TreeDescendants.Where(IsIC = False) Is there a workaround to remove just the IC accounts while still retaining the indents from tree descendants?Solved4.6KViews1like3Comments
Returning Value of a parameter in a XFBR
Hi OneStreamers, I am trying to build an XFBR which I will link to a CV Column, that will either "True" or "False" Depending on the value of a parameter. However I am finding trouble returning the value. I came up with this but it seems tor eturn the Default Value of the parameter and not the Selected Value : "If args.FunctionName.XFEqualsIgnoreCase("CheckScnForVisibleColumn") Then Dim ScnParamName As String = "3_cm_param_S_SelectFC" Dim ScnParamValue As String = "" ScnParamValue = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, ScnParamName) brapi.ErrorLog.LogMessage(si,ScnParamValue)" Appreciate your help 🙂 Regards, AdamSolved4.3KViews0likes2Comments
Accessing predefined substitution variables in Business Rules
Hi, I can't seem to find a method in the api that accepts a substitutionvariable object and returns the string value of that substitution variable. Or just get a dictionary of all predefined substitution variables and their values. Is this or something similar available?Solved4.1KViews0likes7Commentssort by ascending order of values NR in column B in Cubeview?
OneStream is the best EPM app for consolidation and everything planning - it is going to kill Hyperion / Essbase !! Does anyone have a sample business rule BR for sorting rows in a column based on values in a column. e.g. in screen shot, I want to sort by ascending order of values (NR) in column B in Cubeview? I probably have a written something similar long time ago, but would like to see if someone else wrote a better BR.Solved3.8KViews0likes6CommentsUse BusinessRule.DashboardStringFunction XFBR string rules to extract text out of V#Annotations?
Happy Labor Day!! How can I use BusinessRule.DashboardStringFunction, i.e. XFBR string business rules to extract text out of a datacell in cubeview that has users' text stored in V#Annotations? We have successfully used XFBR string business rules to extract amounts from datacell in cubeview. However, when I tried similar lines of XFBR code in my cubeview – I am not able to pull users’ text. It is returning zero. Users are putting text into CV cell that has this combination - A#Explaination:U8#Comment:V#Annotations . Here are a few lines the don’t seem to work 1) Dim Explain As DataCell Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, cube,"A#Explaination:U8#Comment:V#Annotations" ).DataCellEx.DataCell 2) I tried the next line: Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"A#Explaination:U8#Comment:V#Annotations" ).DataCellAnnotation but I get the error message : " Does not recognize .DataCellAnnotation. 1) Error at line 71: 'DataCellAnnotation' is not a member of 'DataCellInfoUsingMemberScript'. "Solved3.3KViews0likes3Comments
