Consume BEx Query in Tableau

Hi All,

There is a requirement to create a Dashboard, preferably in Tableau by using an existing BeX query output(for reference & reporting).

Tried to achieve this by using options such as APD(Analysis Process Designer), Open Hub Destination to bring the query output ti a Ztable/DSO but it throws the below error limitations (non-supporting BeX features)

1. "Structure" used in BEx rows/column

2. Variable input based on user data requirement either monthly/quarterly/YTD From-To

3. G/L Hierarchy in BIW (RSH1 tcode)

Any suggestions/thoughts how this can be overcome/achieved?

Regards,

Sayed Zubair