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?