Dynamic Hyperlinks from crosstab data

[shyam_uthaman]

Hi All,

There is a requirement wherein we need to derive data from HANA views dynamically.

For example if a crosstab record shows the below data.

Report Name

ABC

XYZ

MNO

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.

Regards,
Shyam

[IngoH · Accepted solution]

Hello Shyam,

just to clarify the requirement.

- you have a crosstab showing the list of "report name" as shown above.

- you would like to click on a row in the crosstab and the change the data source of a specific component to a specific "Hana view" - correct ?

if that is what you looking for then it sounds you prefer to have a single data source for the actual data and would like to change the definition of the data source at runtime.

the data source has a method called .assignDataSource which allows that.

regards

Ingo Hilgefort, Visual BI