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

Question

Hello.&nbsp; I am a total rookie with dashboards, and am failing miserably at trying to tweak one for the first time.&nbsp; 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.&nbsp; I have created a combo box, and I have created an entity parameter for the combo box.&nbsp; But I'm just kind of lost as to what settings I need to change.&nbsp; 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!&nbsp; &nbsp;
Combo Box settings (ParamBarEntity is my new parameters i created.&nbsp; And the Dashboard 3a_scorecard is just a copy of OneStreams 3a_scorecard_RCM that already exists)

ParamBarEntity -&nbsp;my new parameter

Data Adapter: cht_ReconCountPreparationStatus
the total Method Query is:&nbsp;{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"

&nbsp;
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)

&nbsp;
&nbsp;
&nbsp;
&nbsp;

pranav46 · Answer

'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.&nbsp;

Forum Discussion

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

Related Content

Dashboards

Dashboard: XFBR String

NonFinancial Account

Dashboard

Copy account to other account on IC entity