Pls refer to openSAP course Introduction to Software Development on SAP HANA (Repeat)You will get the complete idea on Consuming the Data in UI5 Environment
This is Same as the following linkhttp://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10ea4516-2d94-2e10-ebad-90559e44b15e?overridelayout=t…
While designing the bex query , select material-'text'. and you can define the cell for the count. pls check the query property section to find material-text