Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Add all cost centers a...
Finance forum
Answered

Add all cost centers as rows in Management Reporter

Posted on by 467

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

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

    Thank you, it worked

  • Verified answer
    EDJJR Profile Picture
    EDJJR 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
    saurabh bharti 14,932 Super User on at
    RE: Add all cost centers as rows in Management Reporter

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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans