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.
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.
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
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.
André Arnaud de Cal... 291,759 Super User 2024 Season 2
Martin Dráb 230,468 Most Valuable Professional
nmaenpaa 101,156