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
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
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.
Thank you, Michel. Will give that a go!
