Forum Discussion
I did something like that to show different sets of rows based on the Entity the user had selected. It was a long time ago but assuming that in your case Time is going to drive the Col set do something like this:
1. Create a Parameter with the Time Values the user will select: eg |!Time!| (will leave up to you the type you want that to be)
2. Create a second Parameter: eg |!Time_Selected!|, Type Literal Value, Default Value: |!Time!|
3. Create a third Parameter: eg |!Report Col Set!|, Type: Literal Value, Default Value: XFBR("Name of your BR", "Name of your Function", Time = |!Time_Selected!|). I had issues trying to bound this step with the first one so I had to create the second parameter for it to work. Also, there are limitations on XFBR business rules I couldn't figure out a way to pass the POV to the BR so I pass that through the arguments of the function. This is the Parameter that you are going to use on your CV Col Sharing.
4. Create your BR
If args.FunctionName.XFEqualsIgnoreCase("Name of your Function") Then
Dim TimePoV As String = args.NameValuePairs.XFGetValue("Time")
If TimePoV= "Q1" Then
Return "Q1 Col Set" 'This should be the name of the cv col set your will be using for Q1
ElseIf TimePoV= "Q1" Then
Return "Q2 Col Set"
'Continue listing your Time Periods and then return the Col Set you will be using for that
End If
End If
Hope that gives you some direction. If you are going to use this in a form, this will not work for Form Type Cube View, you will have to do a Form Type Dashboard and create a Dashboard with your CV and attach that to your form.
Hernan
Ps: not a consultant, just an FPA guy eager to learn new things and not afraid of testing stuff out...
Related Content
- 2 years ago
- 4 years ago
- 4 years ago