Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Add all cost centers as rows in Management Reporter

(0) ShareShare
ReportReport
Posted on by 469

Hi, 

I would like to know how to dynamically add all the cost centers are rows in MR. Also I want them to be displayed based on the reporting tree.

Cost center financial dimension is labled as Branch. I believe I need to use the option of insert rows from Dimensions. But I don't know how to restrict it to only Branch(cost center) dimension it is always bringing the list of all main accounts. All I need is the list of Branch(cost center) dimension. 

I tried to make the main account empty but it won't work. Also I am not able to enter values in the dimension range start, end rows.

Thanks,

pastedimage1630620433722v1.png

  • Suggested answer
    Hossam EL Hassan Profile Picture
    469 on at
    RE: Add all cost centers as rows in Management Reporter

    Thank you, it worked

  • Verified answer
    EDJJR Profile Picture
    on at
    RE: Add all cost centers as rows in Management Reporter

    Hello Hossam, 

    If you want to add just Cost Center then have all dimensions set to "#####" and then under Cost Center change that to be ""&&&&&&&". 

    Click "Ok" and that should load all of your Cost Center accounts into the Tree. 

    Any questions please let me know. 

    Thank you, 

    Erik Johnson

    Microsoft

  • Verified answer
    saurabh bharti Profile Picture
    15,033 Super User 2025 Season 1 on at
    RE: Add all cost centers as rows in Management Reporter

    Hi Can you try having &&&& for branch and ##### for rest everything?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,996 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans