Dinamic Data Reader

unknown

Hi community,

I've the following issue to solve.

I have a manual SQL that populates a cube, I need to dinamically pass a parameter in the query

in order to let the user "move between days" on a comparison column.

 

I would like to let the user populate a field somewhere where he can write the desired number of days (@UserInputDays variable) in order to dinamically populate the comparison cube.

 

Is there a way to improve this solution? I sow here that for SAP connector something is available.

 

Kind regards,

Marco

 

Helmut Heimann

Hi Marco Balduini,

 

you could achieve that using a ROLAP cube where the user can enter the number of days. You'd have to build a JOIN in your manual SQL statement using both your source table and the ROLAP (or use a sub-select to derive the number of days from the ROLAP and put this in your SQL (instead of the "@UserInputDays")).

 

Kind Regards,

Helmut