Using GROUP BY and COUNT with an SAP Hana Data Source
Create the base view with GROUP BY to force TDV to select all the columns.
For example
1. Create a View similar to the following which is named NEW_TEST_COUNT:
SELECT * from
/users/composite/admin/SAP/New_SAP_Hana/"PUBLIC"/"eps-staging.salesDiscountGuidance.Cubes::DEALS_F"
group by site_id,
QUOTE_KEY,DEAL_TYPE,
GLOBAL_ULTIMATE_ID,
BUSINESS_ENTITY,
DEALS_LIST_PRICE,
DEALS_NET_PRICE
2. Create a view that uses the count function on NEW_TEST_COUNT, for example:
SELECT
count(*) as TT from
/users/composite/admin/SAP/NEW_TEST_COUNT
where site_id=5310763