Forum Discussion

MatthieuR's avatar
MatthieuR
New Contributor III
12 days ago
Solved

"In Use" property: Time and Scenario Dependent maintenance

Hello All, for our project, we are using the In Use property in UD2 with the Time/Scenario dependency option. Seems to work but the problem for us and also raised by customer is the maintenance part of it. We showed them how to use Grid View but with that we are not able to see how this In Use property is configured by scenario and time. Grid View only shows In Use ticked box everywhere even if we set it to False for some scenario/time combinations. This is really a drawback for us now in implementation phase and for them in the future to administer this application. Does anybody that used scenario/time dependant set up (whether for in use property or for any text attributes, that would be same problem) had a good way to maintain this property without having to go one by one in each member to see what is configured and update it ? Or did you achieve differently the requirement to handle the fact to activate/inactivate some members over time without using the In Use property ? Thank you in advance for your support and feedbacks on that!

Metadata
Methodology
User Interface
  • T_Kress's avatar
    T_Kress
    12 days ago

    You should be able to set up a dynamically calculated U8 reporting member that looks like this::

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

If viewMember.IsAnnotationType Then
	If viewMember.Name = "Annotation" Then 
		Return api.UD1.InUse(api.Pov.UD1.MemberId, True, True)	
	End If
End If

    The first "True" is vary by scenario and the second is vary by time.

    In this way you can pull V#Annotation:U8#U1InUse

    On a cube view and it will show when it has changed from True to False or vice versa.

  • T_Kress's avatar
    T_Kress
    Valued Contributor
    12 days ago

    You should be able to set up a dynamically calculated U8 reporting member that looks like this::

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

If viewMember.IsAnnotationType Then
	If viewMember.Name = "Annotation" Then 
		Return api.UD1.InUse(api.Pov.UD1.MemberId, True, True)	
	End If
End If

    The first "True" is vary by scenario and the second is vary by time.

    In this way you can pull V#Annotation:U8#U1InUse

    On a cube view and it will show when it has changed from True to False or vice versa.

  • MarcR's avatar
    MarcR
    VIP
    9 days ago

    Hi Mattieu, it depends where your (in)active is comming from. if its manual entry you could create a SQL component linked to a custom table where you have the user update it and write a business rule that updates the properties of the UD2. But that is quite some coding. An alternative is using Application Control Manager. This solution is build for requesting changes but it also has a 'bulk insert/ update' where you can read a table or a file and have it change the metadata for you. Setting this up is quite ok (and well documented) but would work better if you have the (in)active available in an external system that you can access, otherwise you can still link it to a custom table with a SQL compnent.

  • MatthieuR's avatar
    MatthieuR
    New Contributor III
    10 days ago

    Hello Teresa,

    Thanks for your help, it allows indeed to view the current value of this property by time/scenario. But if needed to be update, we still have to go member by member in dimension library or do we have other (better) alternatives ?

    Thank you