Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

how to add financial dimensions and there values as parameters in ssrs report based on business logic with no query attached

(0) ShareShare
ReportReport
Posted on by 47

I created an ssrs report and it works fine but i can't figure how to put all or certain financial dimensions as static parameters as i don't use AOTt query on that report.

  • m.salah297 Profile Picture
    m.salah297 47 on at
    RE: how to add financial dimensions and there values as parameters in ssrs report based on business logic with no query attached

    Hi Blue Wang

    Yes i do use RDP parameters and all my parameters is working fine but i can't figure how to add that certain parameter as it's linked to many tables i only have 1 default dimension field in the table i need to filter if am using AOT query it will list it to multible parameter like

    Ledger account. main account

    ledger account. financial dimension1

    ledger account. financial dimension2

    i need to do the same but without using AOT Query

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: how to add financial dimensions and there values as parameters in ssrs report based on business logic with no query attached

    HI m.salah297 ,

    Do you use RDP parameters?

    RDP parameters are generated for an RDP data contract as a static parameter.

    You can set all or certain financial dimensions in contract class, then filter in DP class by select statement.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans