Forum Discussion

Cheryl_Lamkin's avatar
Cheryl_Lamkin
New Contributor II
5 months ago

Account Rec Dashboard - choose entity via combo box instead of WF Profile

Hello.  I am a total rookie with dashboards, and am failing miserably at trying to tweak one for the first time.  OneStream has an existing dashboard for RCM; there is a chart called cht_ReconPreparationStatus_RCM that I want to use, but instead of the entity being populated from the WF Profile, I want the user to be able to choose the entity in a combo box.  I have created a combo box, and I have created an entity parameter for the combo box.  But I'm just kind of lost as to what settings I need to change.  I also assume this needs to be tweaked in the business rule, but I have tried a million different options and can't come up with it. I feel like this should be an easy one, but I clearly still have a lot to learn!   

Combo Box settings (ParamBarEntity is my new parameters i created.  And the Dashboard 3a_scorecard is just a copy of OneStreams 3a_scorecard_RCM that already exists)

ParamBarEntity - my new parameter

Data Adapter: cht_ReconCountPreparationStatus

the total Method Query is: {RCM_HelperQueries}{GetReconCountPreparationStatus}{RoleFilter=[Administrator],RiskLevel=|!ParamBarRiskLevelList!|,wfprofile=|!ParamBarEntity!|}

Chart properties: cht_ReconPreparationStatus (mainly copied from Onestream's existing cht_ReconPreparationStatus_RCM chart) but i added the "Change POV"

 

RCM_HelperQueries{GetReconCountPreparationStatus}

RCM_SolutionHelper{GetReconCountPreparationStatusforChart{

I couldnt find a way to nicely copy and paste the code, so if someone has a tip for that, i'll take it!

Please let me know what other information I can provide. I just want to be able to view this chart using an entity selected from this combo box (it is currently pulling numbers from the entity selected in the WorkFlow)

 

 

 

 

Dashboards
  • pranav46's avatar
    pranav46
    Contributor II
    5 months ago
    'Returns All dimensions in parent/child format including Member Properties 
		        'Fields include Parent, Child, Child Description, RowId, Generation Number, Text1-Text8
				
				Dim sScenarioType As String = args.NameValuePairs.XFGetValue("ScenarioType", String.Empty)
				Dim Time As String = args.NameValuePairs.XFGetValue("Time", String.Empty)
				Dim ScenarioTypeId As Integer = ScenarioType.GetItem(sScenarioType).Id
				Dim TimeId As Integer = BRApi.Finance.Members.GetMemberId(si,dimtypeId.Time,Time)
				Dim FileName As String = args.NameValuePairs.XFGetValue("FileName", String.Empty)

    Here is how you can copy the code. as an e,g I copied the code. There is server task where you can add BR

    Seems like you need to call BR from combo box. Once they select entity it updates your chart.