Management Reporter - I use "insert rows from dimensions" to get the rows by main account numbers, but is there a way to get a row for each main account + dimension?

(0) Share

Report

Posted on by Russ Times

I use "insert rows from dimensions" to get the rows by main account numbers (1234). That works fine.

But I have other dimensions, such as a department dimension (AAA, BBB). I would like a row for each department dimension and main account so I can have rows for.

AAA1234

BBB1234

and so forth.

Is there an easy way to do this without drilling down on each account # individually?

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

udaY-ch 5,128 on at

Like (0)

Report

Hi

Specify a dimension or range

1.In Report Designer, open the row definition to modify.

2.Double-click a cell in the Link to Financial Dimensions column.

3.In the Dimensions dialog box, double-click a cell under the dimension name.

4.In the dialog box for the dimension, select Individual or range.

5 In the From field, enter the starting dimension, or click Browse to search for available dimensions. To enter a range of dimensions, enter the ending dimension in the To field.

6.Click OK to close the dialog box for the dimension. The Dimensions dialog box displays the updated dimension or range.

7.Click OK to close the Dimensions dialog box.

docs.microsoft.com/.../modify-row-definition-cells-financial-reporting

Uday

Was this reply helpful? Yes No
Russ Times 5 on at

Like (0)

Report

Sorry, let me clarify.

Is there a way to get each row to show not only the main account, but also to have a separate row for each sub dimension of that main account on the main schedule? I can go to the subsequent tabs, but it would be easier to have it on one sheet.

Current report shows main accounts

1000

1001

1002

But I have departments. For example, I would like to see

1000-aaa

1000-bbb

1000-ccc

1001-aaa

1001-bbb

1001-ccc

I hope this clarifies my question.

Was this reply helpful? Yes No
Russ Times 5 on at

Like (0)

Report

The title should be:

I use "insert rows from dimensions" to get the rows by main account numbers, but is there a way to get a row for each sub dimension of the main account.

Was this reply helpful? Yes No
udaY-ch 5,128 on at

Like (0)

Report

Hi

You can find "add dimension value set in a row definition" in the link provided.

Uday

Was this reply helpful? Yes No
Verified answer

MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi Russ,

Please manually fill in the dimension value in the range fields, then click OK. System will automatically fill in the values with the combination that has been used in system.

Was this reply helpful? Yes No
Verified answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi,

When you click on "insert rows from dimensions" just before clicking ok give "&" to all segments in your case )Main Account and Department"

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good morning Russ,

Please have a look at the screenprints that Mattguo shared.

Would be great if you could try this as I believe that this answers your question.

Best regards,

Ludwig

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

Hello Russ,

Is your issue resolved?

Please update us if community need to provide futher help.

Was this reply helpful? Yes No
Russ Times 5 on at

Like (0)

Report

Issue resolved by Saurabh Bharti.

When you click on "insert rows from dimensions" just before clicking ok give "&" to all segments in your case )Main Account and Department"

Thanks to the community!

Was this reply helpful? Yes No