Creating a TDV View using an SAP Hana Data Source
SAP Hana has several unique data structures that can be introspected and brought into TDV. Because those structures are unique to SAP Hana you need to work with them in a specific way to get the results that are expected.
To create a view using an SAP Hana data source
1. Create a view that selects all the columns from the graphical view or calculation.
2. Create the aggregate function.
3. Refer to that aggregate function from within a view that selects all the columns from the graphical view or calculation.
For example:
select count from (select *from graphical_view_name)
where condition
select count from (
select* from "_SYS_BIC"."eps-staging.salesDiscountGuidance.Cubes/DEALS_F")
where site_id=5310563