Retrieve account in a row based on account parameter in columns

Question

Hi,&nbsp;I have a Cube View where I expand accounts to report on columns using a parameter (each parameter choice generates three different columns, but all regarded as Col1). This is a specification of what is reported in the Balance sheet on two specific accounts.Parameter has choices: AccountA, AccountBAnd the report shows AccountA1, AccountA2, AccountA3 or AccountB1, AccountB2, AccountB3.I want to add a row which retrieves data reported in the balance sheet so I can reconcile the reporting in this form/CV against the balance sheet.Do I have to create a business rule for this and if so, how?I want row3 to show either AccountX or Account Y based on if I have chosen AccountA or AccountB in the parameter.

Mike_Sabourin · Answer

You would need an XFBR to do this. Is there a tag or text field being used to determine whether an account is A or B, or is it by the name? If you can tell me how the formula would delineate the two, I can help you put together the XFBR to run it.

Filip · Answer

Hi,&nbsp;Thank you so much.&nbsp;This is what my CubeView looks like now.&nbsp;&nbsp;Parameter&nbsp; AccountA&nbsp;&nbsp;&nbsp;Parameter AccountB&nbsp;&nbsp;&nbsp;Col1&nbsp;&nbsp;&nbsp;Col1&nbsp;&nbsp;&nbsp;AccountA1AccountA2AccountA3&nbsp;AccountB1AccountB2AccountB3Row1 = UD5.Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Row2 = UD5.TotalRetrieve account from Finance based on ParameterNo account neededNo account needed&nbsp;Retrieve account from Finance based on ParameterNo account neededNo account neededRow3 = VarianceVariance Row2-Row1No variance neededNo variance needed&nbsp;Variance Row2-Row1No variance neededNo variance needed&nbsp;I can add the account I want to reconcile against in Text6 for either the parameter account (AccountA) or in the account that is populated from choosing the parameter (AccountA1).&nbsp;Does this explain my problem or am I just making you more confused? 🙂

Forum Discussion

Retrieve account in a row based on account parameter in columns

Related Content

Retrieve field value for account dimension member

Is IC Account parameter

Parameters

XFget to retrieve name from description

Retrieve member name

	Parameter AccountA			Parameter AccountB
	Col1			Col1
	AccountA1	AccountA2	AccountA3	AccountB1	AccountB2	AccountB3
Row1 = UD5.Base
Row2 = UD5.Total	Retrieve account from Finance based on Parameter	No account needed	No account needed	Retrieve account from Finance based on Parameter	No account needed	No account needed
Row3 = Variance	Variance Row2-Row1	No variance needed	No variance needed	Variance Row2-Row1	No variance needed	No variance needed