Question
Parameter in Ud8
I have a cube view created with a parameters for Scenarios called: Current_scenario and Prior_scenario. BW and BW% are calculated within the cube view report. Accounts are in the rows. Scenario in the columns.
I want to create a Ud8 member that places a “Y” for accounts which meet a criteria for review.
I am new to dynamic calculations (be gentle). I tried the scrip below but I don't think this is going to work.
| Dim selectedAcct As Member = api.Pov.Account |
| Dim selectedScen As Member = api.Pov.Scenario |
| Dim selectedTime As Member = api.Pov.Time |
| Dim ParentRow As Decimal = api.Data.GetDataCell("T#[" + selectedTime.Name + "]:U8#None:S#"+selectedScen.name:V#MTD:A#"+selectedAcct.Name).CellAmount |
| Dim ParentRow2 As Decimal = api.Data.GetDataCell("T#[" + selectedTime.Name + "]:U8#None:S#"+selectedScen.name:V#MTD:A#"+selectedAcct.Name).CellAmount |
| Dim Result1 As String = "" |
| Dim Result2 As String = "Y" |
| If (Not selectedAcct Is Nothing) Then |
| If ((ParentRow-ParentRow2)>=100000 And ((((ParentRow-ParentRow2)/ParentRow2)*100)>=10 Or (((ParentRow-ParentRow2)/ParentRow2)*100)<=-10)) Or ((ParentRow-ParentRow2)<=-100000 And ((((ParentRow-ParentRow2)/ParentRow2)*100)<=-10 Or (((ParentRow-ParentRow2)/ParentRow2)*100)>=10))Then |
| Return Result2 |
| Else |
| Return Result1 |
| End If |
| Return Result1 |
| End If |