darshansomaiah1
Participant
Member since ‎2015 Mar 14

User Statistics

  • 53 Posts
  • 4 Solutions
  • 5 Kudos given
  • 0 Kudos received

User Activity

Wild card entry for ? (Question mark) in the NVARCHAR column in HANA expression in calculation view

2020 Jan 20
Dear Team, In a SLT table AUSP, we have a column OBJEK and business needs to fetch the OBJEK which starts with ? (Symbol). I tried with below cases in expression editor of Projection in a view and it did not work. Option 1: match("OBJEK",'?*') ...

How to design using graphical calculation model for User name (Session user) detail as output

2017 Oct 01
Dear Moderators - Before posting this question, I had referred the archived post on the same request, but it was not answered. https://archive.sap.com/discussions/thread/3526738 Hence, request not to close this thread. Dear SCN Team Member...

HANA Modeling: Table function in Join node is not fetching data

2017 May 10
Dear SCN Members, lars.breddemann,I have created a table function which fetches the data from 0 to 23 as Hours i.e., using a Time series in sqlscript as follows: FUNCTION "SCHEMA_A"."TF_TRIP_HOURS"() RETURNS TABLE("TRIP_HOURS" Integer,"DUMMY_MEASURE"...

Calculation views design: Maximum number of materials used for each Material Type at a given date

2017 Feb 05
Dear SCN Members,lars.breddemann,In finding the “Maximum number of materials used for each Material Type at a given date” (On three Material Types).Projection 1:Material Type (Filter = Material Type A)Material Start Date TimeFlag = 1Projection 2:Mate...

Need help on generation of time series using Calculation view

2016 Dec 04
Dear SCN Members,lars.breddemann,Following is the method which I am using for generating time series for the two dates of different available in a table i.e., 'Start Date' and 'End Date' columns.- Created a calculation view (Graphical) to get the max...
View more
Kudos given to