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

(0) Share

Report

Posted on by m.salah297

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.

All responses (2)

Answers (0)

m.salah297 47 on at

Like (0)

Report

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 on at

Like (0)

Report

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.