The below links explains how to get the Dimensions, Measures Dynamically in the View.
And you are using the Cubes, So what i am thinking, You have to mention Hierarchy & Field in the Calculation.
Yeah Kumar I have already implemented this using some excel dummy data, but when I work with SAP BW (BEX Queries) this functionality is helpless.
I assume you have seen these articles:
Maybe something of help in here...
I did not work on Tableau, Cubes Combination.
But have you tried using Level related Functions in the Calculated fields.?
I gone through the links which you shared, in fact I used WINDOW_SUM, it works fine in the worksheet, but when I pull the parameter in the dashboard its not working even if I select different KPI's.