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.