Skip to main content
Ando
Newcomer
Apr 6, 2022 4:26 PM UTC

UD8 Dynamic rule to hide derived values. Does anyone have an example of this UD8 calc?

Ando_0-1649262269991.png

 

•You can set a text color on the Cubeview (i.e black) so all values show in a single colour, which would override the default grey/black.

•You can also use a UD8 dynamic rule to hide derived values in future periods, if necessary.

7 replies

PatrickWWiggett
Apr 7, 2022 8:18 AM UTC

This script won't hide the data, but will allow you to edit the colour of your derived data:

If (IsDerivedData = True) Then TextColor = Transparent

You can put that in your "Cell Format" for your applicable columns/rows.

Not sure if that helps?

    AndoAuthor
    Newcomer
    Apr 7, 2022 12:37 PM UTC

    Would also want it hidden in a quick view in excel and don’t think this would accomplish that

    Mike_Sabourin
    Mike_Sabourin
    Contributor
    Apr 7, 2022 5:01 PM UTC

    I've used this in the past and it has worked. It goes in a UD8 member. I named mine No_Derived, but it can be whatever you want.

    Dim ViewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId)

    ''''''Suppress Derived Data'''''''
    If ViewMember.IsAnnotationType = False Then
    If api.Data.GetDataCell("U8#None").CellStatus.IsDerivedData = False Then
    Return api.Data.GetDataCell("U8#None")
    Else
    Return Nothing
    End If
    Else
    Return Nothing
    End If

      adriaans
      Member
      Aug 24, 2023 7:44 AM UTC

      Hi Michel, 

      Would that dynamic rule apply to all derived data? I am looking to hide only the derived data in future periods.

      Kind regards, 

      Adriaan

        Mike_Sabourin
        Mike_Sabourin
        Contributor
        Aug 24, 2023 1:03 PM UTC

        You could adjust it to look at the time. I have not tested the below, Are you using Global Time? If so, you could add...

        Dim povTime as String = api.Pov.Time.MemberId

        dim GlobalTime as String = BRApi.Workflow.General.GetGlobalTime(si)

        'Convert Times to numerical

        Dim myTime as Integer = povTime.Substring(0,4) & if povTime.Length = 6 then "0" &  povTime.Substring(povTime.Length - 5) else povTime.Substring(povTime.Length - 5) 

        Dim GlblTime as Integer = GlobalTime.Substring(0,4) & if GlobalTime.Length = 6 then "0" &  GlobalTime.Substring(GlobalTime.Length - 5) else GlobalTime.Substring(GlobalTime.Length - 5) 

        if myTime > GlblTime then 

        If ViewMember.IsAnnotationType = False Then
        If api.Data.GetDataCell("U8#None").CellStatus.IsDerivedData = False Then
        Return api.Data.GetDataCell("U8#None")
        Else
        Return Nothing
        End If
        Else
        Return Nothing
        End If

        End If

         

        You may have to tweak this a little bit, as I've written it off the top of my head, but it should be close to what you need. So, if the Global Time is 2023M8, and the pov Time is 2023M9, it will hide the derived data. If the pov Time is 2023M7, it won't.

          salah351
          Newcomer
          Dec 9, 2025 7:23 AM UTC

          Hi, Does anyone know how to hide those grey numbers from excel?

           

          Terms & ConditionsAccessibility statement