former_member603683
Explorer
Member since ‎12-11-2018

User Statistics

  • 32 Posts
  • 3 Solutions
  • 0 Kudos given
  • 6 Kudos received

User Activity

Aggregate functions on date field

07-11-2023
Hi, we are using S/4HANA Cloud and the integrated analytics suite. It may not be obvious to me but I am unable to find a way to aggregate by date e.g. MAX(Date)...etc. I know CDS Views (Element Properties -> Aggregation) and Custom Analytical Queri...

How to cast RAW to CHAR in OpenSQL

01-16-2023
Hi, I am new to OpenSQL in S/4HANA Cloud and I need to convert a field that is in the RAW datatype to one that is either CHAR or STRING or equivalent. The below is my code SELECT CAST( sap_uuid AS SSTRING ) AS out1 FROM YY1_CURRENTDATEINTO ( @c...

Geocode enrichment

07-15-2022
Hi all, we are using embedded SAP Analytics Cloud which is part of our S/4HANA Cloud tenant and I was wanting to use a "Geo Map" in a embedded SAC story. I have created a custom business object with Latitude and Longitude fields, however, I am not ...

SAC - relative default value for Input Controls

07-16-2020
Hi all, we are using embedded Analytics Cloud inside our S/4HANA Cloud ERP system. As the title suggests, is there a way to set "relative default values" for some of the input controls such as "Fiscal Year"? For example, the user can select betw...

Odata Query date filters not working

02-18-2020
Hello, I am trying to apply a date filter on a Odata query but no matter what I try I keep on getting the: Invalid parametertype used at function 'gt' (Position: 11) error message. The data type of the field that I am trying to filter on is DT_DB...
View more