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

[Ando]

•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.

[PatrickWWiggett]

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?

[Ando]

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

[Michel_Sabourin]

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]

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

[Michel_Sabourin]

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.

[adriaans]

Thank you, Michel. Will give that a go!