Dynamic Hyperlinks from crosstab data
There is a requirement wherein we need to derive data from HANA views dynamically.
For example if a crosstab record shows the below data.
Now, if I click on ABC, it should pull data from source view for ABC in HANA.
Each of these records will have a different calculation view as source.
If I create a new datasource for each report, it will no longer be dynamic meaning if a new report EFG comes in tomorrow, I would need to change the report and add a new DS fro EFG. This is something we want to avoid.
Each of these reports have millions of records as data output. So the only one that is clicked should jump to the view.
Please let me know your thoughts on this.